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

Database

 
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 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 5:54
perlmunger4-Nov-03 5:54 
I see what you are saying. What I am doing is opening a .sql file that I created using the "Generate SQL Script" command from Enterprise Manager. I script all of it to a single file and then read the entire contents into a string in my application. I am then setting the command text of my sql command to that string and running ExecuteNonQuery. How would I separate the create view calls out? Is there any way other than actually parsing the script or puting each create view into its own file?

Thanks.

-Matt

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

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
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 
GeneralRe: IDbCommand.CommandTimeOut Pin
yyf30-Oct-03 9:07
yyf30-Oct-03 9:07 

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.