985Questions
779Answers
Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address
Recent questions tagged t-sql

Recent questions tagged t-sql

Nice?Vote!
2 answers
Can you explain the difference between the INTERSECT and EXCEPT operators?
asked 1 year ago in SQL Server Interview Questions and Answers by Anand (1,440 points)
Nice?Vote!
5 answers
What is the difference between DDL and DML commands? Can you name some examples of each?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
+1 vote
1 answer
What is PIVOT feature in SQL Server, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What is SQL injection, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What is NTILE(), in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is DENSE_RANK(), in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is ROW_NUMBER(), in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is RANK (), in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
Why should you use CTE rather than simple views, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What are RANKING functions, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What is UNPIVOT, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is TRY/CATCH block in T-SQL, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
Select addresses which are between ‘1/1/2004’ and ‘1/4/2004’, in MS SQL Server?
asked 1 year ago by R (19,530 points)
Nice?Vote!
1 answer
What is CTE (Common Table Expression), in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
3 answers
What does COLLATE Keyword in SQL signify, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is a “CASE” statement in SQL, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What is “ALL” and “ANY” operator, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
Add
Ans!
What is “Correlated Subqueries”, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What is a Sub-Query, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What does “SET ROWCOUNT” syntax achieves, in MS SQL Server?
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points)
Page:
Powered by Question2Answer