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
When Clara accesses the programs and documents on her computer by way of icons, she is said to be employing
xxMikexx [17]
<span>D - graphical user interface</span>
5 0
3 years ago
How does light move? Shift? Bounce between different objects?
ZanzabumX [31]

Answer:

Bounce between different objects

Explanation:

Light probably will bounce off of objects or it might go through, i think it depends on what object and what material.

6 0
3 years ago
Which one of the following downloads and uploads files to and from a server? A. Client B. Internet protocol C. Server D. Worksta
earnstyle [38]
The answer is A. Client request and receive files to and from a server.
5 0
3 years ago
Systems such as smartphones, appliances, game controllers, cable set-top boxes and automobiles that contain small computers are
Setler [38]

I guess the correct answer is Embedded system.

Systems such as smartphones, appliances, game controllers, cable set-top boxes and automobiles that contain small computers are called Embedded systems.

8 0
2 years ago
Linda wants to change the color of the SmartArt that she has used in her spreadsheet. To do so, she clicks on the shape in the S
Julli [10]

Answer: Theme colors

Explanation:

Based on the directions, Linda most probably went to the "Theme colors" option as shown in the attachment below. Theme colors enables one to change the color of their smart shape.

It is located in the "Format tab" which is under "Drawing tools" in the more recent Excel versions. Under the format tab it is located in the Shape Styles group as shown below.

8 0
2 years ago
Other questions:
  • Discuss Hashing and how it is utilized within the IT industry. Also, discuss how Hashing can improve our sorting and searching r
    12·1 answer
  • You use worksheets to perform calculations. How do you perform these calculations?
    15·2 answers
  • A(n) __________attack is designed to render the target unreachable by legitimate users, not to provide the attacker access to th
    8·1 answer
  • A _____ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-c
    6·1 answer
  • Anybody good with Microsoft excel? I need help with this class.
    9·2 answers
  • If Tracy starts on the left edge of the canvas and moves forward 50 pixels, how many times will this code need to be repeated to
    5·1 answer
  • Will give brainliest
    8·1 answer
  • There are parallels between the trust models in Kerberos and Public Key Infrastructure (PKI). When we compare them side by side,
    15·1 answer
  • Does anyone know this? Can someone please help me? I’ll give brainliest!!
    7·1 answer
  • Ups developed software called ____ to enable u.s. customs and border protection agents to inspect packages that pass through the
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!