Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to customize SMO script for ALTER or CREATE stored procedure Expand / Collapse
Author
Message
Posted Friday, March 26, 2010 4:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 26, 2010 7:43 PM
Points: 2, Visits: 2
When I use SQL Server Management Studio I can define a script for creating a stored procedure
Ex:

USE [RM_BILLING]
GO
/****** Object: StoredProcedure [dbo].[Insert_Affiliate_Info] Script Date: 03/26/2010 18:03:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- ===============================================
-- !!! Auto-Generated - Do Not Modify Directly !!!
-- Created date...: 2010-03-25 @ 10.20.35
-- Description....: Insert Affiliate_Info record
-- !!! !!! Use tool to regenerate !!! !!!
-- ===============================================
ALTER PROCEDURE [dbo].[Insert_Affiliate_Info]
(
@affID Int,
@affName VarChar(100)
)
AS
BEGIN
INSERT INTO Affiliate_Info
(
Aff_ID,
Aff_Name
)
VALUES
(
@affID,
@affName
)
END
Post #891156
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse