Advantages and disadvantages of stored procedures.

Answers were Sorted based on User's Feedback



Advantages and disadvantages of stored procedures...

Answer / manoj

The only disadvantage I see with Stored-procs is that we
cannot use them with select statements.

Is This Answer Correct ?    9 Yes 8 No

Advantages and disadvantages of stored procedures...

Answer / suresh

yes

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,


What is blocking and how would you troubleshoot it?

2 Answers  


What is a trigger?

7 Answers  


How do you rename a table in sql server?

0 Answers  


How to Get the last identity value used

4 Answers  






About DTS usage ?

2 Answers   Cognizant, Wipro,


What are the differences between user defined functions and stored procedures?

0 Answers  


is there a column to which a default can't be bound? : Sql server database administration

0 Answers  


Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  


What are logical database components? : SQL Server Architecture

0 Answers  


What is database dimension? : sql server analysis services, ssas

0 Answers  


What is the purpose of the tempdb database?

0 Answers  


Categories