SQL can do select statements for either of the insert, update or deletes =
ie for deletes
delete from tbl where ID > (Select Min(ID) from tbl m where m.Name =3D =
the above query is useful for deleting duplicate records.
update tbl set field1 =3D m.field1
from tbl inner join tbl2 m on m.ID =3D tbl.ID
updates table based on another table with the same keys.
inserts are just has someone else asked.=20
I have not seen any triggers in any of the tables as of yet. So I will =
not go into them just yet.=20
I am a great person to ask SQL questions to I can solve most of them.=20
Get latest updates about Open Source Projects, Conferences and News.