Home » SQL SERVER » SQL Interview Q & A

SQL Interview Q & A

A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.

How to get top salary of each department

To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department

 1,957 total views,  15 views today

How to fetch alphanumeric string from table

Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table

 9,391 total views,  49 views today

Insert multi language data in table

Sometimes, you need to store multi language or multilingual data in any table column. Inserting a multilingual data into column without following some basics rules,… Read More »Insert multi language data in table

 3,517 total views,  4 views today

Script table in SQL Server

You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server

 928 total views,  5 views today

IDENT_CURRENT Function

The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function

 1,844 total views,  7 views today