Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.
SQL SERVER – Reverse String Word By Word Part 4
In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.
SQL SERVER – Reverse String Word By Word Part 3
Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
SQL SERVER – Fixing Backup Error – Operating system error 5(Access is denied.) – SQL in Sixty Seconds #077
Operating system error 5, Access is denied, is one of the most searched SQL Server errors. This short video shows how to fix this Backup Error permission issue.
SQL SERVER – Reverse String Word By Word
A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.
SQL SERVER – Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076
A SQL in Sixty Seconds puzzle: why does ISNUMERIC return unexpected results for some values? Watch the short video and see if you can explain it.