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

Database

 
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 
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 
Well, part of the problem is that I don't know what you mean by "running a script". I mean, are you using osql or something? If not, you will probably have to separate each one of the CREATE statements, etc. into a separate call; each one has to be in a separate "batch". In some contexts, you separate batches with GO; in others, you just execute them separately. Are you just executing the .sql file using a shell command or something? Try separating each CREATE statement into a separate file-- what happens?

Thank you.

Jeff Varszegi
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 
GeneralRe: date Pin
andyharman3-Nov-03 12:26
professionalandyharman3-Nov-03 12:26 
GeneralIDbCommand.CommandTimeOut Pin
yyf30-Oct-03 5:21
yyf30-Oct-03 5:21 
GeneralRe: IDbCommand.CommandTimeOut Pin
Mike Dimmick30-Oct-03 5:59
Mike Dimmick30-Oct-03 5:59 

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.