CLR Reference

{TOC}

Load Dictionary

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

Details

Dictionary Substitution

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

Details

Generic Shuffle

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

Details

Address

<.component name><. Purpose><.Algorithm>SQLCLR:

Details

AddressSELECT Direction[dbo].[AddressRandom] Dynamic

<.component(<@address, name><. Purpose><.Algorithm> nvarchar(4000)>)

Details

Address Direction Random

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

Details

Address Dynamic

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

Details

Address Number Dynamic

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

Details

Address Number Random

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

Details

Address Street Name Dynamic

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

Details

Address Street Name Random

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

Details

Address Suffix Dynamic

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

Details

Address Suffix Random

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

Details

Credit Card

<.componentSQLCLR: name><.

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

Details

Credit Card Dynamic

<.componentSQLCLR: name><.

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

Details

City Name

<.componentSQLCLR: name><.

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

Details

City Name Dynamic

<.componentSQLCLR: name><.

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

Details

Company Name Dynamic

<.componentSQLCLR: name><.

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

Details

Company Name Random

<.componentSQLCLR: name><.

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

Details

Country Code

<.componentSQLCLR: name><.

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

Details

Country Code Dynamic

<.componentSQLCLR: name><.

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

Details

Date Of Birth

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

Details

Decimal Number

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

Details

Email Dynamic

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

Details

First Name

<.componentSQLCLR: name><.

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

Details

First Name Dynamic

<.componentSQLCLR: name><.

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

Details

Full Name Info

<.componentSQLCLR: name><.

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

Details

Full Name Info Dynamic

<.componentSQLCLR: name><.

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

Details

Generic Alpha Numeric

<.componentSQLCLR: name><.

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

Details

Generic Alpha Numeric Dynamic

<.componentSQLCLR: name><.

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

Details

Generic Phone Nu

<.componentSQLCLR: name><.

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

Details

Generic Phone Nu Dynamic

<.componentSQLCLR: name><.

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

Details

Last Name

<.componentSQLCLR: name><.

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

Details

Last Name Dynamic

<.componentSQLCLR: name><.

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

Details

SSN

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

Details

SSN Dynamic

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

Details

State Province

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

Details

State Province Dynamic

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

Details

URL

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

Details

URL Dynamic

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

Details

US Phone Nu

<.componentSQLCLR: name><.

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

Details

US Phone Nu Dynamic

<.componentSQLCLR: name><.

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

Details

Zip Code

<.componentSQLCLR: name><.

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

Details

Zip Code Dynamic

<.componentSQLCLR: name><.

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

Details