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 is dimension table? : sql server analysis services, ssas

0 Answers  


What is local temp table?

0 Answers  


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  


Define normalisation?

0 Answers  


How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,






What are the benefits of normalization?

0 Answers  


I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  


About Indexed Views? with example? plz reply...

2 Answers  


What is the definition for sql server 2000?

0 Answers  


Explain about Joins?

0 Answers   Infosys,


Categories