简单赋值语句！！请教高手

[littlestoneyi]

我想将结果集中的内容赋给多个变量（因为结果集只有一行中的几个列）

select @city_data_ip=city_data_ip, @city_data_ip = city_data_port,@city_data_port= city_control_ip,@city_control_port city_control_port from net_city where net_city = @city_id



请高手帮忙看看怎么改！！！！

[CrazyFor]

select top 1 @city_data_ip=city_data_ip, @city_data_ip = city_data_port,@city_data_port= city_control_ip,@city_control_port city_control_port from net_city where net_city = @city_id

只有一行时,你上面的语句是没有问题的,多行的话你可以用游标.

[pengdali]

select @city_data_ip=city_data_ip,@city_data_ip=city_data_port,@city_data_port=city_control_ip,@city_control_port=city_control_port from net_city where net_city = @city_id

[CrazyFor]

select top 1 @city_data_ip=city_data_ip, @city_data_ip = city_data_port,@city_data_port= city_control_ip,@city_control_port city_control_port from net_city where net_city = @city_id

只有一行时,你上面的语句是没有问题的,多行的话你可以用游标.

[pengdali]

select @city_data_ip=city_data_ip,@city_data_ip=city_data_port,@city_data_port=city_control_ip,@city_control_port=city_control_port from net_city where net_city = @city_id

[liuyun2003]

你这么写就可以啊。不过第二行应该有一个=号。呵呵~~~

[z5wjz]

首先得声明变量,用declare语句.
declare @city_data_ip1 数据类型,@city_data_ip2 数据类型,
@city_data_port 数据类型,@city_control_port 数据类型,
@city_id 数据类型

set @city_id=ID值 --该变量必须提前有值

select @city_data_ip1=city_data_ip, @city_data_ip2 = city_data_port,@city_data_port= city_control_ip,@city_control_port city_control_port from net_city where net_city = @city_id

[littlestoneyi]

大力： 你写的和我一样啊，在存储过程中出现错误141

[TaoGeGe]

少了一個=號在第二行結尾處