Conn.exe cute

Source: Internet
Author: User

(1) wzcount = conn.exe cute ("select count (ID) from 'table1'", 0, 1) (0)
What do the two parameters after execute mean? What does the last 0 mean?
(2) Set conn = server. Createobject ("ADODB. Connection ")
Set rs = server. Createobject ("ADODB. recordset ")
Rs. Open rssql, Conn, 1, 1, & h0001
What is the last & h0001?

1. Rs. Open SQL, Conn, a, B, c
2. Conn. Execute (SQL, rowsaffected, c)
Parameter description: The SQL value can be an SQL statement, table name, stored procedure name, or any string accepted by the data provider.
To improve performance, it is best to specify the appropriate value for the c parameter. The optional parameter rowsaffected will return the number of affected values after the insert, update, or delete query is executed. These queries return a closed recordset object.
A SELECT query returns an open recordset with a rowsaffected value of-1 and one or more rows.
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open "provider = sqloledb; Password = Xiaolu; user id = sa; database = test; Data Source ="
Conn.exe cute "Update Table1 set col1 = '000000'", rowsaffected, & h0001
Response. Write rowsaffected & "the row is affected"
Conn. Close
Set conn = nothing
A: adopenforwardonly (= 0) read-only, and the current data record can only be moved down
Adopenkeyset (= 1) read-only, the current data records can be freely moved
Adopendynamic (= 2) can be read and written, and the current data records can be freely moved
Adopenstatic (= 3) can be read and written. The current data record can be moved freely. You can see the new record.
B: adlockreadonly (= 1) default lock type. The record set is read-only and cannot be modified.
Adlockpessimistic (= 2) pessimistic locking. When a record is modified, the data provider attempts to lock the record to ensure that the record is edited successfully. You only need to edit the record at the beginning, and lock the record immediately.
Adlockoptimistic (= 3) Optimistic Locking is performed until the update record is submitted using the update method.
Adlockbatchoptimistic (= 4) supports Optimistic Locking in batches. Multiple records can be modified. Records are locked only after the updatebatch method is called.
When no record needs to be modified, the read-only record set should be used, so that the provider does not need to perform any detection. For general use, Optimistic Locking may be the best choice, because the record is locked for only a short period of time, and the data is updated during this period of time. This reduces resource usage.

C: (specify the SQL statement type)
Adcmdunknown (= & h0008) is unknown and must be determined by the system. It is slow and the default value is
Adcmdtext (= & h0001) command statements such as SQL statements such as: Select * From Table1
The name of the table queried by adcmdtable (= & h0002), for example, Table1.

Adcmdstoredproc (= & h0004) stored procedure name
Ad1_file (= & h0100) object type file name
Adcmdtabledirect (= & h0200) is the name of the table that can directly obtain the row content from the table.

This article Reprinted from the network base camp:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.