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]