# SQL Server Interview Questions

## SQL Server Scenario Based Interview Questions and Answers

- How to sort result set in custom order in SQL?
- How to generate Permutations in SQL?
- How to calculate total travel hours between city x and y and vice versa
- How to find an account balance in SQL?
- How to swap column value in SQL?
- How to concatenate values from previous row to current row in SQL?
- How to find the missing numbers in a series?
- What happens to the variable value set during the transaction, if its rollback?
- What happens to the records inserted into a table variable, if the transaction rollback?