create proc abc
as
declare @sql varchar(888)
set @sql='select 列A,列B '
set @sql=@sql+'from tablename'
exec(@sql)
as
declare @sql varchar(888)
set @sql='select 列A,列B '
set @sql=@sql+'from tablename'
exec(@sql)
as
set @sql='select 列A,列B '
set @sql=@sql+'from tablename'
exec(@sql)给参数加默认值就可以了.
as
set @sql='select 列A,列B '
set @sql=@sql+'from tablename'
exec(@sql)exec abc @sql
create proc abc(@sql varchar(888))
as
set @sql='select 列A,列B '
set @sql=@sql+'from tablename'
exec(@sql)set @sql='.....' --输入字符串的内容
exec abc @sql