MSSQL DATABASE INTERVIEW QUESTIONS

What is the difference between NULL and NOT NULL in MSSQL?

How do you specify a column to be NOT NULL in MSSQL?

How do you check for NULL values in an MSSQL query?

How do you handle NULL values in aggregate functions in MSSQL?

How do you convert NULL values to a specific value using MSSQL functions?

How do you modify a column to allow NULL values using the ALTER TABLE statement in MSSQL?

How do you handle NULL values in a conditional statement within a query in MSSQL?

How do you use NULLIF to handle NULL comparisons in MSSQL?

How do you enforce NOT NULL constraints on existing columns without affecting data integrity in MSSQL?

Explain a scenario where handling NULL vs NOT NULL is crucial for a business application in MSSQL and describe how you would implement it.