Check your default constraints

Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.

GetDate() in blocked sessions

Trouble re-creating relationship

I'm having trouble re-establishing a relationship between two tables.  I have a foreign key table - records and a primary key table table - center.  The primary key being "clinicphone" - I'm not sure exactly what happened, but when I created the tables, and the relationship, a record in the "records" table could not be […]

RE: Does Sql Server 2000 (Standard Edition - English) not respect regional settings?

Probably the "best" answer is to use one of the two generally accepted independent formats. You can read about it, for example, here:http://www.karaszi.com/sqlserver/info_datetime.asp

RE: Dup finding question...

Hmm... I'm not sure I understood the question... are you asking how to mark all entries with duplicity, instead of leaving always one of them unmarked? If so, then try this:UPDATE e SET Dup = Yes FROM Employees e JOIN (SELECT FirstName, LastName, count(EmployeeID)  FROM Employees  GROUP BY FirstName, LastName  HAVING count(EmployeeID) > 1) as […]