u012172195的博客

分离数据库：[SERVER1_OS(1)_ALG_201810090000_201810151739]附加数据库：EXEC sp_attach_db @dbname = N'SERVER1_OS(1)_ALG_201810090000_201810151739',@filename1 = N'D:\AlarmLogging\SERVER1_OS(1)_ALG_201810090000...

'查询语句Dim strSQL'结果集行数Dim RsCountSet objConnection = CreateObject("ADODB.Connection")'wincc运行数据库strConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Dat...

update 表名 set 记录时间列=dateadd(n,id*5,记录时间列) DateAdd函数DATEADD(datepart,number,date)datepart缩写年yy, yyyy季度qq, q月mm, m年中的日dy, y日dd, d周wk, ww星期dw, w小时hh分钟mi, n秒ss, s毫秒ms微妙mcs纳秒ns按5分钟递增n，表示增加的单位 其他还有小时、秒、天、...

启用TCP/IPOn Error Resume Next'连接对象Dim oCon'数据库连接字符串Dim strCon'结果集对象Dim oRs'执行对象Dim oCmd'查询语句Dim strSQL'结果集行数Dim RsCount,IP,Port,PWD,usr,DBNameSet oCon = CreateObject("ADODB.Connection")...

SQLServer数据库--新建数据库CREATE database DB_BackUpgo--备份表到新建的数据库中（拷贝并创建表）select * into DB_BackUp.dbo.表名 from 表名--复制两个结构相同的表insert into 表名 from DB_BackUp.dbo.表名...

declare @id as intdeclare @lastArchiveTimes as varchar(20)declare @count as intset @count = (select COUNT(*) from TmpTable where ArchiveTimes = '')while @count > 0begin    set @id = (sel