最佳答案：DECLARE @n1 int,@n2 varchar(10) set @n1 =(select age from table where column=xxx) set @n2=(select ge

sql中如何给变量赋值

DECLARE @n1 int,@n2 varchar(10) set @n1 =(select age from table where column=xxx) set @n2=(select gender from table where column = xxx ) ------------------ 或者一起赋值 就是楼上那个 DECLARE @n1 int,@n2 varchar(10) select @n1 =age,@n2=gender from table where column = xxx ------------------ select @n1,@n2 就知道变量的值了