August 29, 2008 02:45pm pdt

1. chapmandew 1,914,331
2. angelIII 1,539,717
3. aneeshatti... 555,115
4. mark_wills 551,831
5. ScottPletc... 386,761
6. ee_rlee 349,324
7. acperkins 283,802
8. dtodd 278,051
9. EugeneZ 267,414
10. BrandonG... 170,092
11. Thomasian 153,038
12. cs97jjm3 150,650
13. appari 140,448
14. matthews... 138,203
15. momi_sa... 134,935
16. dbaSQL 126,394
17. brejk 122,990
18. rickchild 121,425
19. ptjcb 119,637
20. dqmq 113,074
21. dportas 112,530
22. bhess1 112,305
23. nmcdermaid 107,818
24. MohammedU 106,975
25. asvforce 103,642

1. angelIII 10,496,130
2. aneeshatti... 4,612,994
3. acperkins 4,272,262
4. ScottPletc... 4,200,813
5. arbert 2,245,195
6. Lowfatsp... 2,165,176
7. chapmandew 1,914,331
8. EugeneZ 1,543,576
9. rafrancisco 1,460,132
10. imran_fast 1,458,963
11. Hilaire 1,221,775
12. Nightman 1,143,404
13. nmcdermaid 1,092,402
14. Mr_Peer... 1,087,815
15. ptjcb 1,053,496
16. bhess1 1,049,297
17. dtodd 864,394
18. Sirees 774,152
19. adathelad 766,312
20. appari 727,685
21. BriCrowe 722,959
22. amit_g 683,229
23. matthews... 660,535
24. ShogunW... 619,598
25. Kevin3NF 590,766

06.18.2008 at 11:50AM PDT, ID: 23496399

	[x] Attachment Details

Insert Query And Transaction

Asked by matrix_aash in MS SQL Server

Hi All,

I have an lots of insert statement running and inserting data into different table picking up data from different server which are linked to my server on which inserts run(I have all this in a stored procedure which I have inherited from previous programmer). First of all the the stored procedure empty's all the tables in which inserts is going to take place and then it starts insert statements as I explained above.

You can see a sample code in the snippet

I want to write a transaction so that if any of the inserts or deletes fail for any reason(say source missing or anything)

It rolls back and the data which is deleted intially in the delete statement is rollback.

Hope this makes sense.

Thanks in advance.

Cheers,

Aash.
Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

           
           
             exec sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
 
    DELETE  FROM [dbo].[table1]
    DELETE  FROM [dbo].[table2]
 
 exec sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
 
-- data import script 
-- lookups 
 
    insert  into table1            (
              column1,
              column2
            )
            select  column1,
                    column2
            from    sqlservername.databasename.dbo.table_name1
 
    insert  into table2            (
              table2_column1,
              table2_column2
            )
            select  column1,
                    column2
            from    sqlservername.databasename.dbo.table_name2

           
         

Keywords: Insert Query And Transaction

	Title
1	Rollback
2	Transaction and ODBC
3	Kill Rollback?
4	Can you stop a Rollback?
5	adodb transactions with php. 500 …
6	Transactions

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_EXPERT_20070906

Insert Query And Transaction

Asked by matrix_aash in MS SQL Server

About this solution