ASP executes update and returns the number of updated entries.

ASP returns the number of updated entries when operating SQL Server Update. You can put a parameter in the execute method of connection. The call method is conn.exe cute (SQL, I), and the I is recorded.
Number of updated entries, sample code:

Connsqlserverstr = "provider = sqloledb.1; server = 192.168.1.28; uid = test; Pwd = test; database = testdbsqlserver"
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open connsqlserverstr
Id = request ("ID ")
SQL = "Update Test Set Name = 'hello' where id = '" & ID &"'"
Conn.exe cute SQL, I

Response. Write ("the number of updates is:" & I)

Reference link for the connection object execute method is: http://www.w3school.com.cn/ado/met_conn_execute.asp