If you need to save password for you application in tables, with this function you can save them encripted. And with another published function (check the page to find the script) you can desencript it. The function receives the password, modifies every character and returns the encripted password.
2004-03-18
593 reads
Dinesh did a little research on nulls and was kind enough to package it up for us. How many of you know or use NULLIF? Or COALESCE? Handy stuff!
2004-03-18
10,161 reads
We get books in occasionally for review and have started making them available to our existing authors. Jim was interested in this one - turns out he didn't find much to like. If you're a beginner it might be a better fit. Or maybe you've read the book and disagree?
2004-03-16
4,913 reads
If you need to alter existing datatypes in the event of a SQL Server Datatype issue for capacity planning or conversion process this simple schema script may come in handy
2004-03-15
126 reads
A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.
2004-03-15
6,079 reads
This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified. This makes the colons line up for easy reading. Commas are automatically added as thousands separators as needed by […]
2004-03-14
418 reads
Saw Mike's routine for counting occurences of a string in a string and I thought I'd offer a simpler solution.Simply replace the occurence with null and use length differences as shown.NOTE: len may ignore trailing spaces, so this can be made more solid by adding some non printable char (less likely to interfere with operation) […]
2004-03-10
79 reads
Regular columnist Chris Hedgate follow up on Andy's recent article about Worst Practices with one of his own. This is worth passing on to your development team.
2004-03-10
17,319 reads
This function will return the number of occurrences of one string within another string. I was looking for something like this recently, and the only thing I could find was needlessly complicated. Don't forget, when calling a scalar function, you must qualify with username like this:Select dbo.StringCount('Hi There','e') This function may be a little too […]
2004-03-09
303 reads
This function returns the difference between dates in the HH:MM:SS format.
2004-09-27 (first published: 2004-03-08)
106 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Not sure if this is a tech mistake I've made or a lack of...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers