Difference between inline query and stored procedure?

Answer Posted / jas

Select statement which is part of form clause of any
another statement is called as inline query.
Cannot take parameters.
Not a database object

Procedure:
Can take paramters
Database object
can be used globally if same action needs to be performed.

Is This Answer Correct ?    27 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is view? : Sql dba

726


What is a crud api?

675


What is partition in sql query?

707


How do you declare a variable in pl sql?

744


How do I run a sql query?

729






what are numeric data types? : Sql dba

752


What is $$ in sql?

725


What are the ddl commands?

710


What is the max nvarchar size?

676


What is dba in sql? : SQL DBA

734


What is the difference between a primary key and a clustered index?

692


which types of join is used in sql widely? : Sql dba

705


What is a primary key? Explain

732


How do I view tables in mysql?

718


What are all types of user defined functions?

733