Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveni
Hi
"triveni504@.gmail.com" wrote:

> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that from
your code. This will reduce the amount of network traffic and will also allow
you to implement some error handling.
John

Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveniHi
"triveni504@.gmail.com" wrote:
> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that from
your code. This will reduce the amount of network traffic and will also allow
you to implement some error handling.
John

Running SQL Scripts from VB

HI All,
I think I am posting this to the right group , If not Please Ignore .
Does anyone know how to run a Sql script from a VB Program . My
requirement is something like this : From my VB Code , I need to
execute a sql script which will internally create a Temporary Stored
Procedure . This Stored Procedure has one column that gets filled up
with the further processing of the sql script . Later on I need to
select all the rows from this proc ( if any ) .
Kindly , Post reply if solution is known to anyone of you .
Thanks In advance ,
triveniHi
"triveni504@.gmail.com" wrote:

> HI All,
> I think I am posting this to the right group , If not Please Ignore .
> Does anyone know how to run a Sql script from a VB Program . My
> requirement is something like this : From my VB Code , I need to
> execute a sql script which will internally create a Temporary Stored
> Procedure . This Stored Procedure has one column that gets filled up
> with the further processing of the sql script . Later on I need to
> select all the rows from this proc ( if any ) .
> Kindly , Post reply if solution is known to anyone of you .
> Thanks In advance ,
> triveni
>
You can look at the ADO examples that come with SQL Server see
http://msdn2.microsoft.com/en-us/library/aa173708(SQL.80).aspx regarding
where they can be found.
Your terminology does not seem correct I assume that you want to create a
temporary table. If there is a large number of statements in your script you
may want to encapsulate this in a stored procedure and just execute that fro
m
your code. This will reduce the amount of network traffic and will also allo
w
you to implement some error handling.
John