This function allows the user to pass in a string / character value and it will padd the value according to given parameters. The parameters are as follows:@ValueToPad = Value to be padded by function.@PadCharacter = Character used to pad a given value.@Justification = Justification format bit 0 - Value will be RIGHT justified […]
2002-09-06
264 reads
This function strips a list of characters from the value passed in. Useful for cleaning up input data and removing unwanted characters for streamlined data storage.
2002-09-06
334 reads
Database backup made simple. You dont even have to pass any parameters if desired. It will all be handled for you.Capable of Net Send status notifications and writes status message to Windows event log.Side Effects:When not passing any @database params the the backup is done of the database where the proc resides. That means if […]
2002-09-06
569 reads
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
When Covid took out the PASS organization, I had someone say to me, “Well,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I have a SSRS report for which users are complaining to be slow, but...
Hi I set this up today. I wanted to get some feedback. I have...
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers