1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Advantages and disadvantages of stored procedures.

Question Posted / narenukt

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 normalization and its forms?

4 Answers   Challenger Financial,

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

Explain what is the difference between union and union all?

0 Answers  

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,




What are the types of subquery?

0 Answers  

Can you pass expressions to function parameters?

0 Answers  

What is RMS migrations?

0 Answers   Satyam,

Create and insert into temp table in sql server?

0 Answers  

What is data file in computer?

0 Answers  

Explain left outer join and right outer join?

0 Answers  

How do I find the port number for sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories