×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Trần Hải Quân
Added: May 14, 2013 6:33 AM
Views: 33
Tags: sql episerver
  1. SELECT  
  2.        pd.Name,pro.String,pro.PageLink,pro.Date,pro.guid,pro.Number,pro.Boolean,pro.LongString,wp.Created,wp.Name
  3. FROM    tblProperty pro
  4.         INNER JOIN tblPage p ON pro.fkPageID = p.pkID
  5.         INNER JOIN tblWorkPage wp ON wp.fkPageID=p.pkID
  6.         INNER JOIN dbo.tblPageType pt ON p.fkPageTypeID=pt.pkID
  7.         INNER JOIN tblPageDefinition pd ON pro.fkPageDefinitionID = pd.pkID
  8.         INNER JOIN tblPageDefinitionType pdt ON pd.fkPageDefinitionTypeID = pdt.pkID
  9. WHERE
  10.     pt.Name ='QuizWidgetBlock'-- <-- page type name