1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
SSSSS [86.1K]
3 years ago
9

Use the SQL Server Management Studio to complete the following.

Computers and Technology
1 answer:
scZoUnD [109]3 years ago
6 0
<h3><u>The SQL Server Management Studio program for the given statement: </u></h3>

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

<u>Explanation: </u>

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’.

You might be interested in
If any one has mincraft on ps4 bedrock we can finish building a BIG city world all we need to put is a shop and money dispensers
sasho [114]

Answer:

Cool

Explanation:

7 0
3 years ago
Read 2 more answers
Is a component that provides a button control in a gui application or applet?
harina [27]
<span>GUI is a graphical user interface. It is a graphical window that provides interaction with the user. 
</span>The button is a pushbutton, which can be pressed to trigger an action.<span>
A graphic control component or a control element is a component that provides a button control in a GUI application. It is also called a control element because it </span><span>is an element of interaction between the user controlling the application.</span>
7 0
3 years ago
Administrative activities, such as archiving project files, closing out contracts, documenting lessons learned, and receiving fo
asambeis [7]

Answer:

closing

Explanation:

6 0
3 years ago
How to convert a .enw file into a .pdf without downloading any applications? (If I have to, then I will. Just please tell me.)
kolezko [41]

Answer: use this link :- https://www.file-extension.info/conversion/enw-to-pdf

Explanation:

7 0
3 years ago
Read 2 more answers
show how one version of the technology is an improvement over a previous iteration of that same technology
Romashka-Z-Leto [24]
This question has a ton of answers to it but, here are some basic ideas to help you out
- Cars 1900's vs today
- Computers 1980's vs today
- Guns 1800's vs today
- Televisions 1900's vs today
- Telescopes/Microscopes
7 0
3 years ago
Other questions:
  • What can help you best learn about appearance, habitats and behaviors of birds in your area
    9·1 answer
  • Documents on the web stored on web servers are known as web _____.
    6·1 answer
  • What is the internet?
    5·2 answers
  • It is important to name your files in a variety of formats. true or false
    15·2 answers
  • Explain what is meant by information technology (IT). Explain what is meant by information systems (IS). Why is it important to
    7·1 answer
  • A vacuum tube that contains a grid can be classified as a A. rectifier B. triode C. pentode D. diode
    12·1 answer
  • Which are aspects of the post-production stage?
    9·1 answer
  • Based on the following quote from Leonardo Da Vinci, what would be his definition of a fine artist? “Principles for the Developm
    11·2 answers
  • Describe a new career in computer science that may be created in the future
    11·1 answer
  • Why is a salt added to a password that is being stored in a database?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!