All categories

2 years ago

Use the SQL Server Management Studio to complete the following.

Computers and Technology

1 answer:

scZoUnD [109]2 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

What type of block start a sequence?

ss7ja [257]

Answer:

An algorithm?

8 0

2 years ago

comparing the cost of care provided to medicare beneficiaries assigned to primary care nurse practitioners and physicians

Aleks [24]

"Comparing the cost of care provided to Medicare beneficiaries assigned to primary care nurse practitioners and physicians" is a study that

<h3>What is the cost of Medicare according to the above study?</h3>

The study shows that after controlling for demographics, geography, comorbidities, and proclivity to visit an NP, Medicare evaluation and management payments for patients allocated to an NP were $207, or 29%, less than PCMD assigned beneficiaries.

The similar tendency was seen for inpatient and total office visit payment amounts, with NP-assigned beneficiaries receiving 11 and 18 percent less, respectively. The work component of relative value units yields similar results.

Learn more about Medicare:
brainly.com/question/1960701
#SPJ4

8 0

1 year ago

Pressing and holding _______ while clicking enables you to select multiple contiguous files or folders.

liq [111]

Answer:

Hi LizBiz! The answer is Ctrl key on Windows, or Command key for Mac.

Explanation:

The Ctrl (Windows) key or equivalent Command key on Mac has a special purpose which allows special operations to be performed when combined with another action, such as clicking on multiple pictures or files for selection.

8 0

2 years ago

Universal Containers is designing a new community using the Customer Community license type. They would like to have the users c

motikmotik

Answer:

The correct option is B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

Explanation:

Note: This question is not complete as the options are not included. The complete question with the options is therefore provided before answering the question as follows:

Universal Containers is designing a new community using the Customer Community license type. They would like to have the users complete survey questions through the community interface and store the responses in a Custom Object that has a lookup to the account object. Any internal user who has access to the account should be able to see all survey responses. All Customer Community users should be able to see surveys filled in by other users for their company, but not surveys for other companies. What are the correct security settings to achieve this?

A. Set all Organization-Wide Default security to be "Public Read/Write" for internal users and "Private" for external users.

B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access

C. Set all Organization-Wide Default settings to be "Public Read/Write" for both internal and external users.

D. Set the custom object to be master-detail to the Account and leave the Organization-Wide Default settings as their default values.

The explanation of the answer is now provided as follows:

Organization Wide Default security refers to settings that provides most restrictive settings that may be opened up by Role Hierarchy and Role hierarchy can be opened by Sharing rules. And the visibility of records at the record level is determined by all of these factors. Private, Public Read, Read/Write, and Read/Write & Transfer are the four permissions available in Sharing Rules.

The rules that are used to offer sharing access to users in public groups, roles, or territories are referred to as sharing rules. By introducing automatic exceptions to your org-wide sharing policies, sharing rules allow certain users more access.

By implication, the correct security settings to achieve the objective stated in the question is to set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

Therefore, the correct option is B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

5 0

3 years ago

Exercise 8.1.9: Diving Contest Your school is hosting a diving contest, and they need a programmer to work on the scoreboard! Yo

vampirchik [111]

Answer:

def calculate_score(theTuple):

first, second, third = theTuple

if first >= 0 and first <=10 and second >= 0 and second <=10 and third >= 0 and third <=10:

print(first + second+third)

else:

print("Range must be 0 to 10")

Explanation:

This line defines the function

def calculate_score(theTuple):

This line gets the content of the function

first, second, third = theTuple

The following if condition checks if the digits are in the range 0 to 10

if first >= 0 and first <=10 and second >= 0 and second <=10 and third >= 0 and third <=10:

This calculates the sum

print(first + second+third)

else:

If number is outside range 0 and 10, this line is executed

print("Range must be 0 to 10")

4 0

3 years ago