Currently viewing the tag: "TSQL"
I am going to carry one with my series of very short articles or tidbits on Transaction SQL Operators. An operator is a symbol specifying an action that is performed on one or more expressions.
I will exploring the Bitwise Operators today. Every piece of data on a computer is stored [...]
I am going to continue the series of very short articles or tidbits on Transaction SQL Operators. An operator is a symbol specifying an action that is performed on one or more expressions.
I will exploring the Assignment Operator today. This equality symbol = in mathematics.
There are two ways [...]
I am going to start a series of very short articles or tidbits on Transaction SQL Operators. An operator is a symbol specifying an action that is performed on one or more expressions.
I will exploring the Arithmetic Operators today.
The very first practical use of modern day computers was to [...]
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 [...]
Categories
- Database Admin (39)
- Database Developer (76)
- Integration Services (5)
- Other (11)
- Perl Scripting (7)
- SQL Pass Events (7)
- SQL Tidbits (24)
- Under Construction (1)
- VB Script (10)
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
