亡羊补牢

摘要： if exists(select * from master.sys.sysprocesses where spid in (select blocked from master.sys.sysprocesses))begin---确定进程被锁住的其他资源select spid 进程,STATUS ... 阅读全文

摘要： declare @filename varchar(1024)declare @SQLDB varchar(50)declare @path varchar(1024)set @path = N'D:\MSSQLDB\bak\';declare @extension_name varchar(16)... 阅读全文

摘要： -- 获取月度列表if exists(select 1 from sysobjects where name = 'proc_GetDateMonthList' and type = 'p') drop proc proc_GetDateMonthListGOcreate proc proc_Ge... 阅读全文

摘要： USE DBProjectSYGOSELECT OBJECT_SCHEMA_NAME(T.[object_id], DB_ID()) AS [架构名] , T.[name] AS [表名] , AC.[name] AS [列名] , TY.[name] A... 阅读全文

摘要： /******* 导出到excel */EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""' /*********** 导入Excel ... 阅读全文

摘要： windows2003 64位注册码Windows 2003 R2 64bit Enterprise VOL Edition 企业版MR78C-GF2CY-KC864-DTG74-VMT73VPT7T-77D38-KWVW2-2G34P-73GBQBVPPQ-CDPXV-8JBRH-9H9T6-3R... 阅读全文

摘要： MICROSOFT SQL SERVER 2012 DEVELOPER 版序列号：YQWTX-G8T4R-QW4XX-BVH62-GP68YMICROSOFT SQL SERVER 2012 ENTERPRISE SERVER/CAL EDITION 版序列号：748RB-X4T6B-MRM7V-... 阅读全文