Currently viewing the tag: "John F. Miner III"
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the UPPER() function today.
The UPPER() function takes a source string as input and returns a output string with all alpha characters converted to upper case.
The following example converts [...]
I am going to write a series of very short articles or tidbits on Transaction SQL (TSQL) functions. I will exploring the UNICODE() function today.
Transaction SQL (TSQL) supports the UNICODE() function that takes a NCHAR or NVARCHAR datatype as input and returns a INT datatype as output. The output value [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the SUBSTRING() function today.
The SUBSTRING() function allows a developer to slice and dice a string into pieces. It takes a source string [T], a integer starting position [S], and [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the STUFF() function today.
The STUFF() function takes a source string [S], a starting position [P], a total length [L] and a replacement string [R] as input parameters. It removes [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the STR() function today.
The STR() function takes a floating point number [F] to be converted to a string, a integer number [L] representing the total length, and a integer [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the SPACE() function today.
The SPACE() function takes a positive integer replication count [C] as input. The function returns a string composed of a single space concatenated [C] times to [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the SOUNDEX() function today.
The SOUNDEX() function calculates a four-character code that is based on how the string sounds when spoken. Please see my prior blog entry for a [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the RTRIM() function today.
The RTRIM() function takes a source string as input and returns a output string with all trailing spaces removed.
The following example removes trailing spaces from [...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the RIGHT() function today.
The RIGHT() function takes the source string [S] and number of characters [X] as input and returns the [X] rightmost characters from string [S] as output.
[...]
I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the REVERSE() function today.
The REVERSE() function takes a source string as input and returns each character in the reverse order as output. Therefore, the last character input string is [...]
Categories
- Database Admin (39)
- Database Developer (73)
- Integration Services (5)
- Other (11)
- Perl Scripting (7)
- SQL Pass Events (7)
- SQL Tidbits (24)
- Under Construction (1)
- VB Script (10)
Calendar
May 2013 M T W T F S S « Apr 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Cloud Tags
AFTER ALTER TABLE ALTER TRIGGER CPAN perl modules CREATE DATABASE create function CREATE FUNTION create procedure CREATE TABLE create trigger create view database administrator database developer DATA TYPES DDL DECLARE DELETE DROP DATABASE DROP TRIGGER DROP VIEW execute EXISTS FORMAT free code INSERT ISNULL John F. Miner III perl script REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.databases sys.objects sys.schemas TRIGGERS TRUNCATE TABLE TSQL UPDATE USER DEFINED VIEW vb script
