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.
SQL SERVER – Remove Duplicate Chars From String – Part 2
I have already made a post on SQL SERVER – UDF – Remove Duplicate Chars From String where I showed you a method of removing duplicate characters form alphanumeric string. The UDF uses WHILE LOOP to extract the numbers.