Technical Article

fnCharPad

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 […]

You rated this post out of 5. Change rating

2002-09-06

253 reads

Technical Article

spEasyBackup

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 […]

You rated this post out of 5. Change rating

2002-09-06

564 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

MSSQL Service Broker DSQL operation on another database causing Broker failure

By andyewx

I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers