Viewing 15 posts - 4,111 through 4,125 (of 6,038 total)
PHYData DBA (2/25/2015)
Eric M Russell (2/25/2015)
February 25, 2015 at 9:58 am
If I offended anyone here with my analogy, of a table having no primary key, to that of a feral child having no name, then I'm sorry. I think that...
February 25, 2015 at 9:28 am
Great leaders are almost always great simplifiers, who can cut through argument, debate and doubt to offer a solution everybody can understand.
– Colin Powell
I believe this quote is particularly...
February 25, 2015 at 9:14 am
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)
In the original post, it was stated that table contains no primary key. Regardless of what the table contains (datatypes or internal value structure), all tables...
February 25, 2015 at 8:34 am
MMartin1 (2/24/2015)
February 24, 2015 at 2:56 pm
FYI:
If you're struggling with users entering "date" values into a varchar column in required format, the following check constraint enforces insertion of values as YYYYMMDD.
create table foo
(
...
February 24, 2015 at 6:16 am
It works for me when I first cast the string as date and then wrap a convert function around that.
PRINT convert(char(8),cast('Jul 11 2014' as date),112);
20140711
February 24, 2015 at 6:11 am
If no explicit constraint name is specified, then SQL Server will assign a random one at the time of object creation. It's best supply a constraint name so it's consistent...
February 23, 2015 at 3:08 pm
Kutang Pan (2/23/2015)
February 23, 2015 at 9:06 am
mw112009 (2/23/2015)
Below is a SQL statement that shows what columns belong to a certain view. My next question is how can I get a third column that...
February 23, 2015 at 8:26 am
PHYData DBA (2/23/2015)
bantrim (2/22/2015)
Eric M Russell (2/22/2015)
February 23, 2015 at 8:18 am
I don't let my young kids go off exploring entirely on their own; not the neighborhood or the internet. But I do find ways to gradually and thoughtfully introduce them...
February 23, 2015 at 8:09 am
On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table but initially empty. Also,...
February 22, 2015 at 10:03 am
GoofyGuy (2/20/2015)
Where do you think Senior DBAs end up?In the grave, as far away from deceased programmers as is possible.
So, where does an Entity Framework developer land when you...
February 20, 2015 at 10:32 am
Regardless of where the remote server is located, so long as there is a LAN connection between, then latency is not an issue when pulling across hundreds or a few...
February 20, 2015 at 8:39 am
Viewing 15 posts - 4,111 through 4,125 (of 6,038 total)