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/