Unfortunately the sample code given in that link is a truly bad...

I suggest you do not use the UPDATE join in SQL Server 2008 because it is effectively superseded by the MERGE statement. Always use MERGE instead unless you need UPDATE...

handkot (2/21/2010)

---

it's my solution

first step - we try to update record

secod step - if no record have been updated then we insert record

update Table

set field1 = @field

where field2 = @key

if...

There is nothing inherently wrong with updating a key value. Maybe it's a bug for your...

paul.davidson.uk (2/16/2010)

---

There must be an easier way for me to do this! And this, I would assume, must be a common problem with anyone who wishes to do logical deletions...

david_wendelken (2/17/2010)

---

Local user groups are composed of 1% of the IT professionals in an area, tops. Why? Because most people are too lazy to get off their butts...

In general let...

Just to set the record straight, to the best of my knowledge Chris Date never edited or had control of content at DBDEBUNK. The article and quotation posted here is...

RBarryYoung (2/16/2010)

---

I said that the rift was pointless, and it is. Either SQL and Relational Databases are different things or they are not. But 30 years of bile,...

RBarryYoung (2/16/2010)

---

There's being open-mined and there's being stupid. As a matter of fact I have read Chris Date's work. I have yet to find anything relevant, or even...

RBarryYoung (2/16/2010)

---

though SQL was based on Relational Theory, they refused to fully adopt the things that Codd wanted them too, which was the original source of the many decades old...

Then please explain why are you putting yourself through this. Why do you feel compelled to limit yourself to a fatuous design pattern you once read in a book by...

CREATE UNIQUE CLUSTERED INDEX indexname ON v1 (col1, col2, col3);

mrinal.jaiswal (2/12/2010)

---

Hi,

I want to create an Indexed view on my database. But the problem is the result set my query returns does not have any unique key, means the result...

Not if you use a compound foreign key...