demo010.sql

T-SQL示例大全

--参数替换比较
EXEC sp_executesql  N'SELECT name,cur_salary FROM IndexTuneDemo.dbo.vfpman WHERE cur_salary = @salary',
                                 N'@salary money',
                                 72500

EXEC sp_executesql 
           N'SELECT name,cur_salary FROM IndexTuneDemo.dbo.vfpman WHERE cur_salary BETWEEN @salary1 AND @salary2',
           N'@salary1 money,@salary2 money',
           50000,60000