This page is dedicated to SQL frequently asked questions, and SQL Interview Questions with answers. It is always advisable to learn SQL Sever, before looking into these questions.
SQL Interview Questions and SQL FAQ’s
Basic Connections and Configurations
- Create ODBC Connection
- Create ODBC Connection- Using Native Client
- Connecting to R programming
- Configure Database Mail
- Create Native Client 11.0 Connection
Date and Time
Differences
- Difference between DATEPART and DATENAME
- Difference between UNION and UNION ALL
- Differentiate among CTE, Temp Tables, Derived tables, Table Variables
Joins
Groups
- Count Records in a Group
- Retrieve Last Record in each Group
- Select Top N Records for each Category
- Select First Row in each group
Select, Insert, Update, and Delete
- Delete Duplicate Rows
- Inserting values into Identity Column using IDENTITY INSERT
- Insert Stored Procedure result into Temporary Table
- Insert Images into Table
- Select Rows with Maximum Value on a Column
- UPDATE Table Columns from SELECT Statement
Strings
- Concatenate Rows into String
- Replace String in a Table Column
- Reverse String Words
- Extract Domain From Email
Tables and Columns
- Get Column Names from Table
- How to Swap Column Values
- How to check if a Table exists
- Identity Value Jumps after restarting
- Find all Dependencies on Table
- Find all Tables that Contain Specific Column Name
- Rename Table Name, and Column Name