Why I have to use stored procedures?



Why I have to use stored procedures?..

Answer / S Nuzhat Husain

Stored procedures are pre-compiled collections of SQL statements that can be reused multiple times. They offer several benefits: enhanced security, improved performance, code reusability, and modularization.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

 Explain what is sql override for a source taLle in a mapping?

1 Answers   Informatica,


What is indexing and its types?

1 Answers  


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1 Answers  


What is a view in sql?

0 Answers  


What are Row versions of DataRow?

1 Answers  


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1 Answers  


What are the requirements for sql server 2016?

1 Answers  


What is a not null constraint?

1 Answers  


Explain trigger and trigger types?

1 Answers  


find the 3rd max salary

10 Answers  


What happens if you delete a table that is used by a view?

1 Answers  


What is replication with database mirroring? : sql server database administration

1 Answers  


Categories