Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday, 28 October 2013

How to increase Table column length size with Table Data?

How to increase Table column length size with Table Data?


When table have a data then u cant able to modify column size's like
while you do Right click table and click modify then increase/decrease size then u can get error like see below:




But to avoid this error  u can use T-SQL code like

ALTER TABLE TABLENAME ALTER COLUMN DATATYPE()