다음을 통해 공유

Powershell4SQL

  • 아티클

Today I published my new project on Codeplex.

 

It adds adds an ability execute T-SQl queries directly from Powershell console, so you no longer have to rely on sqlcmd

 

https://powershell4sql.codeplex.com/

 

There are 2 Cmdlets:

 

Invoke-SqlQuery and New-SqlConnection

 

Invoke-SqlQuery supports queries as string, .sql files, parameterized queries, etc.

 

The biggest advantage of Invoke-SqlQuery is that it returns strongly types results, not strings, and accepts strongly typed arguments for parameterized query – no more conversion in and out of strings.

Please take a look