下班前结贴哦

[liyingenjoy]

接触数据库时间不长，哪位大侠帮忙下：
set @sqlstr =...
exec (@sqlstr)


其中，希望@sqlstr的值为：

WHILE @idx <= @ToId

	BEGIN 


		set @add=1	--后缀开始值

		select @playername = playername from changename with(nolock) where idx = @idx

		set @newname = @playername+cast(@add as varchar)

		set @ret1 = null

		set @ret2 = null

		select @ret1 = player_id from player0.dbo.playerinfo with(nolock) where playername = @newname

		select @ret2 = player_id from playerinfo with(nolock) where playername = @newname

		while (@ret1 is not null or @ret2 is not null)

		begin

			set @add = @add+1

			set @ret1 = null

			set @ret2 = null

			set @newname=@playername+cast(@add as varchar)

		select @ret1 = player_id from player0.dbo.playerinfo with(nolock) where playername = @newname

		select @ret2 = player_id from playerinfo with(nolock) where playername = @newname			

		end

		update changename set newplayername=@newname where idx=@idx

		SET @idx = @idx+1

	END

应该怎么写呢？？？

[华夏小卒]

哪里有问题？

[aaron_gl]

set @sqlstr=N'你的语句'
print @sqlstr
进行比较下看看有差异吗

[liyingenjoy]

就是说参数的值是很多语句，应该怎么写在set @sqlstr =...这里，等号后面怎么写？

[天-笑]

WHILE @idx <= @ToId

    BEGIN 


        set @add=1    --后缀开始值

        select @playername = playername from changename with(nolock) where idx = @idx

        set @newname = @playername+cast(@add as varchar)

        set @ret1 = null

        set @ret2 = null

        select @ret1 = player_id from player0.dbo.playerinfo with(nolock) where playername = @newname

        select @ret2 = player_id from playerinfo with(nolock) where playername = @newname

        if (@ret1 is not null or @ret2 is not null)

        begin

            set @add = @add+1

            set @ret1 = null

            set @ret2 = null

            set @newname=@playername+cast(@add as varchar)

        select @ret1 = player_id from player0.dbo.playerinfo with(nolock) where playername = @newname

        select @ret2 = player_id from playerinfo with(nolock) where playername = @newname            

        end

        update changename set newplayername=@newname where idx=@idx

        SET @idx = @idx+1

    END

[pt1314917]

好多变量。都慢慢拼接了。为啥需要动态呢？

[明朝2013]

顶顶更健康

[liyingenjoy]

应该怎么写呢？？？急急急！！！

[Andy__Huang]

变量太多了，应该把它写成存储过程

[liyingenjoy]

[Quote=引用 8 楼 hdhai9451 的回复:]
变量太多了，应该把它写成存储过程
[/Quote]
我是菜鸟，具体怎么做？能否说清楚点？

[swuxd]

下班了，LZ没结贴

[liyingenjoy]

sorry，忙忘了，现在补上