摘要:
1) DECLARE @object intDECLARE @hr intDECLARE @src varchar(255), @desc varchar(255)Declare @tmp intdeclare @msg varchar(3000)SET @msg='Hello. MS SQL Server 2000. I Love you!!!' --這字串將會被寫到SQL Server的安裝目錄下的Nipsan.Txt文件里面/* 取得SQL Server的安裝路徑*/declare @strPath nvarchar(512)Exec sp_MSGet_Setup_pat 阅读全文
摘要:
declare @ksrq datetimeset @ksrq='2011-2-1'select dateadd(d,a.number,@ksrq) as fDatefrom master..spt_values a where type = 'P' and dateadd(d,a.number,@ksrq) >= convert(varchar(7),@ksrq,120)+'-01'and dateadd(d,a.number,@ksrq) < convert(varchar(7),dateadd(mm,1,@ksrq),120)+ 阅读全文