Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the Insert, Update , Delete and Merge statement. It is more useful than @@scope_Identity and @@Identity column since these global variables gives us the information about the last inserted identity column value, but the Output clause gives us the last affected identity in case of Inserted, deleted, updated and merge statement. Output clause has the access to the Magic tables (Inserted and deleted) and we can capture the records of affected rows into the temporary tables too for latter use.
Create table Tbl_output (id int identity(1,1), fname nvarchar(100), lname nvarchar(100))
Example of Output clause in case of Insert command
Declare @outputtemp Table (id int , fname nvarchar(100), lname nvarchar(100))
Insert into tbl_output(fname,lname)
Output inserted.id, inserted.fname, inserted.lname into @outputtemp
values(‘Vivek’, ‘Johari’)
Select * from @outputtemp
Example of Output clause in case of Update command
Update tbl_output set fname=’Vibodh’
Output inserted. fname , deleted.fname
where id=1
Example of Output clause in case of Delete command
Delete from tbl_output
Output deleted.*
where id=1
Pingback: TanaMuzicka - KENCHELLO BOBO
Pingback: สอนเทรด Forex
Pingback: Indian Catering Canton MI
Pingback: chanson française
Pingback: Your Dream Home Improvements
Pingback: Best Tallahassee real estate agent
Pingback: Car Makeover TV Show
Pingback: Mitch Brownlie Queensland
Pingback: 바카라119
Pingback: Human Hair Wigs
Pingback: promotion code
Pingback: Online Casino
Pingback: taipan qq
Pingback: Bhojpuri film Watch Bhojpuri film
Pingback: LigaZ
Pingback: Small business website designs and marketing
Pingback: What Is Paddle Boarding?
Pingback: ทิงเจอร์ขาว
Pingback: sexy baccarat
Pingback: prediksi togel hk
Pingback: poker99
Pingback: Bassett Caterers
Pingback: con heo dat remix
Pingback: link bong88
Pingback: Solesociety gift card
Pingback: AL
Pingback: ทางเข้าlive22
Pingback: cbd