How can i copy stored procedures that in database in the source code, and paste them into my database?

If the stored procedure exists in one database (tbh) and you want to copy it to your database it is quite simple. If you are using SQL Server Management Studio you can script it out by right-clicking on the stored procedure and selecting the Script and create method.

If you are using Visual Studio you can use the Server Explorer and double click on the stored procedure to open it in the VS IDE, where you can then copy and paste somewhere to run as a sql script. Note however that the script will start with the Alter keyword that you will need to change to the Create keyword before running it against your other database.

You can uses SSMS to create scripts for multiple stored procedures, put them all in one text file, separated by go statements and run the entire set of scripts at one time.


Steve

I've opened source code database in SSMS, and created a script off all needed stored procedures in 1 file.
Now how do I run this script in visual studio over my project's database?

Yevi,

You won't be able to run your script in Visual Studio. You will need to attach your new database to SQL Server using SSMS, select the database and open a new query window. Then paste the script into the query window and run it; alternately, after you attach your new database you could drag and drop your sql script (provided it has a .sql extension) onto the SSMS query window area and it will create/open a new query window with the script in it, then you just need to ensure that your database is selected in the drop down before running the script.

Visual studio is set up to only deal with one table or stored procdure at a time, and then not via scripts.


Steve

Thanks, done!