62,047
社区成员
发帖
与我相关
我的任务
分享
create proc proc_html
@out varchar(2000) output
as
declare @i int
declare @count int
declare @html varchar(2000)
set @i = 0
set @out = '<ul>'
set @count = (select count(*) from Level1Class)
set @html = '<a href="#">链接</a>'
while @i < @count
begin
set @html = '<li>' + @html + '</li>'
end
set @out = @html + '</ul>'
go
declare @out varchar(2000)
exec proc_html @out output
select @out