34,593
社区成员
发帖
与我相关
我的任务
分享
declare @time varchar(50), @cmdstr varchar(100), @date varchar(20)
declare @year varchar(10), @month varchar(10), @day varchar(10),@hour varchar(10),@minute varchar(10),@second varchar(10)
declare @path varchar(200)
set @date = getdate() --convert(varchar,getdate(),120)
set @year = year(@date)
set @month = month(@date)
set @day = day(@date)
set @hour = DATEPART(hour,@date)
set @minute = DATEPART(minute,@date)
set @second = DATEPART(second,getdate())
set @time = @year + @month + @day
set @path = 'D:\test\manageraccount' + @time + '.txt'
print @time
--exec master..xp_cmdshell 'BCP "select top 2 * from 数据库名..表名" queryout d:/test/'+@time+'.txt -c -S"." -U"sa" -P"密码"'
EXEC cust2018..xp_cmdshell 'bcp "Select * from cust2018.dbo.manageraccount" queryout '+@path+' -c -T'
print @cmdstr
--EXEC master..xp_cmdshell @cmdstr
go