ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Can you have a nested transaction?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Can you have a nested transaction?
Answer
# 1		 
Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK, 
SAVE TRAN and @@TRANCOUNT.
 
Is This Answer Correct ?    1 Yes 0 No
Swapna
 
  Re: Can you have a nested transaction?
Answer
# 2		 
Yes,
  Begin transaction t1
    update <Table_Name> set <col1>=<col1>+50
  Begin Transaction t2
    delete from <Table_Name> set <col1>=<col1>+100
  commit Transaction t2
 end transaction t1
 
Is This Answer Correct ?    1 Yes 0 No
Brahma
 
 
 
  Re: Can you have a nested transaction?
Answer
# 3		 
yes, we can have nested transactions. to know the nest 
level use @@trancount
 
Is This Answer Correct ?    1 Yes 0 No
Visala
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Explain the architecture of SQL Server?  2
If there is failure during updation of certain rows, what will be the state?  1
Which is best Subquery (or) joins in sql server? explain why  2
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required  2
Can you explain the types of Joins that we can have with Sql Server?  2
What is the use of placing primary key and foreign key constrains on columns. Value-Labs2
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM Wipro4
please tell me the query to get details of the employee having the second largest salary 247Customer8
What is difference beteen Migration and Upgrdation? Satyam4
what are the problems in logshipping?  2
What is Peer to peer Replication? HCL1
Can some one please help with a query which will take only max value of a column in a join.  2
select empid empname from employee What is the result for the about query?  4
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  7
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony21
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ? Wipro4
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee4
Explain the basic concepts of SQL server architecture?  2
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.  7
what are file groups? Evalueserve3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com