Answer / vijayalakshmi

declare @trans2 varchar(10)='transaction2' 
 begin transaction @trans2 
 insert into emp values(100,'xy',600); 
 save transaction @trans2 
 insert into emp values(200,'pq',700); 
 insert into emp values(300,'pq',800); 
 save transaction @trans2 
 commit transaction @trans2 
 rollback tran @trans2

What is difference between order by and group by?

0 Answers  

---

what is raid? : Sql server database administration

0 Answers  

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

How raid can influence database performance?

0 Answers  

---

what is the primary use of the model database? : Sql server administration

0 Answers  

---

what is a deadlock? : Sql server database administration

0 Answers  

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---