C# (CSharp) ASStoredProcs.DMVParser SelectParser 예제들

예제 #1

파일: XmlaDiscover.cs 프로젝트: nGenieDeveloper/ASStoredProcedures

 public DataTable DMV(String discoverRowset, String restrictions, String properties)
 {
     if (discoverRowset.Trim().StartsWith("SELECT ", StringComparison.InvariantCultureIgnoreCase))
     {
         DMVParser.SelectParser sp = new DMVParser.SelectParser();
         sp.Parse(discoverRowset);
         if (restrictions.Length == 0)
         {
             restrictions = sp.Restrictions;
         }
         return(DiscoverView(sp.FromClause, restrictions, properties, sp.WhereClause, sp.OrderByClause, sp.Distinct, sp.Columns));
     }
     else
     {
         return(DiscoverView(discoverRowset, restrictions, properties, string.Empty, string.Empty, false, new string[0]));
     }
 }

예제 #2

파일: XmlaDiscover.cs 프로젝트: sergey-vdovin/Slicing-and-dicing-over-data-differences-between-SSAS-databases

 public DataTable DMV(String discoverRowset, String restrictions, String properties)
 {
     if (discoverRowset.Trim().StartsWith("SELECT ", StringComparison.InvariantCultureIgnoreCase))
     {
         DMVParser.SelectParser sp = new DMVParser.SelectParser();
         sp.Parse(discoverRowset);
         if (restrictions.Length == 0)
         {
             restrictions = sp.Restrictions;
         }
         return DiscoverView(sp.FromClause,restrictions, properties, sp.WhereClause, sp.OrderByClause, sp.Distinct, sp.Columns);
     }
     else
     {
         return DiscoverView(discoverRowset, restrictions, properties,  string.Empty, string.Empty, false, new string[0]);
     }
 }