Copy a SQL routine into an existing SQL DB as Store Procedure

Posted on 2013-06-24
Medium Priority
Last Modified: 2013-06-24
I have a SQL routine that has been written by someone else.  I want to copy the SQL file into an existing DB as a Store Procedure to run.  It will create a list of new tables and reports to be used in the DB.

How do I do this?


Question by:GPSPOW
LVL 23

Accepted Solution

Racim BOUDJAKDJI earned 2000 total points
ID: 39272894
Simply use SSMS and copy and paste the script into the query window and run it.

Author Closing Comment

ID: 39273278
Thank you

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question