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 happens if you insert a duplicate key for the primary key column in ms sql server?

How to create a login account in ms sql server to access the database engine using "create login" statements?

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

What are the properties of primary key?

Where are sql server usernames and passwords stored in the sql server?

How to write a query with a left outer join in ms sql server?

What is use of @@ spid in sql server?

What will you do If the low Performance occurs?

What are the types of user defined functions in sql server?

How to transfer Logins from SQL Server 2000 to 2005

How to automatically create a log when an exception is being received into SQL Server?

What are the differences between stored procedure and functions in SQL Server 2000?

For more SQL Server Interview Questions Click Here