客户端AAA共享一文件夹BBB,然后:
EXEC master..xp_cmdshell 'bcp "SELECT au_fname,au_lname FROM pubs..authors ORDER BY au_lname" queryout "\\AAA\BBB\test.xls" /c -S"Hokkai" /U"sa" -P""'
EXEC master..xp_cmdshell 'bcp "SELECT au_fname,au_lname FROM pubs..authors ORDER BY au_lname" queryout "\\AAA\BBB\test.xls" /c -S"Hokkai" /U"sa" -P""'
我想把这条sql语句用在客户端程序里,一执行就放到本地,
像sql中的导入导出工具那样的!
怎么实现呢?
有谁知道????