1. Which SQL statement is used to create a new view in MSSQL?
2. What is the purpose of the SQL Server function "FORMATMESSAGE"?
3. Which SQL statement is used to rename a table in MSSQL?
4. What is the purpose of the SQL Server function "TRY_CAST"?
5. Which SQL statement is used to retrieve the first row from a result set in MSSQL??
6. What is the purpose of the SQL Server function "OFFSET" when used with the "FETCH" clause?
7. Which SQL statement is used to create a new user-defined function (UDF) in MSSQL?
8. What is the purpose of the SQL Server function "INDEXPROPERTY"?
9. Which SQL statement is used to grant specific privileges to a user or role in MSSQL?
10. What is the purpose of the SQL Server function "STRING_SPLIT"?
11. Which SQL statement is used to retrieve data from multiple tables based on related columns in MSSQL?
12. What is the purpose of the SQL Server function "SESSION_ID"?
13. Which SQL statement is used to change the data type of a column in MSSQL?
14. What is the purpose of the SQL Server function "CONCAT"?
14. Which SQL statement is used to roll back a transaction and undo its changes in MSSQL?