FirstDayOfMonth() and LastDayOfMonth() functions
Here are a couple of handy date functions that pretty much describe themselves. You can use these to figure out how many days are left in a month.
2002-12-08
607 reads
Don Frazier
zPad() - add leading zeros to a number
This user-defined function converts a number to character format and adds leading zeroes to pad the field to a specified length. useful for displaying SSNs or other numeric fields where the leading 0's are significant but the field is stored as numeric.To use:select dbo.zPad(, )make sure your length includes an extra column for the sign. […]
2002-12-05
406 reads
Convert a number to words
This is a handy function that converts a number (integer) into its word format. This might be handy if you need to print a check formatted number in words. Currently it supports an integer but it would be almost nothing to convert to support a bigint or decimal.The components are1) a table named PlaceValue that […]
2002-12-04
325 reads
PACK() user defined function
Convert a decimal number to IBM EBCDIC packed decimal format. If for some reason you need to export a number to IBM systems in native format, you can define a SQL Server field as binary(8) and Pack() your decimal number into it. Then IBM mainframes and COBOL/CICS systems can read the numbers from your data […]
2002-12-04
528 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Log Shipping Not Able to Restore Log Files in Secondary
I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...
Smile and Wave Boys
Comments posted to this topic are about the item Smile and Wave Boys
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers