--SQL实例

dim rs,sql

IF EXISTS(SELECT 1 FROM jcff WHERE oid='2609031113212')
SELECT '单据存在[更新或跳过]' msg 
ELSE
SELECT '单据不存在就更新' msg

程序端运行实例（带输出）
set rs= server.CreateObject ("adodb.recordset")
sql="IF EXISTS(SELECT 1 FROM jcff WHERE oid='2609031113212')"&_
" SELECT '单据存在[更新或跳过]' msg"&_
" ELSE"&_
" SELECT '单据不存在就更新' msg"
rs.open sql,conn,1,1
response.write rs("msg")
rs.close:set rs=nothing
If conn.State = 1 Then conn.Close
Set conn = Nothing

'conn.Execute sql