Viewing 15 posts - 10,216 through 10,230 (of 26,489 total)
I know you did a lot of the work, but I have to ask you a question.
Do you feel comfortable enough with the code you have to describe what it...
August 8, 2012 at 3:26 pm
Sean Lange (8/8/2012)
morepainot (8/8/2012)
August 8, 2012 at 3:03 pm
I haven't fully checked your web site, but one of the things I really liked about the company I now work for is that I was able to learn a...
August 8, 2012 at 2:56 pm
joshphillips7145 (8/8/2012)
The event that should cause it to rollback would be finding a duplicate entry right?
Yes, but how do you know you have a duplicate value in an insert ot...
August 8, 2012 at 2:32 pm
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
August 8, 2012 at 2:24 pm
I have figured out what the problem is, have you?
Question, what event should cause the trigger to rollback the insert or update.
Use a temp table and simulate what should happen...
August 8, 2012 at 2:20 pm
I realize that the idea is to write a trigger to accomplish allowing multiple nulls but a single unique non null value, however, this is SQL Server 2008 so why...
August 8, 2012 at 1:33 pm
Steve Jones - SSC Editor (8/8/2012)
SQLRNNR (8/7/2012)
Editor: Image removed.Link to image
http://4.bp.blogspot.com/_o5swS_a08j4/Sv0XX5UFrSI/AAAAAAAAEQc/NKWVzCsO0MY/s400/obama+short+bus.jpg
Links are OK here.
Just an FYI, I had someone complain about the humor/political nature of the image. I don't think...
August 8, 2012 at 11:54 am
There are several other products out there some use instead of SSMS. TOAD for SQL Server is one, and I know there are a few others even if I...
August 8, 2012 at 11:35 am
SQLRNNR (8/8/2012)
Jan Van der Eecken (8/8/2012)
Jan Van der Eecken (8/8/2012)
SQLRNNR (8/8/2012)
Lynn Pettis (8/8/2012)
SQLRNNR (8/8/2012)
D.Oc (8/8/2012)
SQLRNNR (8/7/2012)
Editor: Image removed.
LOL, made me laugh 🙂 Although it is not appropriate for this...
August 8, 2012 at 11:01 am
SQLRNNR (8/8/2012)
D.Oc (8/8/2012)
SQLRNNR (8/7/2012)
Editor: Image removed.LOL, made me laugh 🙂 Although it is not appropriate for this kind of forum
Fox News neo-nazi propaganda, you gotta love it.
HAHAHA
Which do you...
August 8, 2012 at 9:41 am
Glad to see you got it working.
August 8, 2012 at 9:27 am
Perry Whittle (8/7/2012)
Perry Whittle (8/7/2012)
Once the db is online remove the old...
August 8, 2012 at 9:24 am
SQLKnowItAll (8/8/2012)
Lynn Pettis (8/8/2012)
August 8, 2012 at 9:20 am
First, thank you for the setup, it will help a lot. Just one thing missing that would help more, expected results. What should the query return based on...
August 8, 2012 at 8:49 am
Viewing 15 posts - 10,216 through 10,230 (of 26,489 total)