Question

SQL SERVER 中怎么把表中的数据赋值给存储过程的变量？

Answer 1

declare @id int
select @id = user_id from users where name = '张三' -- 从users表读取张三的user_id，并赋值给变量@id
execute upYourProc @id --将变量传递给存储过程。

Answer 2

declare @id int;
select @id = user_id from users where name = '张三';
execute upYourProc @id --将变量传递给存储过程;