Red Gate forums :: View topic - Custom SQL Statement Generator

Go to product support center

SQL Data Generator 1 forum

Custom SQL Statement Generator

Search in SQL Data Generator 1 forum

Jump to:

Author

Message

CraigOttley

Joined: 15 Jul 2010
Posts: 13
Location: Newport Pagnell

Posted: Fri Dec 17, 2010 12:05 pm Post subject: 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!

Code:

<generators>
<generator type="RedGate.SQLDataGenerator.Generators.SQL.SQLColumnGenerator"
   name="Male First Names"
   description="Adam, Brian, Chris etc..."
   category="Data Dictionary">
   <property name="ServerName">MSSQLSERVER</property>
   <property name="DatabaseName">AdventureWorks</property>
   <property name="SQLQuery">SELECT FirstName AS [Male First Names]
FROM Person.Contact
WHERE Title = 'Mr.'
GROUP BY FirstName</property>
   <property name="LoopQuery">True</property>
   <matches field="Forename*" score="80"/>
   <type type="string"/>
</generator>
</generators>

Display posts from previous:

	All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum