mssql_table_queries

mssql_table_queries

/* CREATE a table */
  CREATE TABLE [WebsiteDB].[dbo].[empSalary] (
    empId int,
    empSalaryBand char,
    empSalaryValue int,
	empCurrency varchar(8)
);

/* ALTER a table */
ALTER TABLE [empSalary] ALTER COLUMN empSalaryBand varchar(8);

/* INSERT into a table */
INSERT INTO empSalary values (1001,'C',42000,'GBP');
INSERT INTO empSalary values (1002,'D',32000,'GBP');
INSERT INTO empSalary values (1003,'A',155000,'GBP');

/* CREATE a table */

  CREATE TABLE [WebsiteDB].[dbo].[empTable] (
    empId int,
    empName varchar(255),
    empManager varchar(255),
	empJoinDate datetime
);

/* INSERT into a table */
INSERT INTO empTable values (1001,'emp1','manager1','2018-06-12 00:00:00.000');
INSERT INTO empTable values (1002,'emp2','manager1','2018-06-11 00:00:00.000');

/* SELECT JOIN table */
SELECT [empTable].[empId],[empSalary].[empSalaryBand], empSalary.empSalaryValue,[empTable].[empManager]
FROM [empSalary]
LEFT JOIN [empTable] ON [empSalary].[empId] = [empTable].[empId];

/* RENAME a column of table using stored procedure */

sp_rename '[empSalary].empSalary', 'empSalaryValue', 'COLUMN';