不挂科搜题免费

问题:

简述局部变量的声明和赋值方法?

答案:

局部变量的声明: DECLARE @variable_name datatype [ , ... n ] 局部变量的赋值:1 SET @variable_name = expression 2 SELECT @variable_name = expression [ , ... n ] [ FROM... ] [ WHERE... ]