Inserting Memo #memoType#

insert into tbl_PRD_Memo( ownerId, fsl_tablecode, linkId, linkType, memoType, memoData, memoSubType ) values( , , , 'SKU', , , )

Deleting Memo #memoType#

delete tbl_PRD_MEMO where ownerId = and fsl_tablecode = and linkId = and linkType = 'SKU' and memoType=

Updating Memo #memoType#

update tbl_PRD_MEMO set memoData = , memoSubType = where ownerId = and fsl_tablecode = and linkId = and linkType = 'SKU' and memoType=
select * from tbl_PRD_Memo with (nolock) where ownerId = and fsl_tablecode = and linkId = and linkType = 'SKU'