一个有用的存储过程

truncate table VOC_Sys_Valuation
begin
SET NOCOUNT ON;
    DECLARE @userId varchar(50),@gameId int,@GameName nvarchar(50)
    DECLARE @count int
    SET @count = 0
    SELECT @count = count(*) FROM  VOC_Sys_GameList
    WHILE @count > 0
    BEGIN
        SELECT @gameId = GameID,@GameName=GameName FROM VOC_Sys_GameList where ID=@count
        insert into VOC_Sys_Valuation(GameId,GameName) values(@gameId,@GameName)
        SET @count = @count -1
    END
END

转载于:https://www.cnblogs.com/sihai6b204/archive/2009/05/31/1493038.html