设置NOCOUNT;选择GroupTable._id,GroupTable.GroupCode,GroupTable.Type,GroupTable.Description从(选择ROW_NUMBER() OVER ( UG._id,UG.GroupCode,UG.Type,UG.Description From UserGroups as UG ) as GroupTable,GroupTable.Row_Number从@pStartIndex到@pStartIndex + @pPag
ArticleNumber, ArticleGroup, ParentID, t3.id as IDSELECT t2.product_number as ArticleNumber, GroupTable.GroupNras ArticleGroup, GroupTable.product_number as ParentIDSELECT MIN(result.product_number) as product_numberproductWHERE LENGTH(result.GroupNr)
StaticTablesGroup public StaticTablesGroup() GroupTables = new List<GroupTablestring Name { get; set; }
[XmlArrayItem("Table", typeof(GroupTable))]
public List<Group