Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can…
Question of the Month (July)
Question of the Month Suppose we have a table emp_plan which contains 4 columns “Empid” (employeeid), Planid (Projectid), Startdate(Allocation Start…
Script to find complete months between two given dates
Complete months between two given dates Below script will help in finding the complete months within the 2 given dates.…
Script to find the complete weeks within two given dates
Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below…
Interview questions for database developer
Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the…
SQLTea – New SQL tutorial app in Google play store
SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial…
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)…
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…
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)…