Sunday, 15 January 2012

Create two or more triggers in a row by executing a query with SQL Server -


Which command runs two or more in a row while executing a query with SQL Server the correct syntax

after I try:

  update as dbo.MyTable create updated on GO TRIGGER TRG_MyTable_UpdatedAt dbo.MyTable set UpdatedAt = after GETDATE () where different ID ID included in the (selection) end GO insert included in updated dbo.MyTable set CreatedAt = GETDATE () where (selection ID Feel ID) end  Create dbo.MyTable on TRIGGER TRG_MyTable_CreatedAt after 

But it gives an error :. have the wrong syntax 'end'

  Trogr create TRG_MyTable_UpdatedAdbo updated as updates on dbo.MyTable on dbo.MyTable SET UpdateAt = GETDATE () select select (entry ID where ID) beginning as INS ERT on dbo.MyTable on END go Trjir TRG_MyTable_CreatedAt update dbo.MyTable set CreatedAt = GETDATE () WHERE id (select insert different ID) end GO  

No comments:

Post a Comment