hi,
i am trying to use stored procedures written in SQLServer and calling from Activer Server pages.
How this is done ? I have called stored procs from VB
applications.
Is it different while calling from ASP ?
thanks
sarath
Printable View
hi,
i am trying to use stored procedures written in SQLServer and calling from Activer Server pages.
How this is done ? I have called stored procs from VB
applications.
Is it different while calling from ASP ?
thanks
sarath
It is the same:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open YourConnectString
Conn.Execute usp_YourStoredProc @param1 = param1, @param2 = param2
you can also execute stored proc through recordset objects and command objects.
i see that it is no different from vb..
thanks
sarath