求SQL语句: 表名是变量的SQL语句.如:Str=user,user是表名,Select * from user,语句中如何用Str替换user?
求SQL语句: 表名是变量的SQL语句.如:Str=user,user是表名,Select * from user,语句中如何用Str替换user?
[解决办法]
SQL 中:
declare @str varchar(80)
set @str= 'user '
exec ( 'Select * from '+@str)
BCB 中:
AnsiString str= "user ";
Query1-> SQL-> Text= "Select * from "+str;
Query1-> Open();