Using T-SQL over PoSh

Question

Using T-SQL over PoSh

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

skeleton567 wrote:

Jeff Moden wrote:
My two favorite questions are becoming...
Is there a reason why this MUST be done in PowerShell?
Is there a reason why this MUST be done in Python?
My questions are:
Is the job done?
Are the results what is needed?

If you read the rest of the post where you got the quote from, the answers to both of those questions is a resounding NO. 😀

The reason why is because they don't know the tool they've chosen, either. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ZZartin SSC-Dedicated Points: 30894 More actions · Answer 2

Jeff Moden wrote:

Except for the errors they still have and the missing functionality it still has, it does the same thing as BULK INSERT except slower.

It amazing how many people don't know you can call bcp from powershell or pretty much any other language, or just don't trust it for some reason.

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

ZZartin wrote:

Jeff Moden wrote:
Except for the errors they still have and the missing functionality it still has, it does the same thing as BULK INSERT except slower.
It amazing how many people don't know you can call bcp from powershell or pretty much any other language, or just don't trust it for some reason.

I guess I don't know why folks would call BCP from PowerShell to begin with. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)