I would consider SSEE for a 10 user line of business application that doesn't require GB of reference data or ad-hoc queries. However, it would have to be a business...

Of course containing "date" values in VarChar columns is a bad idea from the start, and once it's done, it's no small change to undo, because there are applications and...

sstanek 27058 (2/26/2015)

---

I like the idea of the wall of shame rather than the kill list. You may want to make it a little closer to home though and have...

PHYData DBA (2/25/2015)

---

Eric M Russell (2/25/2015)

---

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...

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...

I believe this quote is particularly...

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...

MMartin1 (2/24/2015)

---

I for one like the yyyy-mm-dd notation. In other countries a '20140711' could be interpreted as Nov 07, 2014. If you changed the default language setting on your machine...

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

(

...

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

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...

Kutang Pan (2/23/2015)

---

I'm going to get my 7 and 5 y/o their own first PC, nothing powerfull, just something to be able to watch movies and stuff on internet. Maybe...

mw112009 (2/23/2015)

---

Hello and Good Day.

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...

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...

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...