[dba-SQLServer] Executing a SP

John W. Colby jwcolby at colbyconsulting.com
Wed Aug 24 10:23:53 CDT 2005


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/





More information about the dba-SQLServer mailing list