Are resultset updatable?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

What is the purpose of sql profiler in sql server?

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

What is a periodical index?

0 Answers  

---

How do you trace the traffic hitting a sql server?

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,

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---