“Dotnet tips, SQL Server tips, Silverlight tips, AJAX tips...”
Read Experts reviews and compare prices to find the right desktop or laptop for you from the huge collection.
This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to be updated if it already exists and inserted if it does not.
Exists and Insert or Update does not perform well, this entry has a very simple tip that implements this scenario in a simple, elegant and efficient way (try an update if rowcount is zero then go for insert, cool ! :-))