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.
COL_NAME Function in SQL Server: Get a Column Name by ID
The COL_NAME function returns a column’s name when you give it a table’s object ID and the column’s ID. This post uses it to turn the column IDs in index views into names, shows why a column ID is not a position once a column has been dropped, and explains the trap that returns a wrong name when the table lives in another database.
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.