A Series of SQL Server basics to advanced level SQL Interview questions and answers that are commonly asked in interivew.
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
There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL
2,065 total views, 12 views today
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
2,579 total views, 13 views today
Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL
4,126 total views, 26 views today
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
1,422 total views, 8 views today
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
942 total views, 8 views today
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
4,178 total views, 22 views today
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
SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can… Read More »Difference between clustered index and non clustered index
2,193 total views, 7 views today
SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
2,484 total views, 5 views today
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
Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table
18,813 total views, 49 views today
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
2,631 total views, 7 views today
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
8,931 total views, 28 views today
There are various in-built system catalog views, or metadata functions that you can use to check the existence of column in SQL Server tables. To… Read More »Check if column Exists or not in SQL Server Table
31,161 total views, 70 views today
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
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
5,383 total views, 12 views today
Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor
1,153 total views, 5 views today
Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category
22,726 total views, 45 views today
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