Technically, the two data types have different precisions, but the same scale.

I agree with Gail.

Since the XML is stored as a single column it is treated just like any other column in the database. Therefore, you will have a row...

First off, see the following articles and read up on the XML support:

http://msdn.microsoft.com/en-us/library/ms345118(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms345115(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms345117.aspx

Per the articles referenced above, you can store the XML in any of the following data types. ...

See Hilary Cotter's articles at: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Jeff Moden (12/24/2008)

---

I'm not sure why folks try to use so many bitwise integer columns. It makes the column "multi-purpose" which is not what the definition of a column...

Thanks, Jeff for taking the time to look at the problem.

The solution implemented (pseudo-cursor) is working quite well in our application. But...

Matt Miller (12/23/2008)

---

By the way - here's an example of TYPE being used as a T-SQL keyword:

select * from MyTable

where MyID=1234

for XML path('testing'), TYPE

Not sure why that didn't make the...

Which is my earlier point. It is...

Now if Microsoft was really smart they would highlight the true SQL reserved words, as noted in http://technet.microsoft.com/en-us/library/ms189822(SQL.90).aspx for SQL Server 2005, in a totally different color. Let's say...

You stated that one shouldn't use "colid" as it is a reserved keyword. By...

J (12/23/2008)

---

Change the coloring to be all the same color.

Wut ??

Highlighting keywords is a valuable assistance provided by the system. A typo in a keyword or failing to...

Or...

1. Just ignore the coloring

2. Change the coloring to be all the same color. Under Tools /...

Exactly.

I will add that the use of SIGN needs...

That only works for the first bit. I have a similar problem where we...

Not exactly. Since when is UID a reserved word? Search for UID in BOL and see...