Question

求助，select多个字段赋值给多个变量，怎么写sql语句

Answer 1

declare @a varchar(100)declare @b varchar(100) select @a = a,@b=b from yourTable