Answer Posted / Durgesh Joshi
Stored procedures are used in SQL Server for several reasons, including: improved performance through reusable code and query optimization, enforcing data integrity through parameter validation and transaction handling, encapsulating complex logic, and securing sensitive data by limiting direct access to tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where can you add custom error messages to sql server?
How can we solve concurrency problems?
What is standby servers? Explain types of standby servers.
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the properties of the transaction?
What is the difference between for xml raw and for xml auto?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Can we do dml on views?
List out the different types of locks available in sql server?
What are wait types?
Explain system functions or built-in functions? What are different types of system functions?
Can one drop a column from a table?
Is it possible to have clustered index on separate drive from original table location?
How can I check that whether automatic statistic update is enabled or not?
How to connect php with different port numbers?
