Click here to Skip to main content
15,847,902 members
Home / Discussions / Database
   

Database

 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
I have created a deployment application that has the user provide db credentials. It then creates the database and then runs a .sql script to create all of the db objects. The script runs fine in Query Analyzer, but won't work in my deployment project. I get the following error message:

'CREATE VIEW' must be the first statement in a query batch.
'CREATE VIEW' must be the first statement in a query batch.
'CREATE VIEW' must be the first statement in a query batch.
'CREATE VIEW' must be the first statement in a query batch.
'CREATE VIEW' must be the first statement in a query batch.

What does this mean and why do I only get it in my deployment app and not in query analyzer?

Thanks.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:58
perlmunger4-Nov-03 4:58 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:03
professionalJeff Varszegi4-Nov-03 5:03 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 6:38
professionalJeff Varszegi4-Nov-03 6:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 7:55
perlmunger4-Nov-03 7:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 7:56
Colin Angus Mackay3-Nov-03 7:56 
GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 6:10
L Thomas3-Nov-03 6:10 
Generalsql tables Pin
ranjjj31-Oct-03 4:14
ranjjj31-Oct-03 4:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 4:18
ranjjj31-Oct-03 4:18 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 23:15
Vaibhav Sanghavi30-Oct-03 23:15 
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 3:54
Rahul Walavalkar3-Nov-03 3:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 4:10
Vaibhav Sanghavi3-Nov-03 4:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 10:27
yyf30-Oct-03 10:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 9:06
yyf30-Oct-03 9:06 
Generalsimple sample of ADO + Access + VC++ Pin
slomoman30-Oct-03 8:12
slomoman30-Oct-03 8:12 
Generaldate Pin
Anonymous30-Oct-03 7:30
Anonymous30-Oct-03 7:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.