April 2014 - Technology with Vivek Johari

Question of the Week -08/04/2014

April 8, 2014April 27, 2018 vivekjohari30 Comments

Suppose we need to find out the name of all the months in a given year (Year will be given as an input parameter) where first day of the month falls on weekend (Saturday or Sunday). So what should be the query/stored procedure to get the above result?

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

April 8, 2014April 27, 2018 vivekjohari31 Comments

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 than 1 Answer :- Option a) 1 In SQL Server, we can Insert only one null value in a column where we have defined the Unique Constraint. For Example , suppose […]