Hi, any routine to create a TXT file after a Delete sentence

Question

Hi, any routine to create a TXT file after a Delete sentence in SQL Server?, i have a Stored Procedure that DELETE in several tables and i need to catch the results and show them in a TXT File. Thanks a lot.

Jefferson S. Motta · Answer

Roman: Is this? var cText = YOURDATA; var cFile=Path.GetTempPath() + Guid.NewGuid().ToString() + ".txt"; using (var tw = new StreamWriter(cFile)) tw.WriteLine(cText); Process.Start(cFile);

Ramon Quintana · Answer

declare @delete1 int declare @delete2 int declare @delete3 int declare @delete4 int declare @delete5 int declare @delete6 int delete from [XTC_INDUMOTORA].[dbo].MCM_JOB select @delete1 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'MCM_JOB' ,@delete1); delete from [XTC_INDUMOTORA].[dbo].HST_HST select @delete2 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'HST_HST' ,@delete2); delete from [XTC_INDUMOTORA].[dbo].EVT_EVENT select @delete3 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'EVT_EVENT' ,@delete3); delete from [XTC_INDUMOTORA].[dbo].VFS_AFV select @delete4 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'VFS_AFV' ,@delete4); delete from [XTC_INDUMOTORA].[dbo].VFS_FILE select @delete5 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'VFS_FILE' ,@delete5); delete from [XTC_INDUMOTORA].[dbo].VFS_INTTRES select @delete6 = @@ROWCOUNT insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados) values ( 'VFS_INTTRES' ,@delete6); This is my code, please help to the results in an .TXT file, I already save them into a Table, but i want to write them in an TXT Thanks a lot

Hi, any routine to create a TXT file after a Delete sentence

Answers (2)