[dba-SQLServer] Executing a SP

In VB (don't know net) I use the following

Dim rsData As ADODB.Recordset
Set rsData = [YourConnectionToSQL].Execute("YourSP '" & [YourPrimaryKey]
& "'")

For instance I have a DataEnvironment called DEGen and a connection
object to SQL Server called SQLConn which would make the above line like
so:

Set rsData = DEGen.SQLConn.Execute("MySP '" & [MyKey] & "'") 


PAUL HARTLAND
Database Designer/Programmer
paul.hartland at isharp.co.uk
ISHARP
DDI - 01922 472031
Mobile - 07730 523179

 

ISHARP (Information Services for Hospitality, Audit, Retail and
Pharmacy) provide IT resources for the Christie Group Stock & Inventory
Services companies.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: 24 August 2005 16:38
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Executing a SP

Thanks, that worked, and the SP returned exactly one record which was
expected.  Now to discover why it doesn't return a record in the VB.Net
code.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Hartland
Sent: Wednesday, August 24, 2005 11:31 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Executing a SP


To execute an SP through Query Analyser try the following:

EXEC upWebNewsSource_SelectOne 'YourPrimaryKeyValue'

Note include the single quotes around your primary key 


PAUL HARTLAND
Database Designer/Programmer
paul.hartland at isharp.co.uk
ISHARP
DDI - 01922 472031
Mobile - 07730 523179

 

ISHARP (Information Services for Hospitality, Audit, Retail and
Pharmacy) provide IT resources for the Christie Group Stock & Inventory
Services companies.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: 24 August 2005 16:24
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Executing a SP

How do I execute a SP to see the resulting data.

The SP is:

------------------------------------------------------------------------
----
-----
-- Stored procedure that will select an existing row from the table
'WebNewsSource'
-- based on the Primary Key.
-- Gets: @ID int
------------------------------------------------------------------------
----
-----
CREATE PROCEDURE [dbo].[upWebNewsSource_SelectOne]
	@ID int
AS
SET NOCOUNT ON
-- SELECT an existing row from the table.
SELECT
	[ID],
	[Source],
	[RSSURL],
	[RSSSelect],
	[RSSTitle],
	[RSSLink],
	[RSSDescription]
FROM [dbo].[WebNewsSource]
WHERE
	[ID] = @ID


GO

It is in database RSSFeeds
I am logged in and trying to use query analyzer to execute the SP but
obviously don't know how.  

Thanks,

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________

*  This message is confidential.
*  This email, its content and any files transmitted with it are
intended solely for the addressee and may be legally privileged and/or
confidential.
*  Access by any other party is unauthorised without the express written
permission of the sender.
*  If you have received this email in error you may not copy or use the
contents, attachments or information in any way and any review, use,
dissemination, forwarding, disclosure, alteration, printing of this
information is strictly prohibited. Please destroy it and notify the
sender via return e-mail.
*  This email has been prepared using information believed by Paul
Hartland to be reliable and accurate, but the company makes no warranty
as to accuracy or completeness. In particular the author does not accept
responsibility for changes made to this email after it was sent.
*  Any opinions expressed in this document are those of the author and
do not necessarily reflect the opinions of the company or its
affiliates.

The Orridge web site can be found at:
http://www.orridge.co.uk


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com