Hello we are using adventure works 2014 sample database and Im confused on this

Question

Hello we are using adventure works 2014 sample database and Im confused on this question . Have a little code so far but stuck

Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions.

Your manager has asked you to create a stored procedure for an application the business is developing. For the application, management has requested that when a "City" is selected, it returns with the corresponding region. By integrating code, the business will be able to return results quickly for users. Use the Address, StateProvince, and SalesTerritory tables and name the procedure "GetRegion." TIP: Use GO.

Explain why a stored procedure (SPROC) is a good way to address database security. Include specific examples to illustrate your main ideas.

Explanation / Answer

2. Stored procedueres are so popular and used widely.It has maintainability.Taking about this feauther maintainability.Because we know that the scripts are in one location.Tracking of depeendencies and updates will be based on schema and changes becomes easier.It can be tested independent of the application

Had a Isolation of business rules.Without having run the application these stored procedures are are easily cached on the server and Execution plans for the process are easily reviewble.There is a utilization of set based processing. and has security

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.