What is the difference between nvl and nvl2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Can you name some of the dml commands in sql?

0 Answers  


Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,


i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,


What is filter index?

0 Answers  


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  






What do I need to start working with sql studio? : sql server management studio

0 Answers  


What is the command to change the recovery model?

0 Answers  


What is built-in function?

0 Answers  


Which is faster statement or preparedstatement?

0 Answers  


What is 'Join' and explain its various types.

0 Answers   Genpact,


How do you persist objects, permissions in tempdb

1 Answers  


What happens if we shrink log file in sql server?

0 Answers  


Categories