Explore BrainMass
Share

Explore BrainMass

    Stored Procedures in SQL Server

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 8:10 am ad1c9bdddf
    https://brainmass.com/computer-science/databases/stored-procedures-sql-server-611921

    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 ...

    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?

    $2.19