Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.
SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?
Rin Sitah replied to my interview question with a neat alternative way to build three part name from Object_ID using sys.objects and sys.schemas.
How to Build Three Part Name from Object_ID? – Interview Question of the Week #134
If you only have an object_id, can you get the database, schema and object name? Here is a simple script that builds the Three Part Name from Object_ID.
SQL SERVER – Find Out Column Name Using COL_NAME() Function
Need a column name from its ordinal position? Besides querying sys.columns, the COL_NAME() system function returns it directly. Here is how to use it.
SQL SERVER – Puzzle – Incorrect Results with Decimal
A new puzzle: a simple table with price and discount returns Incorrect Results with DECIMAL. Can you work out why without running the code in SSMS?
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.