Wednesday, March 28, 2012

Insert/Update

Is there a way to insert / update in SQL Server 2000 with one command..
I know with Oracle there is a merge command...It's an oracle extension. But you can simulate the same behavior either by performing INSERT/UPDATE via a stored procedure, or by creating an INSTEAD OF trigger on the table that will capture the triggering statements.

No comments:

Post a Comment