表newgudong中有欄位“nmd”,需要從表ggjc中獲取相同股票代碼的年加倉次數的統計次數,并把統計次數插入到表newgudong中的欄位“nmd”,且能批量完成計算,請教下面的寫法哪里出錯了,或者勞煩老師您幫寫一個,謝謝!:
<%
Dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.Execute("insert into newgudong.nmd values(select count(*) as total from ggjc where newgudong.stockid=ggjc.stockid and datediff('d',bddate,now())<=365)")
set conn=nothing
%>

轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/133379.html
標籤:ASP
