 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Srdjan Šurlan
Guest
|
 Posted: Fri Dec 19, 2003 12:47 pm Post subject: MSSQL transaction |
 |
|
question about transactions
I wrote SQL transaction, a big one because of large amount of data
(data between two tables must be moved into third table)
and, I want to execute it from my application which
was written in Delphi 6
Is there some other method do execute tran. insted of
loadnig contents of transtaction from .txt file
Is there some method to execute it on SQL server
and how
where do I have to put tran. to do that
thanx everyone for few helpfull word
Srdjan
|
|
| Back to top |
|
 |
Tony J Hopkinson
Guest
|
| Posted: Fri Dec 19, 2003 6:51 pm Post subject: Re: MSSQL transaction |
|
|
On Fri, 19 Dec 2003 13:47:27 +0100, Srdjan Šurlan <priki_ns (AT) yahoo (DOT) com>
wrote:
| Quote: | question about transactions
I wrote SQL transaction, a big one because of large amount of data
(data between two tables must be moved into third table)
and, I want to execute it from my application which
was written in Delphi 6
Is there some other method do execute tran. insted of
loadnig contents of transtaction from .txt file
Is there some method to execute it on SQL server
and how
where do I have to put tran. to do that
thanx everyone for few helpfull word
Srdjan
|
Create a stored procedure in the server. Pop you sql statements
inside, shazam hey presto etc. Give the user your program logs in as
the execute privilge for it.
The from delphi you can execute it with one of the storedproc
components or even with a query component.
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
