Answer Posted / vijayabhaskarreddy

there are 3 main differences between sp and function.
1 sp takes input,output parameters, function takes only
input parameters.
2 temparary variables required to store return values of
sp. in functions temparary variables will be optinale.
3 sp can not be called directly into DML statements ,
functions can be called directly into DML statements.

how you can get the list of largest tables in a database? : Sql server administration

1053

---

Can we call future method from queueable?

1051

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1044

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1058

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1958

---

How to provide values to stored procedure parameters in ms sql server?

1037

---

How do you implement session management in SQL Server mode?

1107

---

Can sql servers linked to other servers like oracle?

953

---

What happens if null values are involved in string operations?

992

---

When to use Inner join & when to use subquery?

1164

---

What are the steps you will take to improve the performance of a poor performing query?

979

---

What is an index in sql?

1006

---

what are candidate key, alternate key and composite key? : Sql server database administration

917

---

What is the current limitation of the size of SQL Azure DB?

127

---

After removing a table from database, what other related objects have to be dropped explicitly?

1055

---