数据库批量操作

（局限于本公司）假如数据库备份，可以用任务中的“复制数据库”， 本人操作经验得出 select * from tripjdrc.dbo.ad tripjdrc 数据库 dbo 数据库拥有者   ad 是个表 是正确的 写的一个语句为： INSERT INTO [tripjdrc].[dbo].[company] select [chok]            ,[userId]            ,[uname]            ,[pwd]            ,[email]            ,[idate]            ,[cname]            ,[trade]            ,[cxz]            ,[fdate]            ,[yuangong]            ,[sex]            ,[rstel]            ,[renshi]            ,[pnames]            ,[fund]            ,[address]            ,[cypic]            ,[zip]            ,[pname]            ,[phone]            ,[fax]            ,[http]            ,[url868e]            ,[areaId]            ,[area]            ,[cityId]            ,[city]            ,[faren]            ,[jianj]            ,[click]            ,[addtime]            ,[memberType]            ,[memberTime]            ,[viewTimes]            ,[clickTimes]            ,[type]            ,[remark]            ,[star]            ,[mobile]            ,[phone_hidden]            ,[fax_hidden]            ,[rstel_hidden]            ,[email_hidden]            ,[mobile_hidden]            ,[loginTimes]            ,[loginIP]            ,[loginArea]            ,[loginDate]            ,[loginDate_history]            ,[isZh]            ,[old_memberType]            ,[old_memberTime]            ,[hope_memberType]            ,[memberPrice]            ,[old_memberPrice]            ,[priceMemo]            ,[mail_confirmReply]            ,[mail_justSosoReply]            ,[mail_refuseReply]            ,[mail_confirmInvite]            ,[mail_intentInvite]            ,[mail_autoReply]            ,[isRepeat]            ,[isAddByJdrc]            ,[isAcceptSMS]            ,[isAcceptEmail]            ,[isSendSMS]            ,[salesUserName]            ,[salesTrueName]            ,[salesHistory]            ,[CompanyTemplet]            ,[JobTemplet]            ,[business_userid]            ,[custtype]            ,[dOrder]            ,[BigCustSalesUserName]            ,[BigCustSalesTrueName]            ,[Constructstopdate]            ,[isConstruction]            ,[IsInteHotelChains]            ,[orderNum]            ,[TitColor]            ,[mark] from  [tripjdrc_new12].[dbo].[company] where zip='' or logintimes='1'and DateDiff(d,logindate,getdate())>301