Collections:
Generating CREATE PROCEDURE Scripts on Existing Stored Procedures in SQL Server
How To Generate CREATE PROCEDURE Script on an Existing Stored Procedure in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to know how an existing stored procedure was created, you can use SQL Server Management Studio to automatically generate a "CREATE PROCEDURE" script The following tutorial shows you how to do this:
1. Run SQL Server Management Studio and connect to SQL server.
2. On the Object Explorer window, follow the object tree: Databases > FyiCenterData > Programmability > Stored Procedures > dbo.ShowFaq.
3. Click right mouse button on dbo.ShowFaq. The context menu shows up.
4. Select "Script Stored Procedure as" > "CREATE to" > "New Query Editor Window". The following script will be displayed:
USE [FyiCenterData] GO /****** Object: StoredProcedure [dbo].[ShowFaq] Script Date: 05/19/2007 21:31:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[ShowFaq] AS BEGIN PRINT 'Number of questions:'; SELECT COUNT(*) FROM Faq; PRINT 'First 5 questions:' SELECT TOP 5 * FROM Faq; END; CREATE TABLE Faq (Question VARCHAR(80));
⇒ sys.sql_modules - Getting Stored Procedure Definitions Back in SQL Server
⇐ Ending Stored Procedures Properly in SQL Server
2017-01-05, 2656🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...