List some advantages and disadvantages of stored procedure?

Question Posted / maheswari

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

More SQL Server Interview Questions

What happens if the update subquery returns no rows in ms sql server?

Can you link only other SQL Servers or any database servers such as Oracle?

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

What is a result set object returned by mssql_query()?

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

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

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

What are the advantages of partitioning?

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

Why we need sql server?

How to copy data from one table to another table?

Is the order of columns in the set clause important in ms sql server?

For more SQL Server Interview Questions Click Here