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 |
|
potchakri
Starting Member
10 Posts |
 Posted - 2007-08-23 : 10:23:51
|
| 1) We have an excel sheet that has column names and corresponding datatypes.2) We want to update the columns with these datatypes, please let us know if there is an automated procedure for this..3) We can import data from excel into a DB table and use the procedure to update the column datatypes..Thanks in Advance |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-23 : 10:31:17
|
INFORMATION_SCHEMA.COLUMNS will give you all the information that you need
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Updating datadictionary with datatypes for columns