List some advantages and disadvantages of stored procedure?


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

Post New Answer

More SQL Server Interview Questions

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

0 Answers  


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

1 Answers  


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

2 Answers  


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

0 Answers  


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

3 Answers   Infosys,






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

0 Answers  


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

8 Answers  


What are the advantages of partitioning?

0 Answers  


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

0 Answers  


Why we need sql server?

0 Answers  


How to copy data from one table to another table?

0 Answers  


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

0 Answers  


Categories