User-defined Data Type Basics
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,157 reads
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,157 reads
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
559 reads
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
362 reads
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
230 reads
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
389 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Comments posted to this topic are about the item Scaling Up Monitoring
Comments posted to this topic are about the item Database Sequence Objects with dbatools
Comments posted to this topic are about the item Why a monitoring tool is...