select contentId from tbl_PRD_Repository with (nolock) where ownerId = and ownertype = and linkId = and linkType = 'SKU' and docTitle =

Inserting File #htmleditformat( docTitle )#

 insert into tbl_PRD_Repository( ownerId, ownerType, containerId, containerType, docTitle, contentId, fileSize, fileExt, docDescription, uploadDate, hiddenFile, restricted, internalOnly, publishDate, unpublishDate, sortRank, category ) values( , , , 'SKU', , , , , , , 'N','N','N', , , , )

Deleting File #htmleditformat( docTitle )#

 delete tbl_PRD_Repository where ownerId = and ownertype = and containerId = and containerType = 'SKU' and docTitle = and internalOnly = 'N' and hiddenFile='N' and restricted='N'

Updating File #htmleditformat( docTitle )#

 update tbl_PRD_Repository set uploadDate = , contentId = , category = , #_fc# = where ownerId = and ownerType = and containerId = and containerType = 'SKU' and docTitle = select FileName from tbl_FSC_Content with (nolock) where contentId = and mainFolder = and subFolder = 'SKU' insert into tbl_FSC_Content ( mainFolder, subFolder, subFolder2, fileName, createDate ) values ( , 'SKU', '', , )

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

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

Delete #htmleditformat( _deleteFile )#

 delete from tbl_FSC_Content where contentId = and contentId <> 755 select r.docTitle, r.contentId, r.fileSize, r.fileExt, r.docDescription, r.sortRank, r.publishDate, r.unpublishDate, c.categoryDescription from tbl_PRD_Repository r with (nolock) left outer join tbl_PRD_RepositoryCategories c with (nolock) on c.categoryId = r.category and c.containerType = r.containerType where r.ownerId = and r.ownerType = and r.containerId = and r.containerType = 'SKU' and r.internalOnly <> 'Y' and r.hiddenFile <> 'Y' and coalesce( r.restricted, 'N' ) <> 'Y' select categoryId from tbl_PRD_RepositoryCategories with (nolock) where ownerId = and ownerType = and containerType = 'SKU' and categoryDescription = select categoryId from tbl_PRD_RepositoryCategories with (nolock) where ownerId = 0 and ownerType = and containerType = 'SKU' and categoryDescription = select categoryId from tbl_PRD_RepositoryCategories with (nolock) where ownerId = 0 and ownerType = '*' and containerType = 'SKU' and categoryDescription = insert into tbl_PRD_RepositoryCategories ( ownerId, ownertype, categoryDescription, containerType, sortRank, hidden ) values ( , , , 'SKU', 99, 'N' )