What is difference between commit and rollback when used in transactions?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to add an address record into adventureworkslt?

0 Answers  


Does partitioning improve performance sql server?

0 Answers  


write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,


How to get @@error and @@rowcount at the same time?

0 Answers  


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,






what type of indexes physically sort data?

3 Answers  


Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  


What is a NOLOCK?

3 Answers   NA,


How do you manipulate data?

0 Answers  


write the query for taking database restore in sql?

2 Answers  


I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  


Categories