Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GO
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER PROCEDURE [dbo].[DESCARGA] @Codigo VARCHAR(50)
- as
- SET NOCOUNT ON;
- -- No retorna el mensaje de cantidad de registros afectados
- DECLARE @IDLine VARCHAR(50);
- DECLARE @Comando VARCHAR(500);
- DECLARE @CodigoInv VARCHAR(50);
- DECLARE @UserName VARCHAR(50);
- DECLARE @PassWord VARCHAR(500);
- SELECT @CodigoInv =@Codigo;
- DECLARE @TipoDoc VARCHAR(50)
- DECLARE @Ruta2 VARCHAR(300);
- DECLARE @Ruta VARCHAR(120);
- SET @Codigo=1;
- SELECT @Codigo= Code FROM [@DESCARGAR] WHERE Code=@CodigoInv;
- declare @sql nvarchar(400)
- declare @sql2 nvarchar(400)
- declare @ServerName nvarchar(400)
- SET @ServerName = @@SERVERNAME
- SET @UserName = 'sa'
- SET @PassWord = ''
- print @Codigo;
- SET @Ruta='C:FACTEMPFAC';
- SET @Ruta2='C:FACTEMPTEMP';
- IF @Codigo=1
- BEGIN
- SET @sql='INSERT INTO [dbo].[@DESCARGAR] VALUES ('+@CodigoInv+','+@CodigoInv+',2);';
- SET @sql2= '"SELECT datos FROM [EFC].[dbo].[FACTURA] WHERE DocEntry='+@CodigoInv+'" queryout "'+@Ruta+@CodigoInv+'.csv -c -U ' + @UserName + '" -P "' + @PassWord + '" -S"' + @ServerName + '" -T''';
- SET @sql='Exec Master..xp_Cmdshell ''bcp '+@sql2 ;
- Exec(@sql );
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement