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

Which of the following could be true of two diffrent speicies that have competitieve realtionship in the same ecosytem?

chubhunter [2.5K]

they both an enemy that is the same but they also have a same niche so the have the same niche

6 0

3 years ago

In most signal "timing diagrams" (like the one below) the signals do not change from low to high, or from high to low, abruptly.

melisa1 [442]

Explanation:

This transient state occurs due to the fact that the signal change from low to high and high to low doesn't occur intermediately but in a very small time, in relation to the signal time itself.

At transistor level there are parasitic (undesired) capacitances and resistances, formed due to the layout configuration of conductor and dielectrics. As consequence a RC circuit is formed, thus making a propagation delay.

This delay must be characterized for each circuit, and specified as tpHL (transition time from High to Low) and tpLH (transition time from Low to High)

8 0

3 years ago

You give an object a more meaningful name by setting the object’s _________________ property.

viva [34]

Answer:

The correct answer to this question is "Name".

Explanation:

In the programming language, the object is a part of the object-oriented programming language (oops).In all (oops) programming language we use class and object. where class is a collection of data member and member function, and object is a real-world entity. An Object is an instance of a Class. When a class is created, no memory is assigned but when we create the object of the class then memory is allocated.

In this question except option (d), all options are wrong.

7 0

3 years ago

When someone asks, Is this information specific enough?, he or she is interested in more _____.

AVprozaik [17]

Answer:

precision

Explanation:

In simple English precise means exact or something specific

5 0

3 years ago

Read 2 more answers

In the formula =C5*$B$3, C5 is what type of cell reference?

Feliz [49]

Answer:

relative

Explanation:

i just got a 100 and it says its right on odsyware

8 0

3 years ago