27,579
社区成员
发帖
与我相关
我的任务
分享
declare @dd varchar(50)
set @dd=convert(varchar(20),getdate(),112)
exec('EXEC master..xp_cmdshell ''BCP UF.dbo.EX out D:\'+@dd+'.log -c -t , -S 127.0.0.1 -U sa -P 123''')
declare @dd datetime
declare @sql varchar(1000)
set @sql=''
set @dd=getdate()
set @sql='EXEC master..xp_cmdshell ''BCP UF.dbo.EX out D:\'+convert(varchar(10),@dd,120)+'.log -c -t , -S 127.0.0.1 -U sa -P 123'''
exec(@sql)
declare @dd varchar(10)
set @dd=convert(varchar(10),getdate(),112)
declare @cmd varchar(512)
set @cmd = 'BCP UF.dbo.EX out D:\'+@dd+'.log -c -t , -S 127.0.0.1 -U sa -P 123'
EXEC master..xp_cmdshell @cmd
declare @dd datetime
set @dd=getdate()
EXEC master..xp_cmdshell 'BCP UF.dbo.EX out D:\'+convert(char(19),@dd,120)+'.log -c -t,-S 127.0.0.1 -Usa -P123'
declare @dd datetime
set @dd=getdate()
EXEC master..xp_cmdshell 'BCP UF.dbo.EX out D:\'+@dd+'.log -c -t,-S 127.0.0.1 -Usa -P123'
declare @dd datetime
set @dd=getdate()
EXEC master..xp_cmdshell 'BCP UF.dbo.EX out D:\'+@dd+''.log -c -t , -S 127.0.0.1 -U sa -P 123'