急需要帮助,谢谢了 insert Aselect * from B 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 INSERT A SELECT * FROM B UNION ALL SELECT * FROM C .. --指定字段insert A(col,col2)select col,col2 from B insert into b(col1,col2,col3,...,addcol)select col1,col2,col3,...,'value' from a假设新增的字段为addcol,默认值为'value',字段顺序对应好就可以 insert into zt_PlaceHero(PlaceHero_heroName, PlaceHero_level, PlaceHero_polity, PlaceHero_gest, PlaceHero_ruse, PlaceHero_loyalty, PlaceHero_goldFund, PlaceHero_experience, PlaceHero_potential, PlaceConst_heroStatus, PlaceHero_statusStartDate, PlaceHero_awardStartDate, PlaceHero_picNum, PlaceConst_heroType, PlaceConst_sex, HeroInn_id, HeroPub_id, PlaceHero_levelSort, PlaceHero_gestSort, PlaceHero_politySort, PlaceHero_ruseSort, PlaceKing_id, PlaceSort_level, PlaceSort_ruse, PlaceSort_polity, PlaceSort_gest) select Hero_heroName, Hero_level, Hero_polity, Hero_gest, Hero_ruse, Hero_loyalty, Hero_goldFund, Hero_experience, Hero_potential, Const_heroStatus, Hero_statusStartDate, Hero_awardStartDate, Hero_picNum, Const_heroType, Const_sex, HeroInn_id, HeroPub_id, Hero_levelSort, Hero_gestSort, Hero_politySort, Hero_ruseSort, King_id,'value','value','value','value' from zt_Hero";朋友,我这样写不对的啊!不能被执行的! 如何同时更新多个字段?(更新内容为从另一张表取到) 求SQL2K升级到SQL2005的步骤 bcp导出问题 存储过程:为什么会出现这样的错误???? 改变表结构后,链接服务器 如何重新编译 change the windows module 一个关于随机抽取数字的问题,请大家帮帮忙.感谢! 问题又来了,降序排列 那位大哥大姐帮帮忙,索引怎么用法? 日期形式的字段的check,怎么写? 如何获得表中个字段的字段名? 怎样缩短连接数据库的时间(续)
insert A(col,col2)
select col,col2 from B
select col1,col2,col3,...,'value' from a假设新增的字段为addcol,默认值为'value',字段顺序对应好就可以
insert into zt_PlaceHero
(PlaceHero_heroName, PlaceHero_level, PlaceHero_polity, PlaceHero_gest, PlaceHero_ruse, PlaceHero_loyalty, PlaceHero_goldFund, PlaceHero_experience, PlaceHero_potential, PlaceConst_heroStatus, PlaceHero_statusStartDate, PlaceHero_awardStartDate, PlaceHero_picNum, PlaceConst_heroType, PlaceConst_sex, HeroInn_id, HeroPub_id, PlaceHero_levelSort, PlaceHero_gestSort, PlaceHero_politySort, PlaceHero_ruseSort, PlaceKing_id, PlaceSort_level, PlaceSort_ruse, PlaceSort_polity, PlaceSort_gest)
select Hero_heroName, Hero_level, Hero_polity, Hero_gest, Hero_ruse, Hero_loyalty, Hero_goldFund, Hero_experience, Hero_potential, Const_heroStatus, Hero_statusStartDate, Hero_awardStartDate, Hero_picNum, Const_heroType, Const_sex, HeroInn_id, HeroPub_id, Hero_levelSort, Hero_gestSort, Hero_politySort, Hero_ruseSort, King_id,'value','value','value','value'
from zt_Hero";
朋友,我这样写不对的啊!
不能被执行的!