Taj Mahal : One of the seven wornders of the world.Amits

Standing majestically on the banks of River Yamuna, the Taj Mahal is synonymous to love and romance. The name "Taj Mahal" was derived from the name of Shah Jahan's wife, Mumtaz Mahal, and means "Crown Palace". The purity of the white marble, the exquisite ornamentation, precious gemstones used and its picturesque location, all make a visit to the Taj Mahal gain a place amongst the most sought-after tours in the world. However, until you know the love story behind the construction of the Taj Mahal, the beauty of the same would not enliven in your heart and mind and instead would come up as just another beautiful building/monument. It is the love behind this outstanding monument that has given a life to this monument. Come and explore the visceral charisma that it emanates

Standing majestically on the banks of River Yamuna, the Taj Mahal is synonymous to love and romance. The name "Taj Mahal" was derived from the name of Shah Jahan's wife, Mumtaz Mahal, and means "Crown Palace". The purity of the white marble, the exquisite ornamentation, precious gemstones used and its picturesque location, all make a visit to the Taj Mahal gain a place amongst the most sought-after tours in the world. However, until you know the love story behind the construction of the Taj Mahal, the beauty of the same would not enliven in your heart and mind and instead would come up as just another beautiful building/monument. It is the love behind this outstanding monument that has given a life to this monument. Come and explore the visceral charisma that it emanates

MS SQL Server Multiple Trigger on One Table

Suppose you have one table and you want to put two triggers to be fired on this table.
This trigger we can implement for DDL (CREATE) AND DML(Insert , Update and Delete)

CREATE TABLE DBO.MYTABLE
(MYNAME VARCHAR(10))
Now creating trigger


Create Trigger TrMyTable1 on MyTable
for insert
As
Set Nocount On
Begin
Print 'I am in TrMyTable1'
End


Create Trigger TrMyTable2 on MyTable
for insert
As
Set Nocount On
Begin
Print 'I am in TrMyTable2'
End

Now we suppose we want second trigger (TrMyTable2) to fire first then we need to set order



 Exec sp_settriggerorder @triggername = 'TrMyTable2',
@order = 'first',
@stmttype = 'insert',
@namespace = null
GO
Exec sp_settriggerorder @triggername = 'TrMyTable1',
@order = 'last',
@stmttype = 'update',
@namespace = null
GO