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 |
|
sheetal.ostwal
Starting Member
2 Posts |
 Posted - 2008-03-27 : 17:19:40
|
| I have 'Text' type data field in my Table, where as I want to convert this field and so as the data too to 'Image' data type, obviously without loss of data.How I can do this accomplish this.Is it possible directly or some indirect ways are there! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-27 : 20:28:38
|
| Post in right place if you need expert developers help |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 22:55:11
|
| Try alter column data type in testing db. |
|
|
|
craig79
Starting Member
33 Posts |
Posted - 2008-03-28 : 01:10:15
|
| Please take a backup of table to avoid data loss.select * into dbo.tablenamebkp from dbo.TableName goALTER TABLE TableName ALTER COLUMN ColumnName Imagego |
|
|
|
|
|
|
Conversion Problem