DECLARE @id INT
DECLARE @name varchar(100)
DECLARE @all VARCHAR(max)
DECLARE cur CURSOR FOR
SELECT id,[name] from TABLE
OPEN cur
FETCH NEXT from cur into @id,@name
while(@@fetch_status = 0)
BEGIN
set @all = @all + '[' + convert(varchar,@id) + ']' + @name + char(13) + char(10)
END
close cur
DEALLOCATE cur
DECLARE CURSOR FOR的使用
最新推荐文章于 2021-11-26 15:31:40 发布