Inserting and reading values in Stored Procedures

[freewilly]

Hi team
I'm trying to insert values into a table and read then back with the same sp with:

Insert into Sales Values(1,2,44.99)
Select * from Sales

When I check the table the values are there. When I run the sp from Query analyser I get the correct results. When I run the query minus the Insert from VB using ADO I get the correct results. However nothing is returned if the sp contains both the the insert and select!

What am I missing?

Cheers

 

[tlbroadbent]

Add the command SET NOCOUNT ON before the INSERT in the stored procedure.

Set nocount on
Insert into Sales Values(1,2,44.99)
Select * from Sales Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.