Category Archives: SQL Server Interview Questions and Answers

What are the aggregate functions in SQL server? Count, Min, Max and Average are the few aggregate functions in SQL Server. Count function:  Select count (*) from Table1.  It will deliver count of the table i.e. no of records. If … Continue reading →

These are the few tables which can be used to check the foreign key and primary key column in a table. It will give both columns from both tables. INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS   INFORMATION_SCHEMA.TABLE_CONSTRAINTS INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Company Asked : This question was asked in RBS India Technical round. There is the retail store with different products. A costumer can place multiple orders and one order one order can contain multiple products.  Product comes through a supplier. For this … Continue reading →

Normalization means to separate the data in multiple related tables using formal methods. I.e. its major objective is to divide larger tables in to smaller table to reduce data redundancy and improve perfor4mance of the data base. 1.           Some basic … Continue reading →

This site contains SQL Server Interview Questions and Answers. Below Links are for all SQL Server components. clicking on link you will get the consolidated all post for interview questions on topic wise.you can also click on labels in side … Continue reading →

Question: What is the nesting level of triggers? Answers: A trigger nesting is possible for up to 32 levels. Question: What happens if a transaction is failed in nested transaction, then other outer transactions will execute or not? Answer: If … Continue reading →

Question: Can we insert null value in primary column? Answer: Nopes we can’t insert null values in primary column. Question: Can we create clustered index on null value column? Answer: Yes we can create clustered index on null value column … Continue reading →

Here are the collections of SQL Server interview questions which are for the one who are  looking for interview questions for SQL Developers or who are looking for SQL Server Interview Questions for freshers . Major focus in this series … Continue reading →

Question: What is the Limit of small date time function? Answer: Max limit for small date time is 2079 and Min limit is 1900. More than this limit will end up in error. Question: What is the @@error? Answer: @@Error … Continue reading →

Question: Write a query to find the nth minimum and maximum Answer: For Minimum Select * From table t1 Where     (n-1) = (Select Count(Distinct(t2.column)) From table t2 Where                                 t2.column < t1.column) For maximum Select * From table t1 … Continue reading →