Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

What is the size of transaction log file?

0 Answers  

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 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,

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

Explain the usage of floor function in sql server.

0 Answers  

---

Define self join?

0 Answers  

---

What is ACID Property of Transaction?

10 Answers  

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---