随笔分类 -  sql server

摘要：set datefirst 1select DATEDIFF(wk,'2011-10-30 ','2011-11-1'),DATEPART(ww, '2011-10-30'),DATEPART(ww, '2011-11-1')返回0,44,45　set datefirst 7select DATEDIFF(wk,'2011-10-30 ','2011-11-1'),DATEPART(ww, '2011-10-30'),DATEPART(ww, '2011-11-1') 阅读全文

摘要：declare @tableId intset @tableId = object_id('Atmonthd') if not exists ( select * from syscolumns where id = @tableId and name = 'OTShift_Hours')begin alter table Atmonthd add OTShift_Hours floaten... 阅读全文

摘要：sp_trace_create 等sp_trace_*系列可以跟踪SQL语句，直接把记录写到Table或者file里，可以不用SQL Server Profiler就可以跟踪SQL了。 阅读全文

摘要：DBCC INDEXDEFRAG (0,Atdailyd,1) DBCC INDEXDEFRAG (0,Atdailyd,2) DBCC INDEXDEFRAG (0,Atdailyd,3) DBCC INDEXDEFRAG (0,Atdailyd,4) 阅读全文

摘要：use msdbgo declare @sJobName sysnamedeclare @sDatabase sysname declare @sCommand nvarchar(3200) set @sDatabase = 'JetHr'set @sJobName = 'Penseesoft Database Backup' set @sCommand = 'backup databa... 阅读全文

摘要：if object_id('tempdb..##TEMPTABLE1') is not null drop table ##TEMPTABLE1 上面一种不检查类型，##TEMPTABLE1可能是view或procedure的名字，完整的检查如下 if exists (select * from tempdb.db... 阅读全文