Funcs for Date Formatting (Like Oracle TO_CHAR)

Function RJZeroN is used for formatting integer numbers as right-justified strings with leading zeroes according to a specified size (max 20 characters which will hold the largest BIGINT value).  A NULL value is returned if the formatting cannot be done according to the values specified.Example: Format a 3-digit number as a 7-character numberstring with leading […]

2004-03-24

896 reads

Blogs

Stellar Toolkit for MS SQL - Software Review

By

As a SQL database administrator, I am responsible for maintaining our organization's SQL Server...

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

shared datasets and cache refresh option

By ricky969

hi guys! Problem:  1) Every time I overwrite an existing shared dataset (with a...

Question on report server database

By itmasterw 60042

Hi,   We just installed SQL Server 2019 on a new server and moved...

Disclosing the How

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Disclosing the How

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers