CLR Reference

{TOC}

Address

SQLCLR:

SELECT [dbo].[AddressRandom] (<@address, nvarchar(4000)>)

Details

Address Dynamic

<.component name><. Purpose><.Algorithm>

Details

Credit Card

SQLCLR:

SELECT [dbo].[CreditCardRandom] (<@creditCard, nvarchar(4000)>)

Details

Credit Card Dynamic

SQLCLR:

SELECT [dbo].[CreditCardDynamic] (<@creditCard, nvarchar(4000)>)

Details

City Name

SQLCLR:

SELECT [dbo].[CityNamesRandom] (<@alphaNumeric, nvarchar(4000)>)

Details

City Name Dynamic

SQLCLR:

SELECT [dbo].[CityNamesDynamic] (<@alphaNumeric, nvarchar(4000)>)

Details

Company Name Dynamic

SQLCLR:

SELECT [dbo].[CompanyNameDynamic] (<@companyName, nvarchar(4000)>)

Details

Company Name Random

SQLCLR:

SELECT [dbo].[CompanyNameRandom] (<@companyName, nvarchar(4000)>)

Details

Country Code

SQLCLR:

SELECT [dbo].[CountryRandom] (<@country, nvarchar(4000)>)

Details

Country Code Dynamic

SQLCLR:

SELECT [dbo].[CountryDynamic] (<@country, nvarchar(4000)>)

Details

Date Of Birth

SQLCLR:

SELECT [dbo].[DateOfBirthDynamic] (<@birthDate, datetime>, <@shiftDays, int>, <@shiftMonth, int>, <@shiftYears, int>)

Details

Decimal Number

<.componentSQLCLR: name><.

SELECT Purpose><.Algorithm>[dbo].[NumberRandom] (<@number, numeric(18)>, <@range, int>)

Details

Email Dynamic

SQLCLR:

SELECT [dbo].[EmailDynamic] (<@email, nvarchar(4000)>, <@preserveServer, bit>)

Details

First Name

SQLCLR:

SELECT [dbo].[FirstNameRandom] (<@firstName, nvarchar(4000)>)

Details

First Name Dynamic

SQLCLR:

SELECT [dbo].[FirstNameDynamic] (<@firstName, nvarchar(4000)>)

Details

Full Name Info

SQLCLR:

SELECT [dbo].[FullNameRandom] (<@fullName, nvarchar(4000)>)

Details

Full Name Info Dynamic

SQLCLR:

SELECT [dbo].[FullNameDynamic] (<@fullName, nvarchar(4000)>)

Details

Generic Alpha Numeric

SQLCLR:

SELECT [dbo].[AlphaNumericRandom] (<@alphaNumeric, nvarchar(4000)>)

Details

Generic Alpha Numeric Dynamic

SQLCLR:

SELECT [dbo].[AlphaNumericDynamic] (<@alphaNumeric, nvarchar(4000)>)

Details

Generic Phone Nu

SQLCLR:

SELECT [dbo].[PhoneRandom] (<@phone, nvarchar(4000)>)

Details

Generic Phone Nu Dynamic

SQLCLR:

SELECT [dbo].[PhoneDynamic] (<@phone, nvarchar(4000)>)

Details

IP

SQLCLR:

SELECT [dbo].[IPRandom] (<@ip, nvarchar(4000)>)

Details

IP Dynamic

SQLCLR:

SELECT [dbo].[IPDynamic] (<@ip, nvarchar(4000)>)

Details

Last Name

SQLCLR:

SELECT [dbo].[LastNameRandom] (<@lastName, nvarchar(4000)>)

Details

Last Name Dynamic

SQLCLR:

SELECT [dbo].[LastNameDynamic] (<@lastName, nvarchar(4000)>)

Details

Names With Gender

SQLCLR:

SELECT [dbo].[NameWithGenderRandom] (<@name, nvarchar(4000)>, <@gender NVARCHAR (4000)>)

Details

Names With Gender Dynamic

SQLCLR:

SELECT [dbo].[LastNameDynamic] (<@lastName, nvarchar(4000)>)

Details

SIN

SQLCLR:

SELECT [dbo].[SINRandom] (<@sin, nvarchar(4000)>)

Details

SIN Dynamic

SQLCLR:

SELECT [dbo].[SINDynamic] (<@sin, nvarchar(4000)>)

Details

SSN

SQLCLR:

SELECT [dbo].[SSNRandom] (<@ssn, nvarchar(4000)>)

Details

SSN Dynamic

SQLCLR:

SELECT [dbo].[SSNDynamic] (<@ssn, nvarchar(4000)>)

Details

State Province

SQLCLR:

SELECT [dbo].[StateProvinceRandom] (<@stateProvince, nvarchar(4000)>)

Details

State Province Dynamic

SQLCLR:

SELECT [dbo].[StateProvinceDynamic] (<@stateProvince, nvarchar(4000)>)

Details

VIN

SQLCLR:

SELECT [dbo].[VINRandom] (<@vin, nvarchar(4000)>)

Details

VIN Dynamic

SQLCLR:

SELECT [dbo].[VINDynamic] (<@vin, nvarchar(4000)>)

Details

URL

SQLCLR:

SELECT [dbo].[UrlRandom] (<@url, nvarchar(4000)>, <@type INT>)

Details

URL Dynamic

SQLCLR:

SELECT [dbo].[UrlDynamic] (<@url, nvarchar(4000)>, <@type INT>)

Details

US Phone Nu

SQLCLR:

SELECT [dbo].[UsaPhoneRandom] (<@usaPhone, nvarchar(4000)>)

Details

US Phone Nu Dynamic

SQLCLR:

SELECT [dbo].[UsaPhoneDynamic] (<@usaPhone, nvarchar(4000)>)

Details

Zip Code

SQLCLR:

SELECT [dbo].[ZipCodeRandom] (<@ZipCode, nvarchar(4000)>)

Details

Zip Code Dynamic

SQLCLR:

SELECT [dbo].[ZipCodeDynamic] (<@ZipCode, nvarchar(4000)>)

Details