一个有用的存储过程

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

posted on 2009-05-31 16:46  四海  阅读(232)  评论()    收藏  举报