The writing and example of ASP stored procedure

'===========
' Function: Stored procedure
' Function: Query
' Parameters: Set of stored procedure parameters
'================
function Dbstroce (Query_sign,table,outerfield,condition,orderfield,strinsert,isorder)
Set cmd = server. CreateObject ("Adodb.command")
cmd.commandtext= "P_agents_query"
Cmd.commandtype=4
Cmd.prepared = True
Set CMD. ActiveConnection = conn
Cmd.parameters ("@query_sign") =query_sign
Cmd.parameters ("@table") =table
Cmd.parameters ("@outerfield") =outerfield
Cmd.parameters ("@condition") =condition
Cmd.parameters ("@orderfield") =orderfield
Cmd.parameters ("@strInsert") =strinsert
Cmd.parameters ("@strInsert") =strinsert
Cmd.parameters ("@isorder") =isorder
If Query_sign=0 Then
Set Rs=cmd.execute
Else
Cmd.execute
End If
Set cmd = Nothing
End Function