Instead Of would certainly be cleaner, since it would *prevent* or cancel a transaction before...

Considering...

It's not much of a bookmark, but there always it the "recent files" list....

I know I know...just don't throw anything heavy:)

sotn (6/4/2008)

---

I am still confused as to how can a 32-bit application reference above 2GB without AWE 32 as the /3GB switch just tells the O/S not to use it...

okkko (6/4/2008)

---

Hello. (Pretty much noob here.)

Is there a way to log (or maybe there's some "hidden" table) changes or executions of stored procedures? Preferably also who performed a change and...

Jeff Moden (5/19/2008)

---

In this case, since the same amount of data is being transmitted either way, it would probably be best to tax the client for the final format instead...

Hmm - might be one of those times to dust off the new EXCEPT clause.

Select col1, col2, col3, col4

from TableA

EXCEPT

Select col1, col2, col3, col4

from TableB

would return rows from table A...

I get to experience that...

At least you got your answer. Just sorry we were slow on the uptake.

Thanks for updating the status!

Jeff Moden (6/4/2008)

---

Jack,

Could you post some data in the form identified in the article in the URL listed in my signature, please? It'll help us give you a correct...

Lose a few million customers' bank account info (not just the account...

mhaskins (6/4/2008)

---

Yeah - I think that this comparison is a little over the top....

You essentially want to write those as two separate IF statements. Depending on whether you want someone to get just one e-mail, or possibly several if the row had...

mailsar (6/3/2008)

---

I am in the process of creating few tables. I have internal keys say CustomerID which is an integer. Is it a good idea to make that field an...

Device CAL's and User CAL's are different, so you may need to figure out which one makes most sense for you. Keep in mind that there is no concurrent...