Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Difference between inline query and stored procedure?

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

More SQL PLSQL Interview Questions

Is clustered index a primary key?

0 Answers  


What is blind sql injection?

0 Answers  


Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  


what are different types of collation sensitivity? : Sql dba

0 Answers  


What is the meaning of disabling a trigger?

0 Answers  


What is the most restrictive isolation level? : Transact sql

0 Answers  


How do you delete a table?

0 Answers  


what is not null constraint? : Sql dba

0 Answers  


What do you mean by rowid?

0 Answers  


Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,


What is trigger in sql? Explain

0 Answers  


Is merge a dml statement?

0 Answers  


Categories