November 21, 2003 at 9:09 am
Me too, actually. The first change I would make the the script I posted would be to make it take a parameter for the alias I wanted to use.
Incidentally, I've use a very similar script to generate code for C#, VB, etc...
Matthew Galbraith
November 21, 2003 at 9:22 am
K. Wasn't sure how wierd i was being. As for your script, it's right on imo. I've had code generator scripts save me a ton of time on two projects in the past. I'm convinced they are useful in more than just theory.
November 21, 2003 at 9:27 am
I think that once you know how a language works and have a good understanding of it, then there's absolutely no reason in the world you should be typing everything out, unless it's short enough that it would take more time to execute/copy/paste/modify your script. I've done things from writing simple code generators, dynamic sql sps that use tables to get parameters, to abusing Excel and UltraEdit to write scripts. I'm paid for my brain, not my fingers. 😉
Matthew Galbraith
November 21, 2003 at 9:35 am
Hehe - that was very well said.
November 24, 2003 at 1:34 am
to that end, take a look at SSCodeGen, available on this site at http://qa.sqlservercentral.com/products/SSCodeGen/
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply