用动态SQL:declare @sql varchar(1000)
select @sql='select * from '+@TableName+ ' where '+ @where
exec (@sql)这里 @TableName,@where都是VARCHAR型的参数
select @sql='select * from '+@TableName+ ' where '+ @where
exec (@sql)这里 @TableName,@where都是VARCHAR型的参数
调试欢乐多
create procedure proc_query
@TableName varchar(100),
@where varchar(1000),
as
declare @sql varchar(2000)
select @sql='select * from '+@TableName+ ' where '+ @where
exec (@sql)
gojsp里能调用存储过程吧!?