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 |
ssabbani
Starting Member
3 Posts |
Posted - 2008-08-11 : 10:10:06
|
Hi AllI've a table with column XXX having Datatype Varchar2.This table contains data.I have changed the column XXX to Datatype 'Date'.i commited the same.But problem when i look in to the table data i lost entire data of that column and was replaced with null values. How to restore the previous data as I didn't take the backup.Please provide the solution ASAP. |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-11 : 10:11:05
|
Microsoft SQL Server doesn't have datatype VARCHAR2. Oracle has.Microsoft SQL Server has NVARCHAR. E 12°55'05.25"N 56°04'39.16" |
|
|
ssabbani
Starting Member
3 Posts |
Posted - 2008-08-11 : 10:40:34
|
Yes You are right. Spellng mistake |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-11 : 10:43:21
|
Are you sure this is related to SQL Server? I guess SQL 2008 has date datatype. If you don't have backup at all, You need to get third party tools for it. |
|
|
ssabbani
Starting Member
3 Posts |
Posted - 2008-08-11 : 10:49:52
|
This is for my sql. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-11 : 10:55:56
|
www.dbforums.comGood luck! E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|