Home
  Home
Home
Search
Articles
Page Tag-Cloud
  Software
Software Tag-Cloud
Submit Patch
Building from Source
Open Source Definition
  Popular Tags
C Plus Plus
Source Code
Legacy
Class
Console
  Members
Login
Web-Email
Notable Members
  Official
Our Company
Copyright Information
Software EULA
GPL EULA
LGPL Eula
Pre-Release EULA
Privacy Policy
  Support
Make Contact
 
DataRandomizer SQLCLR
Downloads   59
User Rating   (Rate)
Last Updated   5/2/2016
License   LGPL v3
- Download -
View all Releases
Recommended Release
Version   1.0.0.0
Date   5/2/2016
Status   Stable Stable software is believed to be stable and ready for production use.
View Comments Subscribe to Updates Submit Bugreport

This software is open source. You can obtain the latest source code from the SVN repository or browse the releases for the source code associated with a specific release. If you make any changes which you feel improves this application, please let us know via our Contact Page.

If you’ve ever needed to generate random data inside SQL server then you probably know what a pain it can be, especially when you need that data to be human readable cities, states, names, phone numbers, etc.

This CLR make the task quick, easy and performs very well! The download contains the CLR DLL, install script, example script and also a great deal of pre-generated word lists.

Please keep in mind that this CLR was designed for development and test environments and is not at all intended for production use.

 SQL Script:

SELECT
	dbo.GetRandomNumberString(10) as GetRandomNumberString,
	dbo.GetRandomFullAddress() as GetRandomFullAddress,
	dbo.GetRandomStreetAddress() as GetRandomStreetAddress,
	dbo.GetRandomPhoneNumber() as GetRandomPhoneNumber,
	dbo.GetRandomNumberOfWords(2, 5) as GetRandomNumberOfWords,
	dbo.GetRandomCompanyName() as GetRandomCompanyName

SELECT
	dbo.GetRandomWords(3) as GetRandomWords,
	dbo.GetRandomCity() as GetRandomCity,
	dbo.GetRandomStreetSuffix() as GetRandomStreetSuffix,
	dbo.GetRandomWord() as GetRandomWord,
	dbo.GetRandomStreetName() as GetRandomStreetName,
	dbo.GetRandomNumberStringLengthBetween(3, 5) as GetRandomNumberStringLengthBetween

SELECT
	dbo.FlipCoin() as FlipCoin,
	dbo.GetRandomDomainSuffix() as GetRandomDomainSuffix,
	dbo.GetRandomStateName() as GetRandomStateName,
	dbo.GetRandomEmailAddress() as GetRandomEmailAddress,
	dbo.GetRandomNumber(10, 20) as GetRandomNumber,
	dbo.GetRandomCounty() as GetRandomCounty
GO


Results:
Data Randomizer Results.png

Recent Releases:
 1.0.0.0  

Tags:
 C-Sharp    CLR    Data    Database    SQL Server  

Josh Patterson @ 5/9/2016
  Sweet titty juices!  
First Previous 1 Next Last 

Login or signup to leave a comment.
 
Copyright © 2017 NetworkDLS.
All rights reserved.
 
Privacy Policy | Our Company | Contact