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
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
Chiar sunteți încurajați
2 Likes