WelshyWizard
IS-IT--Management
Hi all,
I'm new tothe whole world of .NET and I'm guessing that what I want to do is fairly easy.... But I just don't know how to do it!
We're running SQL Server 2000 and I am trying to opena connection to a database.
The database is called FMTEST and it resides on SQL Server SQLSVR1.
I want to open a connection to the database and pass the following two commands of SQL script to it:
I'd really appreciate some help on this!
Cheers
Today is the tomorrow you worried about yesterday - and all is well.....
I'm new tothe whole world of .NET and I'm guessing that what I want to do is fairly easy.... But I just don't know how to do it!
We're running SQL Server 2000 and I am trying to opena connection to a database.
The database is called FMTEST and it resides on SQL Server SQLSVR1.
I want to open a connection to the database and pass the following two commands of SQL script to it:
Code:
UPDATE OPERATION SET RUN = (RUN/4)*3 WHERE RESOURCE_ID LIKE 'TI';
UPDATE OPERATION SET RUN_HRS = (RUN_HRS/4)*3 WHERE RESOURCE_ID LIKE 'TI';
I'd really appreciate some help on this!
Cheers
Today is the tomorrow you worried about yesterday - and all is well.....