on 12-22-2014 9:43 AM
Dear All,
Something strange happening with my query template, not sure why. I guess i am missing something here.
Problem statement:
SP with following logic:
Begin
Set @a = (Select.....);
Insert statement;
Select B from xyz;
End
In SQL QT with fixed mode:
Exec SP
I am not able to see result of Select B from.....query, it just gives me a blank Rowsets node. Any pointers??
Thanks in advance.
Best Regards,
Swaroop
Hi Swaroop,
are you getting the column definitions in the rowset?
If yes then it means your select query is returning blank resultset.
Regards,
Rohit Negi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohit,
Just wanted to check if my understanding is correct here.
While we have an insert statement followed by a select one, sql returns
================
"" no of rows affected
================
B
1
--------------------------------
So, it shows the result in SQL but not in MII test query.
I think while creating a Rowsets/Rowset/Row format, it is unable to fit in "No. of rows affected" and hence as the output is not properly formed in mii's understandable format, it gives a blank Rowsets node.
Please let me know if the understanding is correct.
Thanks in advance.
Best Regards,
Swaroop
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.