1. Which SQL statement is used to remove all data from a table but keep the table structure intact in MSSQL?
2. What is the purpose of the SQL Server function "PARSE" or "TRY_PARSE"?
3. What is the purpose of the SQL Server function "FORMAT"?
4. What is the purpose of the SQL Server function "CROSS APPLY"?
5. Which SQL statement is used to add a new row to a table in MSSQL?
6. Which SQL statement is used to delete a database in MSSQL?
7. What is the purpose of the SQL Server function "RANK()" when used with the OVER() clause?
8. Which SQL statement is used to retrieve a random sample of rows from a table in MSSQL?
9. What is the purpose of the SQL Server function "TRY_CONVERT"?
10. Which SQL statement is used to return only distinct (unique) values from a column in MSSQL?
11. What is the purpose of the SQL Server function "SESSION_CONTEXT"?
12. Which SQL statement is used to update data in a table with values from another table in MSSQL?
13. Which SQL statement is used to retrieve the current date and time in MSSQL?
14. Which SQL statement is used to create a new database in MSSQL?
15. What is the purpose of the SQL Server function "CHOOSE"?