Stored Procedures in SQL Server
Not what you're looking for?
Stored procedures in SQL 2008 can be written in a variety of languages.
• Why do you think that it would be important to have the flexibility of using a variety of languages in the development of database systems?
• How would you use a stored procedure?
• Provide an example of a stored procedure that you might write to demonstrate why this capability is important.
• Would you ever want to use a temporary stored procedure? Why or why not?
• What are some differences in coding when creating a stored procedure in SQL Server vs. Oracle?
The responses to these questions can be in short paragraphs as it is for a discussion board. Please provide references in APA style if needed. Let me know if you have any questions.
Purchase this Solution
Solution Summary
Why do you think that it would be important to have the flexibility of using a variety of languages in the development of database systems?
How would you use a stored procedure?
Provide an example of a stored procedure that you might write to demonstrate why this capability is important.
Would you ever want to use a temporary stored procedure? Why or why not?
What are some differences in coding when creating a stored procedure in SQL Server vs. Oracle?
Solution Preview
The flexibility of using a variety of languages is important because some languages are better at certain tasks than others. Some languages may be better than others at list processing, some better at controlling hardware, some better at accessing databases or the web, some better at object-oriented programming, etc. Having the flexibility of choosing from different languages allows us to use the language that is most suited to the task at hand.
Stored procedures play an important role in the software design concept of code reuse. If there is a certain process that needs to be done repeatedly with information in the database, using a stored procedure is the way to go. Stored procedures are also used if more advanced processing in general needs to be done with database information. Although database ...
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.