视图

CREATE VIEW gavininternet.v_Products
AS
SELECT GroupProductID AS ProductID, ProductNum, ProductName AS [Name],
      ImageURL = gavininternet.GetGroupProdcutMainImage(ProductNum), [Description],
      'GProDetail.aspx?ProductID=' AS DetailPage, AddTime AS Date,'' AS Category ,IsPublic,IsPromo,PromoOverdueTime
FROM GroupProduct
UNION ALL   --所有列表字段连接
SELECT ProductID, ProductNum, [Name],
      ImageURL = gavininternet.GetProdcutMainImage(ProductNum), [Description],
      'Detail.aspx?ProductID=' AS DetailPage, AddDate AS Date,Category ,IsPublic,IsPromo,PromoOverdueTime
FROM pub_Products
WHERE IsGroup = 0