存储过程的变量赋值问题

[jadesun]

declare @sp_card_number varchar(50) 我在存储过程中设定一个变量

运行这句SELECT语句
select top 1 card_number from card_data where left(card_number,2) = @card_type and no_send='1' and no_employ='1'

然后想把得出的结果card_number赋值给sp_card_number，该怎么写呢？

注：同在一个存储过程中完成

[windindance]

select top 1 @sp_card_number = max(card_number) from card_data where left(card_number,2) = @card_type and no_send='1' and no_employ='1'

[lyl_rabbit]

同一楼上的

[Robin_Fang]

select top 1 @sp_card_number = card_number from card_data where left(card_number,2) = @card_type and no_send='1' and no_employ='1'

[wylyf]

select @sp_card_number = (select top 1 card_number from card_data where left(card_number,2) = @card_type and no_send='1' and no_employ='1')