Collation is defined to identify, specify the sort order.

There are three types of sort orders which are-
  • Binary
  • Case sensitive
  • Case insensitive

Recursion stored procedure- This procedure is defined as a series of processes for resolving any issue where a solution occurs continuously. This procedure can be nested up to 32 levels. This is a very important MSSQL interview question you can also refer to its details.

BY Best Interview Question ON 17 Oct 2019