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
what is view? : Sql dba
What is a crud api?
What is partition in sql query?
How do you declare a variable in pl sql?
How do I run a sql query?
what are numeric data types? : Sql dba
What is $$ in sql?
What are the ddl commands?
What is the max nvarchar size?
What is dba in sql? : SQL DBA
What is the difference between a primary key and a clustered index?
which types of join is used in sql widely? : Sql dba
What is a primary key? Explain
How do I view tables in mysql?
What are all types of user defined functions?