2013年10月1日

组以逗号分隔的子串及跨平update join

摘要： 下列语句可以对组以逗号分隔的子串 set @device_cd_array += ', ' set @device_cd_array += @nodeid set @device_cd_array = stuff(@device_cd_array, 1,1, '')update时要join表要先set再from update md set LocateNeStatus = @flag from ... 阅读全文

posted @ 2013-10-01 17:30 Orz.. 阅读(246) 评论(0) 推荐(0)

ms_sql:drop and create a job

摘要： /****** Object: Job [syncData_23_00] Script Date: 09/30/2013 16:48:32 ******/Declare @myJobID varchar(256)IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N'syncData_23_00')beginSELECT @myJobID=job_id FROM msdb.dbo.sysjobs_view WHERE name = N'syncData_23_00'EXEC msdb. 阅读全文

posted @ 2013-10-01 15:06 Orz.. 阅读(251) 评论(0) 推荐(0)

导航