日期:2014-05-18  浏览次数:20452 次

触发器统计表总量
sql2= "select   d.property_value,d.valueid,   "
sql2=sql2& "   (select   count(0)   "
sql2=sql2& "   from   [Cate_Property_value]   a   inner   join   vProduct   b   "
sql2=sql2& "   on   dbo.compare(b.属性,a.valueid)=1   "
sql2=sql2&   "   where   a.propertyid= "&rs1( "propertyid ")& "   and   a.valueid=d.valueid   and   1=1 "
If   keyword <> " "   Then   sql2=sql2& "   and   b.物品名称   like   '% "&keyword& "% ' "
If   aid <> " "   Then   sql2=sql2& "   and   substring(b.物品类别,1,len( ' "&aid& " '))= ' "&aid& " ' "
sql2=sql2& ")   as   total   from   [Cate_Property_value]   d "
sql2=sql2& "   where   d.propertyid= "&rs1( "propertyid ")& "   "

像这样一条语句,我想用触发器来实现符合记录的统计,触发器该怎么写?谁能帮我写个简单的例子吗?

------解决方案--------------------
?
------解决方案--------------------
在说什么
晕了