dengwen3 发表于 2016-11-2 08:35:28

sql server,sybase相关经验汇总

  BCP 导入导出数据:
  导出 EXEC master..xp_cmdshell 'bcp "select * from atdemo5_c40ps.dbo.stcategory" queryout C:\1.txt -c -U"sa" -P"yourpassword"'
  导入 EXEC master..xp_cmdshell 'BCP atdemo5_c40ps.dbo.stcategory in c:\1.txt -c -T'
页: [1]
查看完整版本: sql server,sybase相关经验汇总