Add/Modify/Resize/Change/Delete/Drop/Rename MS SQL Server Table Column using T-SQL

As a software developer or Sql Server Administrator most often we need to change a column datatype or length or rename even delete or drop. So Add/Modify/Resize/Change/Delete/Drop/Rename operations is a very common task in our daily lives. Lets start an example: Let you start inserting data into a table but getting the ERROR: String or binary data would be truncated.The reason is you are trying