What is the difference between seek predicate and predicate?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

How would you add a section to a table?

0 Answers  

---

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

Explain about temporary stored procedure?

0 Answers  

---

What is a not null constraint?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

How do I view a script in sql server?

0 Answers  

---

What is cursors?

0 Answers   NA,

---