Well I suppose if we have a row then we might be able to get somewhere but if we have an array of an array of items that is different....

Does the following help:

$QueryResults.Count

as it is just an array of objects?

Edit: Because everyone makes mistakes 😉

What is the type of $QueryResults? It should be available by typing:

$QueryResults.GetType().FullName

I am sorry but I am away from SQL Server access but isn't the following valid:

$QueryResults.Columns.Count

This year I had the oddest holiday experience: finding out that my first QOTD was being issued whilst abroad with intermittent Internet access. I was really pleased that I had,...

Andy sql (7/24/2014)

---

I find testing code, which I have not written, incredibly frustrating and fruitless. I'm sure I could learn better unit-testing skills, and ways of writing better test scenarios,...

I think that we should be right to consider our instincts. As opposed to using that to override statistical analysis we should use it to question the analysis done and...

ArmenStein (7/23/2014)

---

Is DevOps related to the "engineering approach" that is being considered inside Microsoft right now?

This is from a news article about the upcoming layoffs, including a quote from Satya...

RonKyle (7/23/2014)

---

You never talked with me when...

TomThomson (7/23/2014)

---

I rather agree with Patrick's comment above - but I read the rubbish and got steadily more appalled as I went through it. A (Python) Programmer is apparently...

Maybe it is me but I think that Jeff Knupps is missing the point of the "DevOps" movement. In the same paragraph that he states

"DevOps" is meant to denote...

...it's the oracle I'd prefer access to 😛

GoofyGuy (7/22/2014)

---

Ron Kyle Wrote:

... using [VB/SQL] would be like shooting a squirrel with a bazooka. It's overkill.

But entirely legal in several states. Besides, I hate it when those squirrels...

I try to pay it forward (or is that repay it - I don't know because I cannot be bothered to keep track but if you have ever helped me...

Perhaps some kind of deprecation warning (with the ability to locally disable - equivalent of an old C styled # command) would be beneficial for script updates. I completely agree...