DECLARE @var nvarchar(MAX) DECLARE curRunning CURSOR LOCAL FAST_FORWARD FOR select name from sysobjects where type = 'U' Open curRunning Fetch NEXT From curRunning into @var WHILE @@FETCH_STATUS = 0 BEGIN --select 'exec master.dbo.xp_cmdshell ''bcp databaseName.dbo.' + @var + ' out C:\' + @var + '.csv -c -T -t ,''' DECLARE @Exec nvarchar(MAX) set @Exec = 'exec master.dbo.xp_cmdshell ''bcp consignation.dbo.' + @var + ' out d:\' + @var + '.csv -c -T -t ,''' execute sp_executesql @Exec
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question