Wednesday, November 11, 2009

Insert Procedure !!

CREATE PROCEDURE insNews
(
@headline varchar (50),
@date datetime,
@active varchar(3),
@delete varchar (3),
@image varchar (50),

)

as

inseart into tblNewsMaster

(
nm_headline,
nm_date,
nm_activce,
nm_delete,
image
)

values

(
@headline,
@date,
'Yes'
'No'
@Image

)

Go

No comments: