What happens if null values are involved in arithmetic operations?
- 1 Answers
- 1091 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shivam Shukla
When null values are involved in arithmetic operations, the result will be NULL unless you use ISNULL(), COALESCE(), or another method to handle null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Why should you use or avoid select * statements?
Why we use the openxml clause?
When should you use an instead of trigger?
Explain system functions or built-in functions? What are different types of system functions?
do you know how to configure db2 side of the application? : Sql server database administration
How to enter binary string literals in ms sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is a coalesce function?
What are the kinds of subquery?
What is subquery? Explain the properties of a subquery?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is an indexed view?
How efficient you are in oracle and SQL server?
