What is the difference between index seek vs. Index scan?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

How to Get the last identity value used

4 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

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,

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

How to set database to be single_user in ms sql server?

0 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

How to create function without parameter in sql server?

0 Answers  

---