Then the MERGE as the fine example already posted is exactly what you want. Here is the link to the BOL article about MERGE.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

Miles Neale (9/19/2012)

---

I would say also that it was dishonest, or at a minimum deceptive. In any case it shows that you can not always trust certain functions of...

Brandie Tarvin (9/19/2012)

---

Yep.

My current drama is...

rhythmk (9/18/2012)

---

Kingston Dhasian (9/18/2012)

---

1.How many columns a SQL table can hold.

2.How many string functions are there in SQL.

3.How many non-clustered indexes a SQL table can have.

4.What is the port to...

My answers would have been similar to this.

I don't know the exact number but it is far more than I have ever needed...

Paul White has great 2 article series about Apply.

Understanding and Using APPLY (Part 1)[/url]

Understanding and Using APPLY (Part 2)[/url]

--posted to wrong post, sorry.

No offense but you seem to keep posting this same link to your blog over and over. Sadly,...

Hi and welcome to SSC!!! It is somewhat unclear exactly what you are trying to do but in your trigger you are not referencing the insert virtual table. http://msdn.microsoft.com/en-us/library/ms191300.aspx

If you...

sknox (9/19/2012)

---

Another QotD which does not test what it purports to test.

Even if you know TABLESAMPLE inside and out, you cannot expect to get this question correct without knowing...

Ahh...

--McCrackis Philled

Hugo Kornelis (9/19/2012)

---

IgorMi (9/19/2012)

---

Hugo Kornelis (9/19/2012)

---

Nice question. I almost got it wrong, because I had first overlooked the TOP clause.

However, the official correct answer is still a bit questionable. The...

ChrisM@Work (9/19/2012)

---

Sean Lange (9/7/2012)

---

ChrisM@Work (9/7/2012)

---

Have a look in BOL under...

vahid.arr (9/19/2012)

---

Well Thanks to all this are the things that i have doubt about it.specialy number 4:

1- i have table with 40 fields that it have 10 image Type field...

crux1187 (9/18/2012)

---

Okey before I try it out I have a question regarding your answer. When you set the Delete Rule constraint to Set Default, the default value in the column...