Question

vc中怎样在sql sever插入语句使用变量

vc中怎样在sql sever插入语句使用变量vc中怎样在sql sever插入语句使用变量

Answer 1

1
2
3
4
5

declare @tableName varchar(20)
declare @query varchar(8000)
set @tableName = "yourTableName"
set @query = 'select * from '+@tableName + 'where Sno = 111'
exec(@query)