Calculated fields can be entered in queries. What row should you type a calculated field in?

1 answer:

7 0

Computed columns in SQL are calculated columns where the value of the column will be automatically inserted according to the formula specified.

Suppose Net salary = Gross_salary – PF, so this can be created as,

Create table Employee(empno, empname, Basic, HRA, PF, Gross_Sal = Basic+HRA,Net_salary = Gross_salary-PF)

When you query Select * from Employee, all the fields along with the calculated column values will get displayed. Even if you update on the field, changes will be automatically done in calculated column.

You might be interested in

For some people , alcohol can cause an uncontrollable blank of the eyes , making good vision almost impossible

ss7ja [257]

The statement above wil be completed.

For some people, alcohol can cause an uncontrollable vibration to the eyes, making good vision almost impossible. This vibration is called nystagmus or the eyes getting dizzy and shaky. This nystagmus occurs when a person drinks too much and reaches his limit in alcohol intake.

7 0

2 years ago

When comparing different biometric systems, one of the most important metrics used is called the _________, which represents the

Airida [17]

Answer:

Crossover Error Rate(CER)

Explanation:

Crossover Error Rate is an important metrics in the biometric systems.It is the value of FRR and FAR when the sensitivity is framed so that FRR and FAR are equal. The Crossover Error Rate(CER) is suitable for quantitative comparison of different biometric devices, applications or solutions.

8 0

3 years ago

Andy intends to register his own domain name on the Internet for a minimal cost per year. Before he selects and registers a doma

Tom [10]

Answer:

.co

Explanation:

he has a company

6 0

3 years ago

a marketing company is setting up a new office in the city. which type of contract should they sign for periodic maintenance of

True [87]

Answer:

The contract they had to sign was a computer maintenance contract with computer service providers.

Explanation:

Why do companies have to maintain computers regularly?

Because of all the activities of the company at this time on average use applications from computers. With the maintenance of computers, the activities of the company will continue to run well.

There are two types of maintenance that can be carried out:

Hardware Maintenance
Software Maintenance

#AnswerForTrees

8 0

2 years ago

Explain why the computer is powerful working tool???

notsponge [240]

Answer:

here ya go

Explanation:

A computer is a powerful tool because it is able to perform the information processing cycle operations (input, process, output, and storage) with amazing speed, reliability, and accuracy; store huge amounts of data and information; and communicate with other computers.

8 0

2 years ago