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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-22 : 08:16:38
|
| shaik writes "Dear Sir,If i want to change varchar to datetime in sql server 2000, my recoreds remains there or will be deleted?Thanks,Hakeem." |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-12-22 : 09:14:29
|
| Not sure what you mean by your record being deleted, but anyway, if you perform an update on your table then yes, the previous format will be lost, however, if you're cobverting the data type in your select statment then only the result is affected and the column's original data type is retained.________________Make love not war! |
 |
|
|
|
|
|
changing data type..