1->stored procedure can not be written as a column name but function c

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

Question Posted / scorpio.mishra

5 Answers
13560 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / scorpio.mishra

1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are filegroups in sql server?

1098

What are the different types of data sources in ssrs?

201

How to delete an existing row with delete statements in ms sql server?

1148

How to run sql server 2005 books online on your local system?

999

Explain the usage of floor function in sql server.

1018

How many columns can exist together per table?

1205

What is Federation Root Database?

104

What is "scheduled jobs" or "scheduled tasks"?

1026

What is a mixed extent?

1078

What is default constraint?

1053

What is the difference between a unique key and primary key?

1002

What is the openxml statement in sql server?

1118

What is a primary key?

996

What is cross join in sql server joins?

1199

What protocol does sql server use?

986