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