How to create simple stored procedure in sql-server 2005.

How to create simple stored procedure in sql-server 2005.

Simple Method to create new Procedure in sql server. 2005/2008


use [Database_Name]


create procedure [schema].[Procedure_name]
@fielname1 varchar(16)=null,
@fielsname2 varchar(16)=null
as
select
[filedname1] ,[fieldname2] from [table_name]
where fieldname3=@fielname1

Share This