Subject | Stored Procedure (Array) |
---|---|
Author | Allies Xposs |
Post date | 2009-03-26T06:33:07Z |
for All DBA Master
I have a Basic case..
When From Client, Insert data ( "Insert Into MyTable1 Values ('432') "), and i try create stored procedure to make Array data :
myarr[1,1]:='432';
myarr[2,1]:='423';
myarr[3,1]:='324';
myarr[4,1]:='342';
myarr[5,1]:='234';
myarr[6,1]:='243';
and Insert that data to MYtableInfo:
" Insert into MYtableInfo values (That's Array) "
What The Best Performance :
1. I Am Call That Procedurefrom My Application ?
or
2. I am Call That Prcedure from Trigger ??
Thanks..
- Allies Xposs -
[Non-text portions of this message have been removed]
I have a Basic case..
When From Client, Insert data ( "Insert Into MyTable1 Values ('432') "), and i try create stored procedure to make Array data :
myarr[1,1]:='432';
myarr[2,1]:='423';
myarr[3,1]:='324';
myarr[4,1]:='342';
myarr[5,1]:='234';
myarr[6,1]:='243';
and Insert that data to MYtableInfo:
" Insert into MYtableInfo values (That's Array) "
What The Best Performance :
1. I Am Call That Procedurefrom My Application ?
or
2. I am Call That Prcedure from Trigger ??
Thanks..
- Allies Xposs -
[Non-text portions of this message have been removed]