Monthly Archives: December 2010

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 →

Question: What is NO COUNT used for? Answer: It’s used to check whether the sql statement executed successfully or not. When no count is on than this message will not return and while it off then sql server returns the … Continue reading →

Question: How many columns can be used with roll up or with cube command? Answer: 10 columns Question: How many clustered index can be created on the table? Answer: Only one clustered index can be created. Question: How many columns … Continue reading →

Question: What are dynamic queries? Answer: Dynamic Queries are the query in which logic can be change at run time. These queries are created by using the variables. Question: What is distinct clause? How it works? Answer: Distinct clause is … Continue reading →

Question: What is the User defined functions? Answer: User defined functions are the objects which used to for performs some particular task or retrieves some particular data. Function always returns some values. Question: What are the difference types of UDF? … Continue reading →

Question: What is common table expression (CTE)? Answer: CTE is a new feature introduced in SQL Server 2005. CTE is a virtual view which exists at runtime. It can be used for the logic which need to be used other … Continue reading →

Question: What is select statement in TSQL? Answer: It’s an elementary question but the beginners can go through face this kind of questions i.e. fresher’s having no experience. Select statement is the first keyword in any query. It used to … Continue reading →

Question: What are the different types of data types in SQL Server? Answer: There are different types of data types used in SQL Server 1.          Int 2.          Small int 3.          Big int 4.          Tiny int 5.          Float 6.          Double 7.          … Continue reading →