Answer Posted / ramya gurrala

Functions:1)Do calculations mostly.
2)Must return value.
3)Calling methods.
4)Function can stand alone.


Procedure:1)Do actions mostly.
2)May or may not return value(the return method is not same as function method).
3)Calling methods.
4)Procedure can not stand alone.

What are the different Topologies in which Replication can be configured?

1183

---

what stored procedure can you use to display the current processes? : Sql server administration

1010

---

Explain intellisense for query editing

1029

---

Can a synonym name of a table be used instead of a table name in a select statement?

1032

---

What is a coalesce function?

1194

---

What is the maximum size of sql server database?

1009

---

What is analysis service repository?

1023

---

What is default constraint?

995

---

What is efficiency data?

950

---

What is compound operators?

1058

---

How to access the inserted record of an event?

1049

---

When cursors are useful?

1104

---

Explain linked server in sql?

1220

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

---

How you can get a list of all the table constraints in a database?

956

---