Thanks but can u please send one of the example how to write this command in stored procedure.

Thanks for ur help its working now.Actually  I am new to this programming .

Can u please help me to know how to display error messages of these queries on front...

CREATE PROCEDURE sp_myInsert1243

    @odid12 int,

    @rqty12 int,

   @wqty12 int,

@rdate12 datetime,

  @badge12  nvarchar(10),

   @des12 nvarchar(50),

  @stat12 nchar(1),

  @remark12 nvarchar(10)

As

declare @rqty12 int

INSERT INTO RECEIVE (ODID,RQTY,WQTY,RDATE,BADGEID,STATUS,REMARKS) VALUES(@odid12,

 @rqty12,'0',@rdate12,@badge12,@stat12,@remark12)

go

UPDATE PART SET OHQTY =...

CREATE PROCEDURE MyProcedure

@des nvarchar(50)

AS

SELECT DISTINCT O.ODID, R.RCID, R.RQTY, R.RDATE, NetQty FROM RECEIVE R, ORDER12 O WHERE O.PARTID = (SELECT PARTID FROM PART WHERE [DESC]= @des) AND O.ODID = R.ODID AND R.NetQty...

PARTID is Id so it can not be repeated .

can you please help me to know the parameter passing.