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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-10-10 : 16:49:12
|
| Hi All,Im not a developer but i got a problem i want to change\modify one of the column in a table from smallint to int what is the best answer\query so that i can change it.Thanks in Advance |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-10-10 : 17:14:15
|
| alter table <tableName> alter column <columnName> int [null | not null]Be One with the OptimizerTG |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-10-10 : 17:27:00
|
| Thank you it worked. |
|
|
|
|
|
|
small int to int