Tag Archives: insert

Insert or Update Record in SQL Server Depending on Whether it Already Exists.

This is a simple example on how you can use T-SQL to Update a record if it already exists, or add a new record if it doesn’t. This example uses a table STOCK_ITEMS, with two fields ITEM_ID and ITEM_VALUE. If … Continue reading

Posted in Programming | Tagged , , , , | Leave a comment