Why should one not prefix user stored procedures with ‘sp

Why should one not prefix user stored procedures with ‘sp_’?

Question Posted / rajiv ranjan

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

What is a functions and types in sql server?

What is ms sql server reporting services?

What is catalog views?

Can we insert data into view sql server?

When to use Inner join & when to use subquery?

Explain what you mean by 3 tier architecture.

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

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

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

What is set nocount on and what is set nocount off?

How can you insert values in multiple rows using one Insert statement?

For more SQL Server Interview Questions Click Here