获取代码表代码字符串

1.       代码表

DM	MC
FB5400510112115R01	大田坝水库
FB5400510112200R01	大石山湾塘
FB5400510113105G01	青白江区日新水泵站
FB5400510113202G01	青白江区福洪乡水泵站

获取代码表代码字符串：’ FB5400510112115R01’,’ FB5400510112200R01’,’ FB5400510113105G01’,’ FB5400510113202G01’

2.       实现代码

Create PROCEDURE [dbo].[GetDMFromATemp]

    -- Add the parameters for the stored procedure here

AS

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

 

    -- Insert statements for procedure here

    declare @name nvarchar(4000)

    declare @nametemp nvarchar(200)

    declare name_cursor cursor for select DM from aTemp order by dm

    set @name = '''';

 

    open name_cursor

    fetch next FROM name_cursor into @nametemp

 

    while @@fetch_status = 0

    begin

       set @name = @name + @nametemp +''','''

       if(len(@name)>3980)

       begin

           print @name

           set @name = '''';

       end

       fetch next from name_cursor into @nametemp

    end

    print @name

    CLOSE name_cursor

    DEALLOCATE name_cursor

END

 

个人推广：http://www.91bjb.com/bbs/?fromuid=57354