Select statement which is part of form clause of any another statement is

Difference between inline query and stored procedure?

Question Posted / jas

4 Answers
29209 Views
Bharat, Microsoft, I also Faced
E-Mail Answers

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

Can a table contain multiple primary key’s?

1041

Explain the commit statement.

1102

What are its different types of dbms?

955

How do I remove sql plus from windows 10?

1023

what is not null constraint? : Sql dba

964

What is sqlservr exe?

941

What is sql character function?

994

explain the difference between myisam static and myisam dynamic. : Sql dba

885

what does the t-sql command ident_incr does? : Transact sql

1010

What is example of database?

985

What is the advantage of index in sql?

915

What is a call statement? Explain with an example.

951

Why do we use view in sql?

909

What is sqlerrd?

921

Is not equal in sql?

958