Wednesday, 19 November 2014

Can not alter table tsql




If you find the following does not work

Alter table Table_name modify COLUMN  column_name  varchar(101);

Then try

Alter table Table_name Alter COLUMN  column_name  varchar(101);

This works on sql server 2005


Related
 
Cannot Alter Table Being Used For Replication


-
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Chrome 138 the last supported

Chrome 138 the last supported  Hey Everyone, Chrome 138 is the last version of Chrome that will support Android 8.0 (Oreo) and Android 9.0 (...

  • Datepart in Crystal Reports
    Crystal Reports datepart is slightly different than  SQL and VB Interval type            Description yyyy                          Extr...
  • DCOB Fault
    If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
  • USB safe charging
      Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...