Advantages and disadvantages of stored procedures.

Question Posted / narenukt

Answers were Sorted based on User's Feedback

Advantages and disadvantages of stored procedures...

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

More SQL Server Interview Questions

What the different components in replication and what is their use?

What is scheduled job and how to create it?

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

What is policy based management (pbm)? : sql server database administration

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

What is sqlservr.exe - process - sql server (sqlex?press)?

Explain subquery and state its properties?

Do you know what are pages and extents? : SQL Server Architecture

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

Data table as parameter in sql server?

Explain what are the authentication modes in sql server?

How to set a database state to offline in ms sql server?

For more SQL Server Interview Questions Click Here