Answer Posted / pavan pareta

1) functions are used for computations where as procedures
can be used for performing business logic
2) functions MUST return a value, procedures need not be.
3) you can have DML(insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL
query..eg: suppose, if u have a function that is updating a
table.. you can't call that function in any sql query.-
select myFunction(field) from sometable; will throw error.
4) function parameters are always IN, no OUT is possible

Explain sql delete command?

1002

---

Explain what is lock escalation and what is its purpose?

873

---

Tell me what is use of except clause? How it differs from not in clause?

898

---

What is tcl in sql server?

1075

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1921

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

985

---

Where can you find the error log information? : sql server database administration

970

---

How many joins in sql server?

898

---

What is the function of inner join?

1004

---

on line cluster can we make if yes tell me the procedure

1975

---

Explain throw statement in sql server 2008?

930

---

How to enter comments in transact-sql statements?

892

---

Explain what are page splits? : SQL Server Architecture

1002

---

What are the different types of backups avaialabe in sql server 2005?

969

---

What is the maximum length of an alert name?

958

---