string str = "insert into @tablename (username) values(@username)";
==》类似下面那样构造sql语句,tablename为字符串变量。
string str = "insert into "+ tablename "+ "(username) values(@username)";
==》类似下面那样构造sql语句,tablename为字符串变量。
string str = "insert into "+ tablename "+ "(username) values(@username)";
declare @TableName nvarchar(20)
set @SQL="select * from "+@TableName
execute (@SQLString)
基本都是这样用了