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 2000 Forums
 SQL Server Development (2000)
 How to restore table data

Author  Topic 

ssabbani
Starting Member

3 Posts

Posted - 2008-08-11 : 10:10:06
Hi All

I'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"
Go to Top of Page

ssabbani
Starting Member

3 Posts

Posted - 2008-08-11 : 10:40:34
Yes You are right. Spellng mistake
Go to Top of Page

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.
Go to Top of Page

ssabbani
Starting Member

3 Posts

Posted - 2008-08-11 : 10:49:52
This is for my sql.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-11 : 10:55:56
www.dbforums.com
Good luck!



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -