Difference between SQL triggers and SQLite triggers

 

:: -- -------- SQL trigger -------------------------------------------------
1 . Delete
Create   Trigger   [ Delete_topalexa ]   On   [ DBO ] . [ Tb_website ]  
For   Delete  
As
Begin   Transaction
Delete   From Tb_alexa Where Websiteid = ( Select Websiteid From Deleted)
Delete   From Tb_top100 Where Websiteid = ( Select Websiteid From Deleted)
If ( @ Error   <>   0 ) -- If any error occurs
Begin
Rollback   Transaction   -- Rollback
End
Commit   Transaction   -- Commit transactions
2 . Update
Create   Trigger Test_ OK
On OK
For   Update
As
If   Update (Name)
Begin
Update Sname Set Sname. s_name = OK. Name From OK, sname
Where Sname. n_id = OK. n_id
End

:: -- -------- SQLite trigger -------------------------------------------------
1 . Delete
Create Trigger Main. [ Userok_deleteok ] After Delete   On   [ Userok ]   For Each row
Begin
Delete   From Userbak Where UID = Old. uid;
End ;

2 . Update
Create Trigger Main. [ Userok_update ] After Update   On   [ Userok ]   For Each row
Begin
Update Userbak Set Username = New. Username
Where Userbak. uid = Old. uid;
End ;