Advantages and disadvantages of stored procedures.
Answer Posted / 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 |
Post New Answer View All Answers
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How to search for a string in all stored procedure in sql server?
How can we delete a table in sql server?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are the different types of triggers in SQL SERVER?
Introduction of rollup clause using sum and group by clause?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Define indexes?
What is service broker?
What is sharding?
What are the dmvs?
Determine when an index is appropriate?
What is in place upgrade in sql server?
How do I start sql server 2016?
How to replace null values in expressions using isnull()?