读书人

数据库中表中元素赋值有关问题!

发布时间: 2012-01-10 21:26:51 作者: rapoo

数据库中表中元素赋值问题!!!
select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id


update menuInfo set menu_topic where menu_topic in(select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id )

哪错了

[解决办法]
update menuInfo set menu_topic where menu_topic in(select menu_topic from menuInfo,temper where temper_id=menu_id )
[解决办法]
menu_id 是变量?还是SqlCommand中的参数?
如果是变量要改为:
"select menu_topic,temper_id from menuInfo,temper where temper_id = ' " + menu_id + " ' "
如果是SqlCommand中的参数,要改为:
select menu_topic,temper_id from menuInfo,temper where temper_id = @menu_id

读书人网 >C#

热点推荐