1.

Explain collation recursion and its procedure?

Answer»

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.



Discussion

No Comment Found