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

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);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta8y ago
Accepted 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);
0
Ramon Quintana8y ago
1. declare @delete1 int
2. declare @delete2 int
3. declare @delete3 int
4. declare @delete4 int
5. declare @delete5 int
6. declare @delete6 int
7. delete from [XTC_INDUMOTORA].[dbo].MCM_JOB
8. select @delete1 = @@ROWCOUNT
9. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
10. values ('MCM_JOB',@delete1);
11. delete from [XTC_INDUMOTORA].[dbo].HST_HST
12. select @delete2 = @@ROWCOUNT
13. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
14. values ('HST_HST',@delete2);
15. delete from [XTC_INDUMOTORA].[dbo].EVT_EVENT
16. select @delete3 = @@ROWCOUNT
17. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
18. values ('EVT_EVENT',@delete3);
19. delete from [XTC_INDUMOTORA].[dbo].VFS_AFV
20. select @delete4 = @@ROWCOUNT
21. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
22. values ('VFS_AFV',@delete4);
23. delete from [XTC_INDUMOTORA].[dbo].VFS_FILE
24. select @delete5 = @@ROWCOUNT
25. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
26. values ('VFS_FILE',@delete5);
27. delete from [XTC_INDUMOTORA].[dbo].VFS_INTTRES
28. select @delete6 = @@ROWCOUNT
29. insert into dbo.Results_Mant_Tablas (Nom_Tabla, Reg_Borrados)
30. 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
0