Are stored procedures faster than dynamic sql?

0 Answers  

---

What is replication id?

0 Answers  

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

What is %s in sql?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

Why stored procedure is better than query?

0 Answers  

---

Explain locks? : Transact sql

0 Answers  

---

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---