Activity overview
Latest activity by CraigOttley
UK Telephone Numbers Generator
Hi! I was asked to generate some telephone numbers. Some of the numbers got picked and were dialled successfully!! So after doing some research I came across Ofcom's site which listed numbers which...
Thanks Linda.
For everyone else this code works for me [image] ) <generators>
<generator type="RedGate.SQLDataGenerator.Generators.List.WeightedListGenerator"
name="Yes|No"
description="95 | 5%..."
category="Weighted Lists">
<property name="Seed">0</property>
<property name="NullsAllowed">False</property>
<property name="NullProportion">0.01</property>
<property name="ListItems">
<WeightedListOfItems type="WeightedListOfItems" version="1">
<value version="1" type="WeightedListItem">
<Name>Yes</Name>
<Weight>95</Weight>
</value>
<value version="1" type="WeightedListItem">
<Name>No</Name>
<Weight>5</Weight>
</value>
</WeightedListOfItems>
</property>
<matches field="*Option*" score="70"/>
<type type="Object"/>
<type sqlType="Char"/>
<type sqlType="Varchar"/>
<type sqlType="NChar"/>
<type sqlType="NVarchar"/>
<type sqlType="NText"/>
</generator>
</generators>
/ comments
Thanks Linda.
For everyone else this code works for me )<generators>
<generator type="RedGate.SQLDataGenerator.Generators.List.WeightedListGenerator"
name="Yes|No"
...
Hi Rockinder,
I've had this problem in the past, If I remember rightly there's no easy way of doing this through SQL Data Generator.
One thing you could try is using the FOR XML clause from flat tables. I think you have to have certain options set on the table and database level for this to work.
This work for me on Adventure works using the Person.Contact table and the AdditionalContactInfo column... (Takes a few seconds for the screen to refresh) SELECT TOP 1
NameStyle ,
Title ,
FirstName ,
MiddleName ,
LastName ,
Suffix ,
EmailAddress ,
EmailPromotion ,
Phone ,
PasswordHash ,
PasswordSalt
FROM Person.Contact
ORDER BY NEWID()
FOR XML PATH('Contact') ,
ROOT('Person')
Make sure you have Loop until number... Ticked.
HTH / comments
Hi Rockinder,
I've had this problem in the past, If I remember rightly there's no easy way of doing this through SQL Data Generator.
One thing you could try is using the FOR XML clause from flat ta...
Have you had a look at Ben Halls post about embedding IronRuby or another language? http://www.simple-talk.com/content/article.aspx?article=697 / comments
Have you had a look at Ben Halls post about embedding IronRuby or another language?http://www.simple-talk.com/content/article.aspx?article=697
Custom SQL Statement Generator
Hope this helps anyone who uses the Generic SQL Statement a lot. It's saving me huge amounts of time when most things are stored in a Database!<generators>
<generator type="RedGate.SQLDat...
Weighted List Custom Generator
Hi!
Has anyone every happened to create a Custom Generator for a weighted list?
I'm struggling to find the right properties I need to set.
So far i've got the following...<generators>
<ge...
Why couldn't you use a Regular Expression?
IE
99(8|9) \d{3} \d{4} / comments
Why couldn't you use a Regular Expression?
IE
99(8|9) \d{3} \d{4}
I've come up with a work around for this. I've created a user for SQL Doc and revoked all privileges except for Tables and Views [image] . SQL Doc can't generate documentation for what is hasn't got access to.
Simple Example USE master
GO
GRANT VIEW ANY DEFINITION TO SQLDoc
GO
REVOKE VIEW ANY DEFINITION FROM SQLDoc
GO
[/code] / comments
I've come up with a work around for this. I've created a user for SQL Doc and revoked all privileges except for Tables and Views . SQL Doc can't generate documentation for what is hasn't got acce...
New procedures getting generated when not required (cmdline)
Hi!
I like the fact that new tables, views etc get picked up when generating the documentation via command line. How ever some areas of our Documentation are getting generated when we don't need th...
Command Line to Change the Output Path (HtmlPath etc)
Hi!
Does anyone know of a way to specify the output path in command line?
Currently we have to open the sqldoc project (as XML) and change the HtmlPath. Because of security restrictions we can't wr...