Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

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,

---

What are cursors and when they are useful?

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

Can XML be used to access data?

2 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

What is a deadlock and what is a live lock?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

When would you use sql joins?

0 Answers  

---

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

---

What is the contrast amongst drop and truncate?

0 Answers  

---