真诚求助：我以前使用的是ac数据库，现在改为SQL数据库后不知道如何锁定了，请朋友帮忙……                  

                    'SQL2005数据库
                    '想锁定（独占锁）此表，锁定开始。
                    set rstl=server.createobject("ADODB.recordset")
                    sqll="select*from xinxi order by ID desc"
                    rstl.open sqll,conn,1,3
                    if isnull(rstl("ID")) then
                        ID=1001
                    else
                        if rstl.eof then
                            ID=1001
                        else
                            ID=rstl("ID")+1
                        end if
                    end if   
                                                
                    xinxia="这是假设数据"
                    xinxib="这是假设数据"
                    xinxic="这是假设数据"            
                    sqls="insert into xinxi (ID,xinxia,xinxib,xinxic) values("
                        sqls=sqls&sqlstr(ID)&","
                        sqls=sqls&sqlstr(xinxia)&","
                        sqls=sqls&sqlstr(xinxib)&","
                        sqls=sqls&sqlstr(xinxic)&")"
                    conn.execute sqls
                    '想锁定（独占锁）此表，锁定结束。                                             
                    conn.close