select contentId, thumbnailId from tbl_DOC_Documents where ownerId = and fsl_tablecode = and docId = delete from tbl_DOC_Documents where ownerId = and fsl_tablecode = and docId = select contentId, HighResCntID from tbl_IMG_Images where ownerId = and fsl_tablecode = and imgId = delete from tbl_IMG_Images where ownerId = and fsl_tablecode = and imgId = select contentId from tbl_#_contentDomain#_Repository where ownerId = and ownerType = and fileId = delete from tbl_#_contentDomain#_Repository where ownerId = and ownerType = and fileId = select mainFolder, subFolder, subFolder2, fileName from tbl_FSC_Content where contentId = and contentId != 755 delete from tbl_FSC_Content where contentId = update tbl_DOC_Documents set lastUpdatedDate = , lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and docId = and contentId = insert into tbl_DOC_Documents ( ownerId, fsl_tablecode, uploadDate, lastUpdatedDate, lastUpdatedBy, docTitle, docDescription, publishDate, unpublishDate, categoryId, sortRank, fileExt, fileSize, contentId ) values ( , , , , , , , , , 0, 99, 0, '', 0 ) update tbl_IMG_Images set lastUpdatedDate = , lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and imgId = insert into tbl_IMG_Images ( ownerId, fsl_tablecode, uploadDate, lastUpdatedDate, lastUpdatedBy, ImgTitle, ImgDescription, publishDate, unpublishDate, categoryId, sortRank, fileExt, fileSize, contentId,HighResCntID ) values ( , , , , , , , , , 0, 99, 0, '', 0, 0 ) update tbl_#_contentDomain#_Repository set updateDate = , updateUserId = , #_f# = , #_f# = where ownerId = and ownerType = and fileId = and contentId = and containerId = and containerType = insert into tbl_#_contentDomain#_Repository ( ownerId, ownerType, containerId, containerType, uploadDate, updateDate, updateUserId, docTitle, docDescription, publishDate, unpublishDate, category, sortRank, fileExt, fileSize, contentId, restricted, internalOnly ) values ( , , , , , , , , , , , 0, 99, 0, '', 0, , ) select mainFolder, subFolder, subFolder2, fileName from tbl_FSC_Content where contentId = and contentId != 755 insert into tbl_FSC_Content( mainFolder, subFolder, fileName, createDate ) values ( , , , ) update tbl_DOC_Documents set uploadDate = , fileSize = , fileExt = , #_contentIdDBField# = where ownerId = and fsl_tablecode = and docId = update tbl_FSC_Content set fileName = where contentId = and contentId != 755 update tbl_DOC_Documents set uploadDate = , fileSize = , fileExt = where ownerId = and fsl_tablecode = and docId = insert into tbl_FSC_Content( mainFolder, subFolder, fileName, createDate ) values ( , , , ) update tbl_IMG_Images set uploadDate = , fileSize = , fileExt = , #_contentIdDBField# = where ownerId = and fsl_tablecode = and imgId = update tbl_FSC_Content set fileName = where contentId = and contentId != 755 update tbl_IMG_Images set uploadDate = , fileSize = , fileExt = where ownerId = and fsl_tablecode = and imgId = insert into tbl_FSC_Content( mainFolder, subFolder, fileName, createDate ) values ( , , , ) update tbl_#_contentDomain#_Repository set uploadDate = , updateDate = , fileSize = , fileExt = , #_contentIdDBField# = where ownerId = and ownerType = and fileId = update tbl_FSC_Content set fileName = where contentId = and contentId != 755 update tbl_#_contentDomain#_Repository set uploadDate = , updateDate = , fileSize = , fileExt = where ownerId = and ownerType = and fileId =