Eassy Way To create Store Procedure..Syntax
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER PROCEDURE [Procedure_Name]
@active varchar(10)
AS
select usr_ename, usr_code, usr_pswd
from h_usr
where usr_active = @active
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
