It requires bit comparison. If OP is comfortable with it, GO Ahead. I usually avoid it (my discomfort).

MarkusB (12/5/2011)

---

Since there is no table "updated" I assume you meant to use the following:

AND INSERTED.costprice != deleted.costprice

But a much...

Most Welcome! 🙂

in your update query...

Please add following...

AND INSERTED.costprice != DELETED.costprice

LutzM (12/4/2011)

---

What do you consider as "limitations"?

Would the fact count, that a query with a WHERE clause that covers more than one partition might run significantly slower than against a...

Soldier, Marshall, Commander etc. are roles (designations). They are not entities.

I would recommend you to read your Design Notes (assuming it’s a homework question ;-)) before jumping on ERD.

How to: Enable FILESTREAM

http://msdn.microsoft.com/en-us/library/cc645923(v=SQL.100).aspx

I have one question here. If you...

@Nico: Nobody is challenging you here (however many SSC guys here possess the knowledge / skills to do so). What my friends were attempting here you to know that you...

Viewing Information About Backups

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

If you don't want the client to know about the tables & schemas names even, then possibly you can change the tables name to something generic like "TableX", "TableXX", "TableXXX"...

Revenant (12/3/2011)

---

Dev (12/3/2011)

---

Kit G (12/3/2011)

---

Thanks for all the congratulations on our anniversary. 🙂 Had a really nice day and am looking forward to the vacation with...

Jeff Moden (12/3/2011)

---

Dev (12/3/2011)

---

Kit G (12/3/2011)

---

Thanks for all the congratulations on our anniversary. 🙂 Had a really nice day and am looking forward to the vacation...

How To...