Re: sql DML templatess
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/26/04
- Next message: David Portas: "Re: How to list all non-unique data items?"
- Previous message: Peter: "How to list all non-unique data items?"
- In reply to: Alon: "Re: sql DML templatess"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 26 Jun 2004 21:50:48 +0100
Hi
I would not work with the code generate within QA! I would use DMO to script
all code. This would be stored to your coding standards in a Source Code
Control System. All changes to the code would first take the source from the
Source Code Control system and once compiled, put back into the the Source
Code Control System. This way you can keep track of all changes made (and
why they were made). Using labels you can then re-create any version of your
schema at any time.
You may want to read Nigel's page:
http://www.nigelrivett.net/SQLServerReleaseControl.htm
To get your objects into a Source Code Control System this may be useful:
http://www.nigelrivett.net/DMOScriptAllDatabases.html
John
"Alon" <Alon@discussions.microsoft.com> wrote in message
news:4F0033EF-A089-4DAE-949A-0C4615173875@microsoft.com...
> Thanks John. These templates seems to affect only some of the generated
SQL statements. I want to change the statements that gen'ed when I right
mouse on a table in the object browser pane of Query Analyzer. I want to
align these templates with our project stndards. Any idea?
> Thanks,
> Alon
> --
> ABM
>
>
> "John Bell" wrote:
>
> > Hi
> >
> > Under Tools/Options you can see the template directory. This will
contain
> > ..tql files that can be changed.
> >
> > John
> > "Alon B" <Alon B@discussions.microsoft.com> wrote in message
> > news:DFFF1DA1-1885-4BAB-A619-FC9A0DAFA23A@microsoft.com...
> > > Where / Can I changes the templates that generates the insert/ select
etc
> > statements in the Query Alalyzer?
> > > I found the the templates for Data Definition Language ie created
> > statements.
> >
> >
> >
- Next message: David Portas: "Re: How to list all non-unique data items?"
- Previous message: Peter: "How to list all non-unique data items?"
- In reply to: Alon: "Re: sql DML templatess"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
