bcp远程导出数据

最新推荐文章于 2021-05-02 07:32:54 发布

feng2375

最新推荐文章于 2021-05-02 07:32:54 发布

阅读量2.2k

点赞数

分类专栏： sql2005技巧文章标签： date sql

本文链接：https://blog.csdn.net/feng2375/article/details/2942449

版权

sql2005技巧专栏收录该内容

39 篇文章 0 订阅

订阅专栏

-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[proc_jsmx_out_temp]
@sql varchar(5000),
@filepath varchar(500),
@msg varchar(5000) output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
    declare @bcp varchar(3000)
    set @bcp = 'bcp " '+@sql+'" queryout '+@filepath+ '   -c -S"127.0.0.1"   -U"sa"   -P"密码"'
    begin tran
    begin try
    exec master..xp_cmdshell'net use //xx.xx.xx.xx/d$/website_new_0111/cwdetai "密码" /user:xx.xx.xx.xx/用户名'
--    exec master..xp_cmdshell 'dir //xx.xx.xx.xx/d$/website_new_0111/cwdetai
    exec master..xp_cmdshell @bcp
--   set @msg=@bcp
    commit
    end try
    begin catch
    rollback
--    set @msg='系统忙，请重新导出'
    set @msg=ERROR_MESSAGE()
    end catch
END