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 - 2006-07-10 : 09:10:06
|
| BUI NGOC TU writes "I have one table is employee(ns smalldatetime(4)).How to update data type string to database" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-10 : 09:16:48
|
| Your question is not clear. Can you give more details? Do you want to alter the datatype to varchar?MadhivananFailing to plan is Planning to fail |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-07-10 : 23:21:25
|
| Alter Table employee alter column ns varchar(4)-- KK |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-10 : 23:54:18
|
go to em, right click the table concerned and change the datatypeyou should be aware though that by just changing to string type with length 4, you will truncate the existing data to len 4?safe to expand the length if you're not sure  --------------------keeping it simple... |
|
|
|
|
|
|
Help me!