Yes, the TEXT Data Type is on the Deprecation list.

http://technet.microsoft.com/en-us/library/ms143729.aspx

Depending on the kind of queries you'd be running on the column, I wonder if a Full Text Index might be...

$t@r (12/3/2013)

---

Hi

I have been working as jr.DBA in cmm level 3 company in india .But I am much more into development and having basic knowlege on Aministration .As...

Sy-1148362 (11/30/2013)

---

Hi There!

I have an Employee table with Columns:

EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip

Requirement: I have to identify the...

I think you'll find that the tsql solution for resolving your issue is pretty much along the lines you have been shown. If you'd like alternatives, maybe the popular...

I'll throw another resource in here.

The product documentation for SQL Server, generally known as Books Online.

It has a number of links to basic tutorials and how-to's.

This one is also a good read.

http://www.karaszi.com/sqlserver/info_datetime.asp

I don't believe you have to. Just telling us it's solved is "closed" enough 🙂

I would think it unlikely that would be losing rows in this way.

You might try posting the Sql Statement that pulls the rows... maybe someone might spot something.

Is there a...