Microsoft SQL Server & Azure Sample Code & Scripts

Sample Code For Your Microsoft SQL Server Database

Winning Solutions, Inc. (WSI) has developed hundreds of SQL Server functions throughout our history. Included below are some links to a few sample functions. Feel free to use this code in your databases.

height: 48px;">Generate Randon Number

Split String to Table

Index Fragmentation List

Re-Index All Tables

Finding Table Scans

Shrinking Transaction Log

Identity Insert

Display Week Day Name

Output a Date Range

Display BirthDate as Years/Months

Identify Missing Indexes

Deleting All Records in a Table - Truncate Table

Getting the Next Number in a Custom Number Format

Like Wildcard Search

Using CharIndex Function

Using SubString Function

Using Left and Right Functions

Get Object References for an Object

Get Number of Records in Every Table

Find String in any Column

Execute Dynamic SQL

Using the DateAdd Function

Using the DateDiff Function

Using the DatePart Function

Using the DateName Function

Using the getDate Function

Add Default to Existing Column

Using the Convert Function with a Date

Using the Format Function with a Date

Using the sp_who2 Function

Using the ASCII Function

Using the CHAR Function

Using the CONCAT Function

Using the LEN Function

Using the LOWER Function

Using the LTRIM Function

Using the NCHAR Function

Using the PATINDEX Function

Using the QUOTENAME Function

Using the REPLACE Function

Using the REPLICATE Function

Using the REVERSE Function

Using the RIGHT Function

Using the RTRIM Function

Using the SOUNDEX Function

Using the SPACE Function

Using the STR Function

Using the STRING_AGG Function

Using the STRING_ESCAPE Function

Using the STRING_SPLIT Function

Using the STUFF Function

Using the TRANSLATE Function

Using the TRIM Function

Using the UNICODE Function

Using the UPPER Function

Using the APPROX_COUNT_DISTINCT Function

Using the AVG Function

Using the CHECKSUM_AGG Function

Using the COUNT Function

Using the COUNT_BIG Function

Using the GROUPING Function

Using the GROUPING_ID Function

Using the MAX Function

Using the MIN Function

Using the STDEV Function

Using the STDEVP Function

Using the SUM Function

Using the VAR Function

Using the VARP Function

Using the @@DBTS Function

Using the @@LANGID Function

Using the @@LANGUAGE Function

Using the @@LOCKTIMEOUT Function

Using the @@MAX_CONNECTIONS Function

Using the @@MAX_PRECISION Function

Using the @@NESTLEVEL Function

Using the @@OPTIONS Function

Using the @@SERVERNAME Function

Using the @@SERVICENAME Function

Using the @@SPID Function

Using the @@TEXTSIZE Function

Using the @@VERSION Function

CREATE ASYMMETRIC KEY Function

CREATE FULLTEXT INDEX Function

If you need any help implementing these functions or modifications made for your needs, please Contact Us to get a free quote for your Microsoft SQL Server Development needs.

Learn more about the quoting process we use at WSI.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.

Useful Links

Contact Info

836 N. 2nd St.
Box 726
Ames, Iowa 50010

(515) 239-9900
Fax: (515) 239-9800

informationwsi@winningsolutionsinc.com