例:带参数的存储过程: CREATE PROCedure sp getemp; 2 @salary int) As SELECT*FROM职工 WHERE工资> salary例：带参数的存储过程： CREATE PROCedure sp_getemp;2 (@salary int) AS SELECT * FROM 职工 WHERE 工资 > @salary