Question

Sql server 存储过程中怎么将变量赋值

例如一开始声明一个变量
Declare @CompanyCode nvarchar(100)
......
......
不能用into（向下面这样）？
select ComCode from t_company where ComID = '000001' into @CompanyCode

Answer 1

select @CompanyCode = ComCode from t_company where ComID = '000001'

Answer 2

晕啊，你这个赋值办法。。。哈哈哈哈。
select @CompanyCode = ComCode from t_company where ComID = '000001'

如果是给变量赋常量
select @CompanyCode = 100 类似