Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Generation Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 8:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 3:01 AM
Points: 14, Visits: 56
Hi,
I've been away from SQL Server since 2002, and as a means of getting back into it, have been updating some sql generation code I wrote back on SS 6.5/7/2000 called SSCodeGen to work on SS 2008/2005. Its pretty basic stuff, and I realize SS Management Studio can now generate scripts, but if anyone would give it a try, and let me know what they think, suggest improvements (new standards of sql coding I am not yet aware of for example), I would be grateful. Its got a (very) basic VB front end to it, it doesn't need installing, just downloading to your pc. It's virus free (according to avast, and microsoft security essentials), and the pc had a deep scan before I created the .exe. Its at www.RaisinTech.com/SSCodeGen.exe. The old version for SS 7/200 can be found at http://users.quista.net/thealey/index.htm, and this old website will give you some idea of the what to expect. The new version only does the SQL scripting for the moment.
Post #892846
Posted Tuesday, March 30, 2010 9:45 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 448, Visits: 3,338
I like Apex SQL Code for SQL code generation. Codesmith is also very popular.

www.apexsql.com/sql_tools_code.asp
www.codesmithtools.com


David
Post #892962
Posted Thursday, April 1, 2010 7:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 3:01 AM
Points: 14, Visits: 56
Hi,
The creation of execute statements for stored procedures has been added, still at www.RaisinTech.com/SSCodeGen.exe.
Post #894746
Posted Saturday, April 10, 2010 9:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 3:01 AM
Points: 14, Visits: 56
Hi,
So the new version (8.3) is now up at www.RaisinTech.com/SSCodeGen.exe, which will
- Generate the 4 standard (A/I/U/D) stored procedures for a table (text/image field not currently handled)
- Generate the execute statements for a stored procedure (slightly more complete than that generated from SS Man Studio)
- Generate the sql for S/I/U/D statements for one or 2 tables on the database.
Its still in the early stages of development, but might be useful.
It doesn't require installation, you can just download and run.
I would really appreciate any comments/feedback.
Post #901179
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse