Question: How to Build Three Part Name from Object_ID?
SQL SERVER – Find Out Column Name Using COL_NAME() Function
In SQL Server, there are many methods to find out the column names in a table. If you want to find out the column names based on the ordinal position you can do it querying system view size. Columns. Do you know that you can also do this by using COL_NAME() system function?
SQL SERVER – Puzzle – Incorrect Results with Decimal
It has been a while we have seen a puzzle on this blog and I keep on receiving emails and comments that you all would love to see one more puzzle. Let us see a new puzzle “Incorrect Results with Decimal”.
What is Copy Only Backup in SQL Server? – Interview Question of the Week #128
Question: What is Copy Only Backup in SQL Server?
Answer: This is another interesting question I received the other day. The question was in the image form and I am re-producing the image again here.
How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127
Question: How to Write Case Statement in WHERE Clause?
SQL SERVER – Learning New Multipurpose FORMAT Function
In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.
SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY
Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?