iteye_686的博客

[code="sql"]-----------------Create table-----------------------if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ARGRMS_H]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop ta...

[code="sql"]--三個SQL結果相同select DETL_BAT_FIELD from rpt_head where RP_TEMPLET in (3,4) and isnull(DETL_BAT_FIELD,'')'' and COM_NO='00'declare @rp_templet varchar(10)set @rp_templet='3,4'sele...

[code="sql"] --SQL2000與SQL2005通用 --清空日誌 DUMP TRANSACTION 數據庫名 WITH NO_LOG GO --截斷事務日誌 BACKUP LOG 數據庫名 WITH NO_LOG GO --收縮數據庫 DBC...

[code="sql"] BEGIN------------------宣告變數-------------------- declare @str varchar(500) declare @split varchar(1) declare @splitlen int declare @tem...

[code="sql"]----取得日期'20090110',兩個月後的最後一天----declare @dates varchar (10)set @dates='20090110'----日期'20090110',月份加3----select dateadd(m,3,@dates)----日期'20090110',月份加3後,取年月----select conv...