ADODB.Command vs ADODB.RecordSet

ADODB.Command 

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.Open "provider=SQLOLEDB;Network Library=DBMSSOCN;server=;database=;uid=;pwd=;"

Set oCmd = Server.CreateObject("ADODB.Command")

With oCmd

 .CommandText = "쿼리" or "저장 프로지저"

 .ActiveConnection = oConn

 

 .Parameters.Append .CreateParameter("RETURN_VALUE", adBigint, adParamReturnValue) 

 .Execute , , adExecuteNoRecords

 iResultNum = .Parameters("RETURN_VALUE") '//결과값

End With

ADODB.RecordSet

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.Open "provider=SQLOLEDB;Network Library=DBMSSOCN;server=;database=;uid=;pwd=;"

oRs.Open "up_data_request_category_info", oConn

 If ( oRs.BOF Or oRs.EOF ) Then     

Else

Response.Write oRs("category_name")

end if