|
 |
asp_databases thread: SQL Server Stored Programs
Message #1 by "Dave Fashenpour" <davefash@m...> on Tue, 4 Jul 2000 19:3:52
|
|
I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS
Programming with ASP 3.0) -- Executing Stored Procedures from ASP.
My SQL Server is remote at a web site that has given me SQL
access to the database, but NOT to Query Analyzer.
Simple Question.
How can I store a Stored Procedure into SQL Server via a SQL connection?
(i.e. no Enterprise Manager/Query Analyzer access)
Will appreciate any assistance.
Dave Fashenpour
mailto:davefash@m...
Message #2 by "Ravi Kumar" <ravik@w...> on Wed, 5 Jul 2000 18:27:35 +0530
|
|
By writing a 'C' program either using db library or ODBC, you can create a
stored procedure i.e. store a stored procedure.
RK
----- Original Message -----
From: Dave Fashenpour
To: ASP Databases <asp_databases@p...>
Sent: Tuesday, July 04, 2000 7:00 PM
Subject: [asp_databases] SQL Server Stored Programs
> I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS
> Programming with ASP 3.0) -- Executing Stored Procedures from ASP.
> My SQL Server is remote at a web site that has given me SQL
> access to the database, but NOT to Query Analyzer.
>
> Simple Question.
>
> How can I store a Stored Procedure into SQL Server via a SQL connection?
> (i.e. no Enterprise Manager/Query Analyzer access)
>
> Will appreciate any assistance.
>
> Dave Fashenpour
Message #3 by "Ken Schaefer" <ken.s@a...> on Thu, 6 Jul 2000 11:37:10 +1000
|
|
You could use T-SQL...just create connection to the database and execute
your T-SQL statement against the connection...
Cheers
Ken
> ----- Original Message -----
> From: Dave Fashenpour
> To: ASP Databases <asp_databases@p...>
> Sent: Tuesday, July 04, 2000 7:00 PM
> Subject: [asp_databases] SQL Server Stored Programs
>
>
> > I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS
> > Programming with ASP 3.0) -- Executing Stored Procedures from ASP.
> > My SQL Server is remote at a web site that has given me SQL
> > access to the database, but NOT to Query Analyzer.
> >
> > Simple Question.
> >
> > How can I store a Stored Procedure into SQL Server via a SQL connection?
> > (i.e. no Enterprise Manager/Query Analyzer access)
> >
> > Will appreciate any assistance.
> >
> > Dave Fashenpour
|
|
|
View Cart
