Hey there....

Love the kitty door... so how do I get a hold of your uncle to get one for my cat?!??!

I like gadets, but there is point where you need...

Personally, I don't have a "favorite" car, aside from the one that I drive daily (Toyota Camry), but my partner's uncle restores cars and I think he has a 67...

Dan,

First of all...Thanks for actually replying to my question (instead of pointing out errors, duplication, etc in my posts/comments) like Remi did   Your...

Right... I think the article title mis-lead me (along with a couple of the posts)...

Title should be ISNULL () then!

Hey there...

So you are saying that if I have the following “validation” code at the beginning of my SP (after variable declaration and before INSERT)_, that I should be using...

Noel,

You lost me here... Are you responding to something in my post.. or to the code in Mike's post (that I was responding to)???

Thanks.

Michelle/Dolphin

Jacob,

Great articles, I have them book-marked now, as this question comes up everywhere and about every couple months!  I was just about to post some code for you as well,...

Mike,

Thanks for your response!

I thought I had mentioned why I am using 3 SPs (actually 4 if you include the wrapper SP) in an earlier post, or even in the original...

Mike,

Great "gem" from the BOL... sometimes there are things in BOLin clear language!!!  That's what I like about the newer .NET docs.. they actually created help that helps.. hopefully they will do...

Noel,

Thanks for your response.  I've been in meetings so haven't looked at the other post yet, but I will.

I am aware of how transactions and the variable @@trancount work, I am...

Noel,

Thanks... but I've had this article recommended more times than I can count, and I've read it at least that many times as well, if not more

Hey  there,

Just following up on my post from last Friday afternoon... no one has responded as it likely dropped off the board before anyone saw it.

I could really use some...

Lowell,

Thanks for your responses...

I should have mentioned that the problem with my situation (well one of the problems) is that the business logic is...

Mike,

Well.. I developed the "talent of WHY" at a very young age... actually got "asked to leave" Sunday school when I was ~ 5 yrs old b/c I asked why...

Hi there,

The IF EXISTS has value IF he is trying to validate that the user being updated (based on the parameter @user-id supplied) is in the database.  Which...