We cannot write DML in Function whereas in SPs we can

What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.

Question Posted / pratap557

Answer Posted / pratap557

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What area unit the various kinds of info compression introduced in sql server 2008?

1071

Explain the working of sql privileges?

1085

What is the difference between stored procedure and functions?

1122

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

972

List out the different types of locks available in sql server?

974

When I run the sql server 2000 setup, it just hangs. What do I do?

1075

Where is localdb stored?

933

What is the fillfactor concept in indexes?

974

what protocol both networks use? : Sql server database administration

967

What is indexing a document?

1030

How will you add a dimension to cube? : sql server analysis services, ssas

1077

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

975

what is create database syntax? : Sql server database administration

1100

What is the rdl file?

138

How to use copy and concatenate commands in SQL?

1138