Sanity Check

[Moebius01]

Ok, given the long day, I may be missing something obvious here, but a co-worker just showed me a table where a column, defined as smallint had a row with a value that was text, specifically a sentence.

Is there any way whatsoever this would be possible? I thought that even if the field was changed to varchar, that when being changed back to int, it would error out converting the text.

Or is it just really time to go home today?

 

[ptheriault]

>>Is there any way whatsoever this would be possible?

I don't see how that could be possible! What happens when you try to select the record?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Unless the data within the table has become corrupt this shouldn't be possible.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLSister]

I'd consider running DBCC CHECKTABLE on that table.

Questions about posting. See faq183-874