2007-03-07 (first published: 2003-06-30)
396 reads
Nagabhushanam Ponnapalli
Initcap Function
INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
2006-05-29 (first published: 2003-07-02)
538 reads
Using Built in Functions in User Defined Functions
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
2003-08-07
6,078 reads
2003-07-02
561 reads
2003-07-02
262 reads
SUBSTR - SUBSTRING function extension
SUBSTR returns a portion of char, beginning at character @StartPos, @Length characters long. If @StartPos is 0, it is treated as 1. If @StartPos is positive, Oracle counts from the beginning of char to find the first character. If @StartPos is negative, Oracle counts backwards from the end of char.
2003-07-02
240 reads
INSTR Function
INSTR searches string for substring. --> position is an integer indicating the character of string where SQL Server begins the search. -->If position is negative, SQL Server counts and searches backward from the end of string. occurrence is an integer indicating which occurrence of string SQL Server should search for. The value of occurrence must […]
2002-11-12
1,174 reads
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
backup job is failing
I have configured always on and log backup is failing with the error Command:...
Limiting the Data Frame
Comments posted to this topic are about the item Limiting the Data Frame
Micro Credentials
Comments posted to this topic are about the item Micro Credentials
Ask SSC