34,575
社区成员
发帖
与我相关
我的任务
分享
Create proc selectALL
@tableName char(20),
@name char(20)
as
declare @sql varchar(1000)
if(@name = '')
set @sql='select * from '+@tableName
else
set @sql='select * from '+ltrim(rtrim(@tableName))+' where name = '+''''+ltrim(rtrim(@name))+''''
PRINT @SQL
exec (@sql)
--语法没什么问题