Re: view script
If you are going to run from Query Analyzer, you need a GO between each one. This makes each its own batch.
Originally posted by lula123
I know this may be simple but how do I create a script that creates multiple views. It doesn't like it if I put multiple create statements in one script.
ie. Create view A as select * from table a ;
Create view B as select * from table b
If from a procedure or script, you need to wrap each in:
etc, etc, etc
When life gives you a lemon, fire the DBA.