Re: Newbie: Need quick education on how my SP is working..or not!
From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 06/04/04
- Next message: David Portas: "Re: Generate Random Primary Key"
- Previous message: Roji. P. Thomas: "Re: Generate Random Primary Key"
- In reply to: Larry Woods: "Newbie: Need quick education on how my SP is working..or not!"
- Next in thread: Larry Woods: "Re: Newbie: Need quick education on how my SP is working..or not!"
- Reply: Larry Woods: "Re: Newbie: Need quick education on how my SP is working..or not!"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Jun 2004 18:11:34 +0530
Test your sps in Query Analyser.
It helps you distinguish your front end problms vs back end problems
-- Roji. P. Thomas SQL Server Programmer "Larry Woods" <larry@NOSPAMlwoods.com> wrote in message news:%23VFf54iSEHA.1472@TK2MSFTNGP09.phx.gbl... > I thought I understood SP's, but apparently not. I have an SP that looks > like this...in part: > > PROCEDURE ..... > ( > @VALUE varchar... > ) > > DELETE ....blah > > SELECT * from table WHERE key=@VALUE > GO > > I want a recordset returned. The above does NOT return anything. By > removing the DELETE it works fine. How do I get a recordset returned and > still keep the DELETE in place? > > TIA, > > Larry Woods > >
- Next message: David Portas: "Re: Generate Random Primary Key"
- Previous message: Roji. P. Thomas: "Re: Generate Random Primary Key"
- In reply to: Larry Woods: "Newbie: Need quick education on how my SP is working..or not!"
- Next in thread: Larry Woods: "Re: Newbie: Need quick education on how my SP is working..or not!"
- Reply: Larry Woods: "Re: Newbie: Need quick education on how my SP is working..or not!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
