demo011.sql

来自「T-SQL示例大全」· SQL 代码 · 共 37 行

DECLARE @SQLString nvarchar(500)
DECLARE @ParmDefinition nvarchar(500)
DECLARE @ParmValue1 nvarchar(10),@ParmValue2 money,@ParmValue3 money


--建立所要动态执行 SQL 字符串
SET @SQLString = N'USE IndexTuneDemo'+CHAR(13)
SET @SQLString = @SQLString + 
        N'SELECT * FROM vfpman WHERE department = @department AND cur_salary BETWEEN @salary1 AND @salary2'

--定义各个参数的数据类型
SET @ParmDefinition = N'@department nvarchar(10),@salary1 money,@salary2 money'

--设定参数值
SET @ParmValue1 = '资讯部'
SET @ParmValue2 = $40000
SET @ParmValue3 = $50000

--执行 SQL 字符串
EXECUTE sp_executesql @SQLString,
                                       @ParmDefinition,
                                       @ParmValue1,@ParmValue2,@ParmValue3


--将参数设定成其他的值
SET @ParmValue1 = '生产制造部'
SET @ParmValue2 = $60000
SET @ParmValue3 = $70000

--执行 SQL 字符串
EXECUTE sp_executesql @SQLString,
                                       @ParmDefinition,
                                       @ParmValue1,@ParmValue2,@ParmValue3