[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

Consider 2 tables T1 with one field name field1 (int)as...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

Question by Smitha Varkey
Submitted on 12/19/2006
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating: Not yet rated Rate this question: Vote
Consider 2 tables T1 with one field name field1 (int)as primary key and second table T2 with one field field2 (int ) with no primary key

and let  lable T1 contains the following data
T1
field1
1
2
3
4
and let T2 contains no data
let assume there exist a procedure that insert values into tables T1 and then to lable T2

if we execute this procedure by passing arguments '2' and '10'

let 2 for table T1 and 10 for T2

My question is

1:whether the procedure gets rollbacked due to table T1

or

2:whether 10 will get inserted into T2 and 2 will not get inserted into T1

or

3:whether 10 will not get inserted into T2 and 2 will not get inserted into T1




Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.