Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #709
| From | "Bob Barrows" <reb01501@NOSPAMyahoo.com> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: One more thing I don't understand in large Stored Procedure |
| Date | 2011-10-02 13:44 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <j6a7u8$np2$1@dont-email.me> (permalink) |
| References | <lf7h87lipni429qkdkfp09gskcuaj8nk7q@4ax.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. >
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
One more thing I don't understand in large Stored Procedure Tony C. <me@here.com> - 2011-10-02 12:34 -0500
Re: One more thing I don't understand in large Stored Procedure "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-10-02 13:44 -0400
Re: One more thing I don't understand in large Stored Procedure Tony C. <me@here.com> - 2011-10-02 12:47 -0500
Re: One more thing I don't understand in large Stored Procedure Tony C. <me@here.com> - 2011-10-02 13:05 -0500
Re: One more thing I don't understand in large Stored Procedure Erland Sommarskog <esquel@sommarskog.se> - 2011-10-02 20:31 +0200
Re: One more thing I don't understand in large Stored Procedure Tony C. <me@here.com> - 2011-10-02 13:32 -0500
Re: One more thing I don't understand in large Stored Procedure Henk van den Berg <me@myplace.net> - 2011-10-02 21:28 +0200
Re: One more thing I don't understand in large Stored Procedure "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-10-02 15:25 -0400
Re: One more thing I don't understand in large Stored Procedure Tony C. <me@here.com> - 2011-10-02 15:31 -0500
csiph-web