Export data in any way with IntelliJ-based IDEs

https://blog.jetbrains.com/datagrip/2017/11/08/export-data-in-any-way-with-intellij-based-ides/

Iarna trecuta am facut un mic script in Powershell pt export in csv :slight_smile:

Set-ExecutionPolicy Unrestricted -Scope CurrentUser
Import-Module SqlServer

$server = "server bd"
$exportCsv = "unde vrei sa fie exportat fisierul"

Invoke-Sqlcmd -ServerInstance $server -Database "baza ta de date" -Username "" -Password '' -Query "procedura stocata" | Export-Csv -Path $exportCsv -Delimiter "

Varianta cu citire de la tastatura

Set-ExecutionPolicy Unrestricted -Scope CurrentUser
Import-Module SqlServer

$server = ""
$exportCsv = ""
$ceVreiSaCitestiDeLaKb = Read-Host -Prompt ""


Invoke-Sqlcmd -ServerInstance $server -Database ""  -Username "" -Password '' -Query "EXEC myUSP @param1Sp = $ceVreiSaCitestiDeLaKb, @param2 = $param2" | Export-Csv -Path $exportCsv -Delimiter ","

@iamntz sper ca este voie sa share-uim snippet-uri de cod ?

Vad ca esti mare fan PoweShell, m-am jucat si eu dar nu pot zice ca is expert.

1 Like

Doar niste scriptulețe pt o treaba rapida la serviciu
:slight_smile:

Chiar sunteți încurajați :slight_smile:

2 Likes