News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Advertisement

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;
Begin Transaction
      Create table A ( x smallint, y smallint)
      Create table B ( p smallint, q smallint)

        Update A set x=600 where y > 700
        Update B set p=78 where q=99

          If @@ error != 0
          Begin
          RollBack Transaction
            Return 
          End

     Commit Transaction

Select the correct option:

  1. The transaction will work perfectly fine

  2. It will report an error

  3. The error handling routine contains a syntax error

  4. None of the above

  5. Both b and c

Answer: Answer is b
Further Reading:

It will report an error, because there is a space between @@ and error.

comments powered by Disqus
Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;