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


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

Post New Answer

More SQL Server Interview Questions

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  


What is the difference between functions and stored procedures?

0 Answers   Accenture,


What is 2nf in normalization?

0 Answers  


What is the difference between sdf and mdf?

0 Answers  


difference between Clustered index and non clustered index ?

0 Answers   Infosys,






What is a view?

6 Answers  


How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


What is self contained multi valued query?

0 Answers  


What are the options which must be set to allow the usage of optimistic models?

0 Answers  


How to delete a database in ms sql server?

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


What is a constant or literal in ms sql server?

0 Answers  


Categories