SQL SERVER

The blogs helps you from basic concept related to SQL Server , and covers advanced topics. If you have good understanding on any topics on SQL Server Kindly share or discuss with us.

 Important  SQL server Questions--:

 What is CTE?

 Difference between TEMP TABLE , TEMP Variable AND Table Types

 Difference between Stored Procedure Vs Function

 What is Indexe in SQL Server? (CLUSTER & NON Cluster)

 What is Views ? Can we delete/update data in view? 

 What is Magic Tables?

 What is Triggers? (DIFF B/W after insert and before insert)

 How to handle Exception in SQL ? (TRY CATCH)

 What is TRANSACTION in SQL?  (NESTED  TRANSACTION & SAVE TRANS)

 Difference between @@IDETITY, SCOPE_IDENTY(), IDENTITY_CURRENT in SQL?

 What is MERGE STATEMENT in SQL?

 Write SQL Query for TOP Nth Max Salary ?

 Write SQL Query for CALCULATE quarterly sales?

 Difference between VARCHAR VS NVARCHAR ?

 Write SQL Query DELETE DUPlicate RECORD ?

 What is STUFF & COALESCE function in sql?

 What is Difference between EXEC(), EXEC ?

 What is Diffenrecne between CAST AND CONVERT() ?

 What is difference WHERE & having Clause?

 What is Dense Rank ? Write Query for ROW_NUMBER() ,RANK() , DENSE_RANK()?

 What is HEAP TABLE ?

 What is CURSOR? When we neet to use cursor?

 What is @@ERROR in SQL Server?
 Print Number from 1 to 100 in SQL.
What is Update Statsatics?