Using Downloaded Dbms Ms Sql Server Create Sql Queries Inserts Least Three Rows Table Crea Q37097246

1. Using your downloaded DBMS (MS SQL Server), create SQL queriesthat inserts at least three rows in each table.
2. Create SQL queries that update one row in each table.
3. Create SQL queries that retrieve an entire table (any tablethat you choose).

Just need an example query for any database so I am able toapply the queries to my own database. I am using Microsoft SQLServer Management Studio 17. Thanks

Solution

//Creating Table for Employee and DepartmentCREATE TABLE Employee(employeeno INT PRIMARY KEY,employeename VARCHAR(10),employeejob VARCHAR(9),employeemgr INT NULL,hiredate DATETIME,employeesal NUMERIC(7,2),employeecomm NUMERIC(7,2) NULL,deptartment INT)begin//Entering values into newly created table.insert into Employee values (1,’ABCD’,’admin’,7,’04-19-2019′,28000,NULL,3)insert into Employee

OR

 

OR