-
编辑 删除
Trigger觸發器
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='trigger_delete'AND TYPE='TR')DROP TRIGGER trigger_deleteGOCREATE TRIGGER [trigger_delete]ON dbo.TableAafter DELETE,insert,updateAS  ...
-
编辑 删除
详细讲解SQL中CONVERT转化函数用法
/*當前日期年月日*/ select convert(nvarchar,getdate(),0) --0 or 100Jul 27 2009 2:46PMselect convert(nvarchar,getdate(),101) --101,美国 07/27/2009select convert(nvarchar,getdate(),102) ...
-
编辑 删除
一些關于日期的計算
select dateadd(m,DATEDIFF(m,'20090601',getdate())+1, '20090601')-1 --最后一天 select dateadd(m,DATEDIFF(m,'20090601',getdate()), '20090601') --第一天 se...
-
编辑 删除
將多行記錄合并成一行
I know how to do this in T-SQL, you use the FOR XML PATH(‘’) construct like so:with t as( select 'Charles' parent, 'William' child union select 'Charles', 'Harry' union select 'Anne', '...
