--创建函数
CREATE FUNCTION GetAttr (@ProdID NUMBER(10))
RETURNS NVARCHAR(1000)
AS
BEGIN
DELCARE @result NVARCHAR(1000)
SET @result=''
SELECT @result= @result + av.attributevalue + SPACE(1)
FROM lc_fitment_pinfo_attributelist al,
lc_fitment_attributevalue av,
lc_fitment_productinfo info
WHERE info.productid = @ProdID
AND al.productinfoid = info.id
AND al.product_choiceattributevalueid = av.id
RETURN(@result)
END--得到记录集
SELECT
info.aliasname,
prod.code,
info.price,
dbo.GetAttr(prod.id)
FROM lc_fitment_productinfo info,
lc_fitment_product prod,
WHERE prod.id = 1
AND info.productid = prod.id
CREATE FUNCTION GetAttr (@ProdID NUMBER(10))
RETURNS NVARCHAR(1000)
AS
BEGIN
DELCARE @result NVARCHAR(1000)
SET @result=''
SELECT @result= @result + av.attributevalue + SPACE(1)
FROM lc_fitment_pinfo_attributelist al,
lc_fitment_attributevalue av,
lc_fitment_productinfo info
WHERE info.productid = @ProdID
AND al.productinfoid = info.id
AND al.product_choiceattributevalueid = av.id
RETURN(@result)
END--得到记录集
SELECT
info.aliasname,
prod.code,
info.price,
dbo.GetAttr(prod.id)
FROM lc_fitment_productinfo info,
lc_fitment_product prod,
WHERE prod.id = 1
AND info.productid = prod.id
但怎么用啊? 我这里的是Orcal的数据库系统提示 GetAttr 无效标识
哪里不明白再问。