Does sql server 2000 full-text search support clustering?

0 Answers  

---

What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---

What is serializable?

0 Answers  

---

Explain the functionalities that views support?

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

What is conditional split?

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,

---

What is the sql server agent?

0 Answers  

---