Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael71
Posting Yak Master
126 Posts |
 Posted - 2006-12-27 : 15:20:25
|
| How do I go from a text data type to a numeric data type without having to delete the column and put it back out there. I tried to changed the data type but it gave me a error saying that I couldn't go from text to int data type. Help. |
|
|
DustinMichaels
Constraint Violating Yak Guru
464 Posts |
Posted - 2006-12-27 : 16:21:13
|
| You might want to check to see if there is a text value for the column that isn't actually an integer. You might have to scrub your data before you can do the data type conversion. |
 |
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-12-27 : 16:30:01
|
| i IMPORTED IT IN...and it is too large to type again. |
|
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-12-27 : 16:34:23
|
| What data Types can be a Pimary key? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-27 : 17:07:16
|
| Pretty much anything that can have a unique index created on it can be a primary key, so not text, ntext, image or varbinary. |
|
|
|
|
|
|
Changing data types----Help!