Difference between inline query and stored procedure?

Question Posted / geethu

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

Answers were Sorted based on User's Feedback

Difference between inline query and stored procedure?..

Answer / 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

Difference between inline query and stored procedure?..

Answer / sharad prakash singhania

Procedure resides in the database in the executable format
whereas in case of inline query, SQL always take a step to
compile the query and then execute it. So In this respect
Procedure takes less time to execute whereas query take more
time to execute.

Is This Answer Correct ?

18 Yes

5 No

Difference between inline query and stored procedure?..

Answer / inam abbas

1) stored procedure comes with some major characterstics, as it consists in pre compiled format so the performance increase during dataaccess. incase of simple query it requires to complie again and again as per user request, but here its not required due to precompile format (*compile requires only ones).

2)next it reduce the network traffice so impacts less burden on server and u can integrate it with different front-end applications (e.g. vb.bnet,c#,java etc) inorder to data access.

3)come to next, due to precompile code resides in database server it provides more security and due to complicated queries can be integrated with one form it is portable also.

Is This Answer Correct ?

5 Yes

1 No

Difference between inline query and stored procedure?..

Answer / sudama maharana

1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.

2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.

3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.

4. In stored procedure, we can pass parameters . But in inline query we can't pass.

Thanks

Is This Answer Correct ?

2 Yes

0 No

Post New Answer