Add a new column in MSSQL
alter table <<table_name>>
add <<columnname>> <<data type>>
Example :-
alter table employee
add first_name varchar(25)
Advertisements
Add a new column in MSSQL
alter table <<table_name>>
add <<columnname>> <<data type>>
Example :-
alter table employee
add first_name varchar(25)
How to get MSSQL Server name in MSSQL ?
select @@servername
How to get user name in MSSQL ?
SELECT SUSER_NAME() LoggedInUser