SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_insertLogin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_insertLogin]
GO

CREATE PROCEDURE sp_insertLogin

@UserName VARCHAR(20),
@First VARCHAR(20),
@Last  VARCHAR(20),
@pwd VARCHAR(20)

 AS

DECLARE @encryptedWord VARCHAR(10)
EXEC sp_encryptPassword @pwd ,  @EncPwd  = @encryptedWord OUTPUT

INSERT Logins  VALUES (@UserName, @First, @Last , @encryptedWord   )


GO
SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO