摘要：
@echo@echo ==========================================================@echo ***** 注意 *****@echo =======================================================... 阅读全文
摘要：
1、建立批处理文件@echooffsetdates=%date:~0,4%%date:~5,2%%date:~8,2%setrar="%Programfiles%\WinRAR\Winrar.exe"setrand=%random%setfolder=d:\DBback\%date%rem 每天创建... 阅读全文
摘要：
日期时间转字符串：1.SelectCONVERT(varchar(100),GETDATE(),0):0516200610:57AM 2.SelectCONVERT(varchar(100),GETDATE(),1):05/16/06 3.SelectCONVERT(varchar(100),GET... 阅读全文
摘要：
UPDATE D SET InPrice = A.InPrice, ClinPrice = A.ClinPriceFROM hisdb..BASE_MedBatch A INNER JOIN hisdb..BASE_Dept C ON A.HospitalID = C.HospitalID AND... 阅读全文
摘要：
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT' kill 53 阅读全文
摘要：
USE hisdbgoDROP INDEX BASE_MedBatch_U_Index ON BASE_MedBatch ; 阅读全文
摘要：
--聚集唯一USE hisdbGOIF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE name = N'DATA_MZPatFeeDetail_UC_Index1' and id = object_id(N'DATA_MZPatFeeDetail'))... 阅读全文
摘要：
USE hisdbGOIF NOT EXISTS(SELECT * FROM syscolumns WHERE id = OBJECT_ID('YB_Match') AND name = 'CenterWBCode') BEGIN ALTER TABLE YB_Match ADD CenterWB... 阅读全文
摘要：
EXEC sp_password NULL,'sa','sa' 阅读全文