declare @sqls nvarchar(4000)
declare @num int
set @num=6
set @sqls='
select top 1 name from tablename
where id in (
select top '+cast(@num as nvarchar(20))+' id from tablename
)'
exec(@sqls)上面可以运行,但怎样把它写成函数然后返回name
declare @num int
set @num=6
set @sqls='
select top 1 name from tablename
where id in (
select top '+cast(@num as nvarchar(20))+' id from tablename
)'
exec(@sqls)上面可以运行,但怎样把它写成函数然后返回name
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货