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

How to drop existing views from a database in ms sql server?

1052

How to add code to the existing article (using improve article)?

1066

What is a database in ms sql server?

1007

How can I create a new template for import ? : sql server management studio

1041

What is normalization and its types?

976

How do I find query history in sql server?

893

what is raid and what are different types of raid configurations? : Sql server database administration

986

Does sql server use java?

1014

Explain how you can deploy an SSRS report?

139

What is the minimum recommended amount of ram for sql server 2012 enterprise?

901

What do you understand by a view?

947

Write SQL queries on Self Join and Inner Join.

1086

What is etl - extraction, transformation, and loading?

868

Why use sub query in sql server and list out types of sub queries?

949

What is tablesample?

1043