From: reb01501@NOSPAMyahoo.com   
      
   Tony C. wrote:   
   > My Question is now:   
   >   
   > 1) Does a SELECT Statement ALWAYS return a result set?   
      
   No. If all a SELECT statement does is assign values to variables   
      
   SELECT @var=col1, @var2=col2 from table   
      
   it will not return a resultset. Otherwise, yes, it will always return a   
   resultset, empty or otherwise.   
      
      
   > 2) Is there a way I can tell by looking at the code which select   
   > statements  should return results sets from and which not?   
      
   See above   
      
   >   
   > I have several SELECT statements that don't appear to return anything.   
   > Sometimes a SELECT statments sets a local variable and doesn't return   
   > anything and sometimes it does.....how do I tell the difference?   
      
   See above.   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)