比如:
DECLARE @SQLString NVARCHAR(500)
DECLARE @ParmDefinition NVARCHAR(500)
DECLARE @IntVariable INT
DECLARE @StringVariable NVARCHAR(100)
DECLARE @Lastlname varchar(30)
SET @SQLString = N'SELECT @LastlnameOUT = max(lname) FROM pubs.dbo.employee WHERE job_lvl = @level and field1 = @myParam'
SET @ParmDefinition = N'@level tinyint, @myParam NVARCHAR(100), @LastlnameOUT varchar(30) OUTPUT'
SET @IntVariable = 35
SET @StringVariable = 'some keyword'
EXECUTE sp_executesql @SQLString, @ParmDefinition, @level = @IntVariable, @myParam=@StringVariable, @LastlnameOUT=@Lastlname OUTPUT
SELECT @Lastlname