Skip to content

Latest commit

 

History

History
57 lines (31 loc) · 1.41 KB

File metadata and controls

57 lines (31 loc) · 1.41 KB

Library Management System

By Madelyn Haldeman 3/6/2019

Final SQL project for The Tech Academy

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

  • Microsoft SQL Server Management Studio 2017
  • A git-compatible CLI

Installing

A step by step series of examples that tell you how to get a development env running

Clone this repository

$ git clone https://github.com/mhaldeman8875/SQL.git

install the .BAK file


1. Right click Databases on left pane (Object Explorer)
2. Click Restore Database...
3. Choose Device, click "..." and add your .bak file
4. Click OK, then **OK** again

  • Open the file "ALL_STORED_PROCEDURES" ...\LibraryManagementSystem\STORED_PROCEDURES\ALL_STORED_PROCEDURES.sql"

  • To test functionality of stored procedures, execute each line starting with exec individually

Built With

Authors

Madelyn Haldeman - GitHub

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

The Tech Academy - Who provided the curriculum for this project