declare @username varchar(10),
@sql varchar(8000)
set @sql=''
select @sql=QUOTENAME(deptlevel)+'= '''+ltrim(deptname)+''''
from ta
where username='admin'
exec('select TOP 2 * from tb left join tc on tb.id=tc.id
where ' +@sql )
sql Text
最新推荐文章于 2021-10-12 13:07:33 发布