How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

What is the difference between row_number and dense_rank?

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

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,

---

What are the purposes and advantages stored procedure?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

If the job running very slow what is the action you do

0 Answers  

---