Answer / sreejith s t

LIKE operator performs pattern matching

Answer / valarmathi

'like' operator

In what version of sql server were synonyms released?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What is sql injection and why is it a problem? : sql server security

0 Answers  

---

What are the types of normalization?

0 Answers  

---

---

Explain the dirty pages?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

When would you use it?

0 Answers  

---

Explain few examples of RDBMS?

0 Answers   Wipro,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

Explain comment on transactions?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---