Actual script:
From version 4.0:
/****** Object: Stored Procedure [a_usp_adduser] Script Date: 9/15/2008 11:18:05 AM ******/
USE [Gita];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE PROCEDURE [a_usp_adduser]
(@login varchar(20), @pswd varchar(20), @f_name varchar(25), @l_name varchar(35), @address_1 varchar(30), @address_2 varchar(30), @city varchar(30), @state char(2), @zipcode char(10), @email varchar(50))
AS
INSERT INTO USERLIST (login, pswd, f_name, l_name, address_1, address_2, city, state, zipcode, email)
VALUES (@login, @pswd, @f_name, @l_name, @address_1, @address_2, @city, @state, @zipcode, @email)
GO
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
From version 3.2:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.a_usp_adduser Script Date: 9/15/2008 11:14:05 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[a_usp_adduser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[a_usp_adduser]
GO
CREATE PROCEDURE a_usp_adduser
/* Some comments here
*/
@login varchar(20),
@pswd varchar(20),
@f_name varchar(25),
@l_name varchar(35),
@address_1 varchar(30),
@address_2 varchar(30),
@city varchar(30),
@state char(2),
@zipcode char(10),
@email varchar(50)
AS
INSERT INTO USERLIST (login, pswd, f_name, l_name, address_1, address_2, city, state, zipcode, email)
VALUES (@login, @pswd, @f_name, @l_name, @address_1, @address_2, @city, @state, @zipcode, @email)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
>!]