/******* 导出到excel EXEC master..xp_cmdshell ‘bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S”GNETDATA/GNETDATA” -U”sa” -P”"‘ /*********** 导入Excel Select * FROM OpenDataSource( ‘Microsoft.Jet.OLEDB.4.0′, ‘Data Source=”c:\test.xls”;User ID=Admin;Password=;Extended properties=Excel 5.0′)…xa...
--导入数据插入标识列，ID重复则替换，旧表中没有的列用'abc' as Field进行插入
SET IDENTITY_INSERT NetCMS.dbo.NT_channel_video ON
insert into NetCMS.dbo.NT_channel_video(Id,title,ch_videourl,Author,Souce,CreatTime,[Content],NaviContent,ChID,ClassID,OrderID,
isdelpoint,isHTML,isConstr,ConstrTF,TitleITF,TitleBTF,ContentProper...