Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing a Column Size/Type
- Thread starter mdr2271
- Start date
Yup, with
ALTER TABLE myTable ALTER COLUMN myColumn datatype(size)...
... assuming conversion over existing column data is possible without errors.
------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]
![[banghead]](/data/assets/smilies/banghead.gif "[banghead] [banghead]")
ALTER TABLE myTable ALTER COLUMN myColumn datatype(size)...
... assuming conversion over existing column data is possible without errors.
------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]
- Status
Similar threads
