可以的,比如:
Create Procedure seleme @filed1 Char(20), @myval1 Char(20)
As
Declare @sql @Char(255)
Select @sql = 'Select * From table1 Where ' + @field1 + ' = '@myval1
Execute @sql
Create Procedure seleme @filed1 Char(20), @myval1 Char(20)
As
Declare @sql @Char(255)
Select @sql = 'Select * From table1 Where ' + @field1 + ' = '@myval1
Execute @sql
如果要做其他操作,同意BRENTIVAN的方法,但EXECUTE (@sql) ,应加括号,否则有的语句不能执行成功!