TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words.
When to Use IDENT_CURRENT? – Interview Question of the Week #150
Question: When to Use IDENT_CURRENT and SCOPE_IDENTITY()?
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question:Â How to Assign Multiple Variables in a Single T-SQL Query?Â
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How to Validate Email Address in SQL Server?
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
In the last puzzle, user had to write the shortest code to produce 0. I have received around 700 valid answers and while reading through the answers, I had a blast. I personally learned quite a lot from just administrating the quiz. Since that puzzle, I have received quite a few emails requesting to come up with next puzzle.
SQL SERVER – Simple Explanation of AT TIME ZONE Feature
Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit slow. However, let us understand how this function really works in a few simple words.Â
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.