最高效率的两种asp执行mssql语句的function/sub

[Scarroot]

'*******
'pi_conn 为一connection对象,pi_sql为要执行的sql语句
'*******
public sub sb_exec_sql(pi_conn, pi_sql)
dim obj_cmd
dim s_error_string
set obj_cmd = Server.CreateObject("ADODB.Command")
with obj_cmd
set .ActiveConnection = pi_conn
.CommandText = pi_sql
.CommandType = 1
end with
obj_cmd.execute , , &H80
set obj_cmd.ActiveConnection = Nothing
set obj_cmd = nothing
end sub

public function fn_exec_sql_return_rs(pi_conn, pi_sql)
dim obj_cmd, obj_rs
set obj_cmd = Server.CreateObject("ADODB.Command")
with obj_cmd
set .ActiveConnection = pi_conn
.CommandText = pi_sql
.CommandType = c_CommandType_adCmdText
end with
set obj_rs = Server.CreateObject("ADODB.Recordset")
with obj_rs
.CursorLocation = 3
.Open obj_cmd, , 0, 1
end with
set fn_exec_sql_return_rs = obj_rs.clone
set obj_cmd.ActiveConnection = Nothing
set obj_cmd = nothing
set obj_rs = nothing
end function

一个只是执行一条sql操作，一个是返回一个recordset，返回的RS的数据是可以MOVE的.
现在要求的是最高如何去最高效率去执行这两种SQL语句，如何去精简这两个函数？
1。占用系统资源。
2。速度。
3。代码最短

[Scarroot]

d

[Scarroot]

d

[Scarroot]

d

[scar001]

顶

[satans18]

d

[Scarroot]

d

[Scarroot]

d

[Scarroot]

d

[scar001]

d

[Scarroot]

最后一顶