select * from qmd_changes order by fseStatus desc select contentId from tbl_PRD_Images with (nolock) where ownerId = and ownertype = and linkId = and linkType = 'SKU' and imageCode =

Inserting Image #imageCode#

insert into tbl_PRD_Images( ownerId, ownerType, linkId, linkType, imageCode, contentId, fileSize, fileExt, comment, recordSource, providerURL, uploadDate ) values( , , , 'SKU', , , , , , , , )

Deleting Image #imageCode#

delete tbl_PRD_Images where ownerId = and ownertype = and linkId = and linkType = 'SKU' and imageCode =

Updating Image #imageCode#

update tbl_PRD_Images set uploadDate = , contentId = , #_fc# = where ownerId = and ownerType = and linkId = and linkType = 'SKU' and imageCode= insert into tbl_PRD_ProductImages ( linkId, code, catalogLevel, ownerId, fsl_tablecode, #imageCode#_ContentId, #imageCode#_FileSize, #imageCode#_FileExt, #imageCode#_UploadDate, #imageCode#_Comment ) values ( , '', 'SKU', , , , , , , ) ---> select FileName from tbl_FSC_Content with (nolock) where contentId = and mainFolder = and subFolder = 'PRD' insert into tbl_FSC_Content ( mainFolder, subFolder, subFolder2, fileName, createDate ) values ( , 'PRD', '', , )

Copy #htmleditformat( _sourcefile )# to #htmleditformat( _destinationFile )#

select FileName from tbl_FSC_Content with (nolock) where contentId = and mainFolder = and subFolder = 'PRD'

Copy #htmleditformat( _sourcefile )# to #htmleditformat( _destinationFile )#

select FileName from tbl_FSC_Content with (nolock) where contentId = and mainFolder = and subFolder = 'PRD'

Delete #htmleditformat( _deleteFile )#

delete from tbl_FSC_Content where contentId = and contentId <> 755 select * from tbl_PRD_Images with (nolock) where ownerId = and ownerType = and linkId = and linkType = 'SKU'