<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Vernon Cole wrote:
<blockquote
cite="mid:b7eb4a700905260055k19964dc9ra406204b08ad8ef7@mail.gmail.com"
type="cite">
<pre wrap="">
In this case, the proceedure outputs TWO record sets, since there are
two SELECT statements.
If the second select statement, "select @param = 10" were changed to
"SET @param = 10" then, I believe, the result
would have been as expected.
</pre>
</blockquote>
Vernon, thanks for your comments.<br>
<br>
In SQL Server, there is no recordset output for:<br>
<blockquote><tt>select @param = 10<br>
</tt></blockquote>
its simply a variable assignment. You can verify this by doing the
following in a TSQL or Query Analyzer session:<br>
<blockquote><tt>declare @param int<br>
select @param = 1<br>
</tt></blockquote>
You should see that no resultset is returned.<br>
<br>
<blockquote
cite="mid:b7eb4a700905260055k19964dc9ra406204b08ad8ef7@mail.gmail.com"
type="cite">
<pre wrap="">
Having said all that, I ran Randy's test program using pywin32 v213 on
Python 2.6 and Vista, and it ran correctly.
</pre>
</blockquote>
Really! I did a fresh install of 2.6 and win32 extensions on vista
just to verify this and I still got an error. Vernon, so you got a
message from nose that two tests passed? Can anyone else verify this?<br>
<br>
<pre class="moz-signature" cols="72">--------------------------------------
Randy Syring
RCS Computers & Web Solutions
502-644-4776
<a class="moz-txt-link-freetext" href="http://www.rcs-comp.com">http://www.rcs-comp.com</a>
"Whether, then, you eat or drink or
whatever you do, do all to the glory
of God." 1 Cor 10:31
</pre>
</body>
</html>