I rewrote my User Defined Function to extract only numbers from a string. The new one uses a numbers table, also called a Tally table, instead of a WHILE loop.
SQL SERVER – Generating Fixed Width OTP Values with Cryptographic Randomness
A Random Function for a six-digit code needs suitable randomness and deliberate formatting. A reader wanted codes for new app registrations.
Which is Faster – INSERT INTO SELECT or SELECT INTO? – Interview Question of the Week #187
Which is faster, INSERT INTO SELECT or SELECT INTO? A client moving large data between tables asked me, and here is what we found when we tested both.





