Answer Posted / Tarakeshwar Kumar Puri
The ISNULL function in SQL Server returns a specified value if an expression is null, otherwise it returns the original expression. Here is an example: SELECT ISNULL(ColumnA, 'DefaultValue') FROM YourTableName;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is temporary table in sql server? Why we use temp table?
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?
How can I check that whether automatic statistic update is enabled or not?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is normalization and what are the advantages of it?
When should you use an instead of trigger?
What are the different types of subquery?
What is self contained sub query?
How can you append an identity column to a temporary table?
what is spatial nonclustered index
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
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Why and when do stored procedure recompile?
What are the properties of the transaction?
