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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 What is the safest way?

Author  Topic 

skiabox
Posting Yak Master

169 Posts

Posted - 2008-12-23 : 09:35:30
What is the safest way to change an already existed column of int type (that contains one digit from 1 to 9) to nchar(1) type?
This field is part of the primary key of three different tables!

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-12-23 : 10:30:57
why would you want to do that?
Go to Top of Page

skiabox
Posting Yak Master

169 Posts

Posted - 2008-12-23 : 16:06:05
Never mind.I'll drop the three tables from the out to the inside and I'll recreate them afterwards.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-23 : 16:07:58
Why don't you just use tinyint?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -