Answer Posted / arvind kumar

1-Function can not return the value but store procedure
return value
2-Store procedure is pree-compile statement but function is
not pree-compile satement.
3 function fallowed by select statement but store procedure
fallowed select, insert,update statement.

What is a with(nolock)?

978

---

What are user-defined functions (udfs) in sql server?

978

---

How to use the inserted and deleted pseudo tables?

951

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

962

---

How to create a new login name in ms sql server?

1050

---

How can you find out which stored procedures are recompiling?

914

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

998

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1010

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1032

---

Explain the difference between clustered and non-clustered index?

916

---

How can delete duplicate records in cte in sql server?

959

---

How many types of functions are there in sql server?

927

---

Why use “nolock” in sql server?

1046

---

Explain primary key?

951

---

what is spatial nonclustered index

981

---