March 30, 2010 at 8:37 am
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 http://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.
March 30, 2010 at 9:45 am
I like Apex SQL Code for SQL code generation. Codesmith is also very popular.
April 1, 2010 at 7:32 am
Hi,
The creation of execute statements for stored procedures has been added, still at http://www.RaisinTech.com/SSCodeGen.exe.
April 10, 2010 at 9:46 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply