Select EmployeeId, LastName, FirstName, JobTitle, SalaryWage Into pp_SalaryEmployee from Employee where SalaryWage>70;
Select EmployeeId, LastName, FirstName, JobTitle, SalaryWage Into Pp_HourlyEmoloyee from Employee where SalaryWage<71;
Select * from pp_HourlyEmployee
Select * from pp_SalaryEmployee
Update pp_SalaryEmployee SET SalaryWage=SalaryWage*0.04;
Update Pp_HourlyEmoloyee Set SalaryWage=55+SalaryWage;
Insert into pp_SalaryEmployee values ('181','V','Priya','Teamlead',50000)
Insert into pp_SalaryEmployee Select * from Pp_HourlyEmoloyee ;
Update pp_SalaryEmployee set SalaryWage=SalaryWage*40*52
Select * from Pp_HourlyEmoloyee
Delete from Pp_HourlyEmoloyee
Drop table Pp_HourlyEmoloyee
Drop table Pp_SalaryEmployee
Explanation:
SSMS is abbreviated as SQL Server Management Studio, it is a software application and it is launched with Microsoft SQL Server that is used for managing, configuring, and administering all components within Microsoft SQL Server.
A main feature of ‘SQL Server Management Studio’ is the Object Explorer, it allows the user to select, browse, and act upon any of the objects within the server.
These servers are major successor to the ‘Enterprise Manager’ in SQL. The tool includes both graphical tools and script editors which work with components and features of the server.
It is used to separate ‘Express edition’ that could be freely downloaded, however recent versions of SQL Server Management Studio are fully capable of connecting to ‘SQL Server Express instance’.
