ヅEpisode`√

  declare my_cursor cursor scroll for select pf_id,BedshaftMeter,WatchSpindleMeter,result from UDT_PaperFault where event_num = @event_num open my_cursor fetch next from my_cursor into @pf...

  create function dbo.splitFuhao(@CID nvarchar(2000), @delimiter nchar) returns varchar(60) as begin declare @idx as int declare @count as int declare @tempCID as varchar(50) declare @tempt as...

  stuff((select ','+ltrim(pu_id) from v_prod_unit where UnitCode in ('P1_Down','P2_Dwon') for xml path('')),1,1,'')  

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: 华岭 -- Create date: 2008-10-28 -- Description: 将表数据生成Insert脚本 -- Demo : exe...