26 Kicks

SQL Server: Best way to Update row if exists, Insert if not (weblogs.sqlteam.com)

submitted by spirit1spirit1(3160) 4 years, 9 months ago

This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard the term yet) is locking.

add a comment |category: |Views: 119

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
alexandrul.ctalexandrul.ct(475) - rg443rg443(5) - ashithmrashithmr(90) - LoonquawlLoonquawl(0)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?