Viewing 15 posts - 4,276 through 4,290 (of 6,041 total)
DonlSimpson (12/17/2014)
spaghettidba (12/16/2014)
Use NULL if the value does not exist or is undefined.
If you used 0 when NULL was more appropriate,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2014 at 9:30 am
Eirikur Eiriksson (12/16/2014)
Eric M Russell (12/16/2014)
Eirikur Eiriksson (12/16/2014)
...
There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2014 at 12:04 pm
Eirikur Eiriksson (12/16/2014)
...
There is an alternative for this case which is the sparse column, it practically does normal foreign key constraint when the value is not null, otherwise ignores it,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2014 at 8:42 am
For columns containing a foreign key enforced with a constraint, you have no choice but to not use NULL, because the primary key can't contain a NULL. Even if there...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2014 at 7:57 am
Database developers, at least in my corner of the universe, typically save our stored procedures as scripts which get checked into source control and maintained for subsequent versions. However, when...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2014 at 3:39 pm
chrisn-585491 (12/15/2014)
Maybe SSMS needs to be rebuilt to fully support source control and versioning?
We have that in Visual Studio. Most of my T-SQL code changes are done in VS/TFS.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2014 at 9:48 am
Steve Jones - SSC Editor (12/15/2014)
Eric M Russell (12/15/2014)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2014 at 8:59 am
Most backup utilities are database centric. If the server must be restored, or one wants to spin up a UAT envrironment that closely mimics production, then restoring the databases is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2014 at 8:20 am
In the past 246 days, students have made 2,261,601 apps and pictures by writing their own computer programs. Click on the pictures and screenshots to see each program in action....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 11, 2014 at 2:02 pm
gregg_dn (12/11/2014)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 11, 2014 at 7:29 am
I'm not sure that a general purpose programing tool geared toward the general public would be useful. However, the general public can extend the functionality of common applications using things...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 11, 2014 at 6:33 am
Brandie Tarvin (12/10/2014)
...Wow. I did not know the SA login could be altered. I'm going to have to try that little trick. Thanks for the code.
Yeah, it's kind of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 10, 2014 at 3:08 pm
lshanahan (11/26/2014)
Markus (11/25/2014)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 10, 2014 at 10:47 am
However, one limitation of most commercially and publicly available address databases is that they don't include exact house number, but instead a range of valid numbers, so would have to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 11:40 am
ZZartin (12/9/2014)
Eric M Russell (12/9/2014)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 11:21 am
Viewing 15 posts - 4,276 through 4,290 (of 6,041 total)