Thomas O Loughlin
tomlough at eircom.net
Wed Aug 24 10:43:58 CDT 2005
John, Try the following from QA : upWebNewsSource_SelectOne @ID=12 If you need to execute this through a sproc then : EXEC upWebNewsSource_SelectOne @ID=12 But make sure that you've selected your development DB from the QA dropdown toolbar, otherwise you've to fully qualify your sproc, e.g. [DatabaseName].dbo.upWebNewsSource_SelectOne @ID=12 Hope this helps Tom -----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