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.
How to Insert Line Break in SQL Server String? – Interview Question of the Week #139
Question: How to Insert Line Break in SQL Server String?
What is the Biggest Limitation of ISDATE() Function? – Interview Question of the Week #137
Question: What is the Biggest Limitation of ISDATE() Function?
SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero
Puzzle: Write a Shortest Code to Produce Zero.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
How to Allow Only Alphabets in Column? – Interview Question #136
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?
Earlier this week, I posted an interesting interview question How to Build Three Part Name from Object_ID? – Interview Question of the Week #134. In its response, I have received a very interesting reply from Rin Sitah over here.