存储过程中如何将一个变量作为表格的名字

DECLARE @tn varchar(100)
SELECT @tn = 'company'
exec('SELECT * FROM '+@tn)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus