The result in SELECT will not be picked up as long as there is INSERT before that.

[zsong]

For the proc having this pattern:

---

--do insert/update first
INSERT / UPDATE....
...
...

SELECT @variable as VariableName

---

The msnodesql driver doesn't pick up the returned value VariableName. The result set is empty.