Exception handling in SQL Server

                    
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...

Question of the Week -08/04/2014

Suppose we need to find out the name of all the months in a given year (Year will be given...

Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?

Options:-

a) 1

b) 2

c) More...

Happy Holi

Holi is the time to unwind de-stress and bond with sweets,Thandai and colours.Come let’s rejuvenate by immersing ourselves in the...

Question of the Week - 11/1/2014

Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...

Answer - Objective Question (In which database temporary tables are created in SQL Server)

Question :- In which database temporary tables are created in SQL Server?

1) User database (where temporary table are defined)
   
2) Master...

Answer -Question of the Week - 2/1/2014 - Question 1

Question :-

Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...

Answer - Objective Question (Which table is called Heap table in SQL Server)

Question:-

   Which table is called Heap table in SQL Server.

1) Table without any indexes

2) Table without any clustered index (Correct...

Question of the Week - 2/1/2014 - Question 1

Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...

Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :- 

How many non clustered indexes are possible in a table in SQL Server 2008R2

1)  1
2) 249
3) 999  (Correct answer)
4)...