Hi All
I am writting an stored procedure to get the recently inserted records primary key as follows:
ALTER PROCEDURE [DBO].[AddEditUserMsgDetails]
(
@iJobID [INT]=NULL,
@iUserID [INT]=NULL,
@vFromName [VARCHAR](50)=NULL,
@vFromAddress [VARCHAR](50)=NULL,
@vSubject [VARCHAR](50)=NULL,
@iListID [INT]=NULL,
@vActualText [VARCHAR](100)=NULL
)
AS
BEGIN
/*
Logic Comments: INSERTING OR UPDATING INTO THE TABLE ezlMailJobs
EXEC AddEditUserMsgDetails null,505,'waa','
[email protected]','Test',816,
'Hi <!FN>
please ignore