What is the Default Datatype of NULL? Most people say NULL has no type. A quick SELECT INTO test shows which datatype SQL Server actually picks.
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130
What does BACKUP WITH NAME do? It simply names your backup, and you can then find that name in the msdb backupset table. Here is a quick example.
How Default Value and Nullable Column Works? – Interview Question of the Week #129
How do a default value and a Nullable Column work together in one table? Two short scripts from an interview panel show exactly what SQL Server does.
What is Copy Only Backup in SQL Server? – Interview Question of the Week #128
Copy Only Backup is an independent backup that does not break the LSN chain or disturb your regular backup plan. Here is the short answer and a longer one.
How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127
How to write CASE statement in WHERE clause? First, CASE is an expression, not a statement. Here is how to use it for optional search conditions.
How to Add Column at Specific Location in Table? – Interview Question of the Week #126
Question: How to Add Column at Specific Location in Table?
Answer: Order of the column in the table should not matter.
How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125
How do you round up or round down a number in SQL Server? A quick answer using ROUND, CEILING and FLOOR, and how each one behaves.