SQL - Common SQL Server Commands

Friday, October 15th, 2021 | Coding
Last Modified: 2024-11-08



ALTER TABLE dbo.Employees 
ADD company VARCHAR (255) NULL;

####

Alter existing column:

ALTER TABLE Orders ALTER COLUMN shipToAddress1 VARCHAR (80);

ALTER TABLE Employees ALTER COLUMN address1 VARCHAR (80);

https://javarevisited.blogspot.com/2016/03/how-to-increase-length-of-existing-VARCHAR-column-in-SQL-Server.html#axzz7Lf1U1L2D




Input Action Output
A collection of snippets and links that have proven useful for development and programming in ColdFusion, JavaScript, jQuery, PHP, Python, Dell, Minecraft, Apple, Mac, Windows, LINUX, Raspberry Pi, Adobe, CSS, and HTML.

©2024 Input Action Output