Sql Write Sql Script Create 4 Stored Procedures Schools Table Football Database Well View Q37077126

by

SQL

Write a SQL script to create 4 stored procedures for the Schoolstable in the football database as well as a view. Name the script{YourLastName}_FootballSchools and attach it here. Use the samplescript in Weekly Lessons Week 14 for reference.

  • The view should be called SchoolsConferences and haveSchools.SchoolName and Conferences.ConferenceName
  • The 4 stored procedures are for the CRUD operations. Add a testcase commented out each stored procedure for me to use:
  1. sp_GetSchools : should just be a query that gets all ofthe columns and rows for the Schools table
  2. sp_InsertSchools : should check and make sure a schooldoesn’t already exist with the same school name before
    OR
    OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.