[dba-SQLServer] Executing a SP

Did you SET NOCOUNT OFF before your final select?



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W.
Colby
Sent: Wednesday, August 24, 2005 8:24 AM
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