Why Gemfury?
Push, build, and install
RubyGems
npm packages
Python packages
Maven artifacts
PHP packages
Go Modules
Debian packages
RPM packages
NuGet packages
doctorondemand
doctorondemand / Pygments python
Repository URL to install this package:
|
Version:
2.5.0 ▾
|
]q (cpygments.token
_TokenType
qX CommentqX Multilineqq
qq}q(X subtypesqcbuiltins
set
q ]q
q Rq X parentq
hh
q
qq}q(hh ]q(hhX Preprocqq
qq}q(hh ]q
qRqh
hubhhX Multiqq
q q }q (hh ]q
q!Rq"h
hubhhX Hashbangq#q$
q%q&}q'(hh ]q(
q)Rq*h
hubhhX Singleq+q,
q-q.}q/(hh ]q0
q1Rq2h
hubhhX
SingleLineq3q4
q5q6}q7(hh ]q8
q9Rq:h
hubhhX Docq;q<
q=q>}q?(hh ]q@
qARqBh
hubhhX DirectiveqCqD
qEqF}qG(hh ]qH
qIRqJh
hubhhhX
SinglelineqKqL
qMqN}qO(hh ]qP
qQRqRh
hubhhX PreprocFileqSqT
qUqV}qW(hh ]qX
qYRqZh
hubhhX Specialq[q\
q]q^}q_(hh ]q`
qaRqbh
hube
qcRqdh
h)
qeqf}qg(hh ]qh(hX Escapeqi
qj
qkql}qm(hh ]qn
qoRqph
hfubhX Operatorqq
qr
qsqt}qu(hh ]qv(hhqX DBSqwqx
qyqz}q{(hh ]q|
q}Rq~h
htubhhqX Wordqq
qq}q(hh ]q
q
Rqh
htube
qRqh
hfhhhwhzubhX Nameq
q
qq}q(hh ]q(hhX Tagqq
qq}q(hh ]q
qRqh
hubhhX Entityqq
qq}q(hh ]qhhhhwq
qq}q (hh ]q¡
q¢Rq£h
huba
q¤Rq¥h
hhwhubhhX Exceptionq¦q§
q¨q©}qª(hh ]q«
q¬Rqh
hubhhX Decoratorq®q¯
q°q±}q²(hh ]q³
q´Rqµh
hubhhX Classq¶q·
q¸q¹}qº(hh ]q»(hhh¶hwq¼
q½q¾}q¿(hh ]qqÁRqÂh
h¹ubhhh¶X StartqÇqąqŁqÆ}qÇ(hh ]qȅqÉRqÊh
h¹ube
qËRqÌh
hhÃhÆhwh¾ubhhX Variableq͆q΅qρqÐ}qÑ(hh ]qÒ(hhhÍX AnonymousqӇqԅqՁqÖ}q×(hh ]qqÙRqÚh
hÐubhhhÍh¶qۅq܁qÝ}qÞ(hh ]q߅qàRqáh
hÐubhhhÍX Magicqâqã
qäqå}qæ(hh ]qç
qèRqéh
hÐubhhhÍX Globalqêqë
qìqí}qî(hh ]qï
qðRqñh
hÐubhhhÍX Instanceqòqó
qôqõ}qö(hh ]q÷
qøRqùh
hÐube
qúRqûh
hh¶hÝhêhíhòhõhâhåhÓhÖubhhX Attributeqüqý
qþqÿ}r (hh ]r hhhüh͇r
r r }r (hh ]r
r Rr h
hÿuba
r Rr
h
hhÍj ubhhX Namespacer r
r
r }r (hh ]r
r Rr h
hubhhX Propertyr r
r r }r (hh ]r
r Rr h
hubhhX Symbolr r
r r }r (hh ]r
r! Rr" h
hubhhX Classesr# r$
r% r& }r' (hh ]r(
r) Rr* h
hubhhX Pseudor+ r,
r- r. }r/ (hh ]r0
r1 Rr2 h
hubhhX Labelr3 r4
r5 r6 }r7 (hh ]r8
r9 Rr: h
hubhhhqr;
r< r= }r> (hh ]r?
r@ RrA h
hubhhX BuiltinrB rC
rD rE }rF (hh ]rG (hhjB j+ rH
rI rJ }rK (hh ]rL
rM RrN h
jE ubhhjB X TyperO rP
rQ rR }rS (hh ]rT
rU RrV h
jE ube
rW RrX h
hj+ jJ jO jR ubhhX FieldrY rZ
r[ r\ }r] (hh ]r^
r_ Rr` h
hubhhX Otherra rb
rc rd }re (hh ]rf hhja X Memberrg rh
ri rj }rk (hh ]rl
rm Rrn h
jd uba
ro Rrp h
hjg jj ubhhX Functionrq rr
rs rt }ru (hh ]rv hhjq hârw
rx ry }rz (hh ]r{
r| Rr} h
jt uba
r~ Rr h
hhâjy ubhhjO r
r r }r (hh ]r
r
Rr h
hubhhX Constantr r
r r }r (hh ]r
r Rr h
hube
r Rr h
hfhühÿjB jE h¶h¹j j h®h±hhh¦h©jq jt j j j3 j6 j j ja jd hhhÍhÐjY j\ j j j+ j. hqj= j# j& jO j ubhX Literalr
r
r r }r (hh ]r (hj ja r
r r }r (hh ]r
r Rr h
j ubhj X Charr r
r r¡ }r¢ (hh ]r£
r¤ Rr¥ h
j ubhj X Dater¦ r§
r¨ r© }rª (hh ]r«
r¬ Rr h
j ubhj X Scalarr® r¯
r° r± }r² (hh ]r³ hj j® X Plainr´ rµ
r¶ r· }r¸ (hh ]r¹
rº Rr» h
j± uba
r¼ Rr½ h
j j´ j· ubhj X Stringr¾ r¿
rÀ rÁ }r (hh ]rà (hj j¾ X InterpolrÄ rÅ
rÆ rÇ }rÈ (hh ]rÉ
rÊ RrË h
jÁ ubhj j¾ X DelimeterrÌ rÍ
rÎ rÏ }rÐ (hh ]rÑ
rÒ RrÓ h
jÁ ubhj j¾ j rÔ
rÕ rÖ }r× (hh ]rØ
rÙ RrÚ h
jÁ ubhj j¾ j rÛ
rÜ rÝ }rÞ (hh ]rß
rà Rrá h
jÁ ubhj j¾ h+râ
rã rä }rå (hh ]ræ
rç Rrè h
jÁ ubhj j¾ ja ré
rê rë }rì (hh ]rí
rî Rrï h
jÁ ubhj j¾ X Backtickrð rñ
rò ró }rô (hh ]rõ
rö Rr÷ h
jÁ ubhj j¾ hirø
rù rú }rû (hh ]rü
rý Rrþ h
jÁ ubhj j¾ X Regexrÿ r
r r }r (hh ]r
r Rr h
jÁ ubhj j¾ X Momentr r
r r
}r (hh ]r
r
Rr h
jÁ ubhj j¾ X Booleanr r
r r }r (hh ]r
r Rr h
jÁ ubhj j¾ X Characterr r
r r }r (hh ]r
r Rr h
jÁ ubhj j¾ X Delimiterr r
r! r" }r# (hh ]r$
r% Rr& h
jÁ ubhj j¾ h;r'
r( r) }r* (hh ]r+
r, Rr- h
jÁ ubhj j¾ hr.
r/ r0 }r1 (hh ]r2
r3 Rr4 h
jÁ ubhj j¾ X Affixr5 r6
r7 r8 }r9 (hh ]r:
r; Rr< h
jÁ ubhj j¾ X Heredocr= r>
r? r@ }rA (hh ]rB
rC RrD h
jÁ ubhj j¾ X DoublerE rF
rG rH }rI (hh ]rJ
rK RrL h
jÁ ubhj j¾ X InterprM rN
rO rP }rQ (hh ]rR
rS RrT h
jÁ ubhj j¾ X AtomrU rV
rW rX }rY (hh ]rZ
r[ Rr\ h
jÁ ube
r] Rr^ h
j j5 j8 jð jó j jÖ j j" h;j) jE jH hijú j= j@ jÄ jÇ ja jë jÿ j h+jä j jÝ j j j j
jM jP j j jÌ jÏ jU jX hj0 ubhj X Numberr_ r`
ra rb }rc (hh ]rd (hj j_ X Floatre rf
rg rh }ri (hh ]rj
rk Rrl h
jb ubhj j_ X Decrm rn
ro rp }rq (hh ]rr
rs Rrt h
jb ubhj j_ X Radixru rv
rw rx }ry (hh ]rz
r{ Rr| h
jb ubhj j_ X Octr} r~
r r }r (hh ]r
r Rr h
jb ubhj j_ X Binr
r
r r }r (hh ]r
r Rr h
jb ubhj j_ hür
r r }r (hh ]r
r Rr h
jb ubhj j_ X Hexr r
r r }r (hh ]r
r Rr h
jb ubhj j_ X Integerr r
r r }r (hh ]r¡ h(j j_ j X Longr¢ tr£
r¤ r¥ }r¦ (hh ]r§
r¨ Rr© h
j uba
rª Rr« h
jb j¢ j¥ ubhj j_ X Decimalr¬ r
r® r¯ }r° (hh ]r±
r² Rr³ h
jb ube
r´ Rrµ h
j j
j je jh j j j j j} j ju jx hüj j¬ j¯ jm jp ube
r¶ Rr· h
hfj¾ jÁ j_ jb j¦ j© j® j± ja j j j¡ ubhX Genericr¸
r¹
rº r» }r¼ (hh ]r½ (hj¸ X Errorr¾ r¿
rÀ rÁ }r (hh ]rÃ
rÄ RrÅ h
j» ubhj¸ X
SubheadingrÆ rÇ
rÈ rÉ }rÊ (hh ]rË
rÌ RrÍ h
j» ubhj¸ X TracebackrÎ rÏ
rÐ rÑ }rÒ (hh ]rÓ
rÔ RrÕ h
j» ubhj¸ X OutputrÖ r×
rØ rÙ }rÚ (hh ]rÛ
rÜ RrÝ h
j» ubhj¸ X PromptrÞ rß
rà rá }râ (hh ]rã
rä Rrå h
j» ubhj¸ X Deletedræ rç
rè ré }rê (hh ]rë
rì Rrí h
j» ubhj¸ X Insertedrî rï
rð rñ }rò (hh ]ró
rô Rrõ h
j» ubhj¸ X Headingrö r÷
rø rù }rú (hh ]rû
rü Rrý h
j» ubhj¸ X Strongrþ rÿ
r r }r (hh ]r
r Rr h
j» ubhj¸ X Emphr r
r r }r
(hh ]r
r Rr
h
j» ube
r Rr h
hfjæ jé j j j¾ jÁ jö jù jî jñ jÖ jÙ jÞ já jþ j jÆ jÉ jÎ jÑ ubhj¾
r
r r }r (hh ]r
r Rr h
hfubhX Keywordr
r
r r }r (hh ]r (hj hr
r r }r (hh ]r!
r" Rr# h
j ubhj j r$
r% r& }r' (hh ]r(
r) Rr* h
j ubhj jO r+
r, r- }r. (hh ]r/
r0 Rr1 h
j ubhj X PreProcr2 r3
r4 r5 }r6 (hh ]r7
r8 Rr9 h
j ubhj X Controlr: r;
r< r= }r> (hh ]r?
r@ RrA h
j ubhj j rB
rC rD }rE (hh ]rF
rG RrH h
j ubhj j rI
rJ rK }rL (hh ]rM
rN RrO h
j ubhj j+ rP
rQ rR }rS (hh ]rT
rU RrV h
j ubhj X DeclarationrW rX
rY rZ }r[ (hh ]r\
r] Rr^ h
j ubhj X Reservedr_ r`
ra rb }rc (hh ]rd
re Rrf h
j ube
rg Rrh h
hfj jD jW jZ j jK j+ jR j_ jb jO j- j: j= j j& j2 j5 hj ubhja
ri
rj rk }rl (hh ]rm
rn Rro h
hfubhX Textrp
rq
rr rs }rt (hh ]ru (hjp X Rootrv rw
rx ry }rz (hh ]r{
r| Rr} h
js ubhjp j r~
r r }r (hh ]r
r Rr h
js ubhjp X Ragr
r
r r }r (hh ]r
r Rr h
js ubhjp X
Whitespacer r
r r }r (hh ]r
r Rr h
js ubhjp X Beerr r
r r }r (hh ]r
r Rr h
js ubhjp X Punctuationr r
r r }r¡ (hh ]r¢
r£ Rr¤ h
js ube
r¥ Rr¦ h
hfj j j j j j jv jy j j j
j ubhhj
r§
r¨ r© }rª (hh ]r« hj X Indicatorr¬ r
r® r¯ }r° (hh ]r±
r² Rr³ h
j© uba
r´ Rrµ h
hfj¬ j¯ ube
r¶ Rr· jp js hihlj¾ j ja jk j j hhj j j j© hqhthhj¸ j» X Tokenr¸ hfj¾ jÁ j_ jb ubh#h&hhhhhShVh+h.h[h^hChFh3h6h;h>hh hKhNububX <#r¹ rº hX
r» r¼ j) X .SYNOPSISr½ r¾ hXD
Runs a T-SQL Query and optional outputs results to a delimited filer¿ rÀ hX .rÁ r hj» rà j) X .DESCRIPTIONrÄ rÅ hXe
Invoke-Sql script will run a T-SQL query or stored procedure and optionally outputs a delimited filerÆ rÇ hjÁ rÈ hj» rÉ j) X .EXAMPLErÊ rË hX
PowerShellrÌ rÍ hjÁ rÎ hX exe -File "C:\Scripts\Invoke-SqlrÏ rÐ hjÁ rÑ hX ps1" -ServerInstance "Z003\sqlprod2" -Database orders -Query "EXEC usp_accounts '12445678'"
This example connects to Z003\sqlprod2rÒ rÓ hjÁ rÔ hXJ Orders and executes a stored procedure which does not return a result set
rÕ rÖ j) X .EXAMPLEr× rØ hX
PowerShellrÙ rÚ hjÁ rÛ hX exe -File "C:\Scripts\Invoke-SqlrÜ rÝ hjÁ rÞ hXO ps1" -ServerInstance "Z003\sqlprod2" -Database orders -Query "SELECT * FROM dborß rà hjÁ rá hX( accounts" -FilePath "C:\Scripts\accountsrâ rã hjÁ rä hX: txt" -Delimiter ","
This example connects to Z003\sqlprod2rå ræ hjÁ rç hX\ Orders and selects the records from the accounts tables, the data is outputed to a CSV file
rè ré j) X .NOTESrê rë hX
Version History
v1rì rí hjÁ rî hXÕ 0 - Chad Miller - 12/14/2010 - Initial release
IMPORTANT!!! The EventLog source which is set to the application needs to be registered with
the Event log:
New-EventLog -LogName Application -Source $Application
rï rð hX #>rñ rò js j» ró j X paramrô rõ j© X (rö r÷ js j» rø hX #ServerInstance is Mandatory!rù rú js j» rû j© X [rü rý j X Parameterrþ rÿ j© jö r j X Positionr r j© X =r r hX 0r r j© X ,r r js X r r
j X Mandatoryr r j© j r
hÐX $falser r j© X )r r j© X ]r r js j r j X [string]r r hÐX $ServerInstancer r j© j r js j» r hX #Database is Mandatory!r r js j» r j© jü r j X Parameterr r j© jö r! j X Positionr" r# j© j r$ hX 1r% r& j© j r' js j r( j X Mandatoryr) r* j© j r+ hÐX $falser, r- j© j r. j© j r/ js j r0 j X [string]r1 r2 hÐX $Databaser3 r4 j© j r5 js j» r6 hX #Query is Mandatory!r7 r8 js j» r9 j© jü r: j X Parameterr; r< j© jö r= j X Positionr> r? j© j r@ hX 2rA rB j© j rC js j rD j X MandatoryrE rF j© j rG hÐX $falserH rI j© j rJ j© j rK js j rL j X [string]rM rN hÐX $QueryrO rP j© j rQ js j» rR j© jü rS j X ParameterrT rU j© jö rV j X PositionrW rX j© j rY hX 3rZ r[ j© j r\ js j r] j X Mandatoryr^ r_ j© j r` hÐX $falsera rb j© j rc j© j rd js j re j X [string]rf rg hÐX $Applicationrh ri j© j rj jH X "rk rl jH X Invoke-Sql.ps1rm rn jH jk ro j© j rp js j» rq j© jü rr j X Parameterrs rt j© jö ru j X Positionrv rw j© j rx hX 4ry rz j© j r{ js j r| j X Mandatoryr} r~ j© j r hÐX $falser r j© j r j© j r js j r j X [string]r
r hÐX $FilePathr r j© j r js j» r j© jü r j X Parameterr r j© jö r j X Positionr r j© j r hX 7r r j© j r js j r j X Mandatoryr r j© j r hÐX $falser r j© j r j© j r js j r j X [string]r r hÐX
$Delimiterr r¡ j© j r¢ jH jk r£ jH X |r¤ r¥ jH jk r¦ j© j r§ js j» r¨ hX= #If UserName isn't supplied a trusted connection will be usedr© rª js j» r« j© jü r¬ j X Parameterr r® j© jö r¯ j X Positionr° r± j© j r² hX 5r³ r´ j© j rµ js j r¶ j X Mandatoryr· r¸ j© j r¹ hÐX $falserº r» j© j r¼ j© j r½ js j r¾ j X [string]r¿ rÀ hÐX $UserNamerÁ r j© j rà js j» rÄ j© jü rÅ j X ParameterrÆ rÇ j© jö rÈ j X PositionrÉ rÊ j© j rË hX 6rÌ rÍ j© j rÎ js j rÏ j X MandatoryrÐ rÑ j© j rÒ hÐX $falserÓ rÔ j© j rÕ j© j rÖ js j r× j X [string]rØ rÙ hÐX $PasswordrÚ rÛ j© j rÜ js j» rÝ j© jü rÞ j X Parameterrß rà j© jö rá j X Positionrâ rã j© j rä hX 8rå ræ j© j rç js j rè j X Mandatoryré rê j© j rë hÐX $falserì rí j© j rî j© j rï js j rð j X [Int32]rñ rò hÐX
$QueryTimeoutró rô j© j rõ hX 600rö r÷ j© j rø js j» rù j© jü rú j X Parameterrû rü j© jö rý j X Positionrþ rÿ j© j r hX 9r r j© j r js j r j X Mandatoryr r j© j r hÐX $falser r j© j r
j© j r js j r j X [Int32]r
r hÐX $ConnectionTimeoutr r j© j r hX 15r r js j» r j© j r js X
r r hX> #This must be run as administrator on Windows 2008 and higher!r r js j» r jE X New-EventLogr r js j r hX -LogNamer r js j r hX Applicationr! r" js j r# hX -Sourcer$ r% js j r& hÐX $Applicationr' r( js j r) hX -EAr* r+ js j r, hX SilentlyContinuer- r. js j» r/ hÐX $Errorr0 r1 j© jÁ r2 hX Clearr3 r4 j© jö r5 j© j r6 js X
r7 r8 hX #######################r9 r: js j» r; j X functionr< r= js j r> jE X Invoke-SqlCmd2r? r@ js j» rA j© X {rB rC js X
rD rE j X paramrF rG j© jö rH js X
rI rJ j© jü rK j X ParameterrL rM j© jö rN j X PositionrO rP j© j rQ hj rR j© j rS js j rT j X MandatoryrU rV j© j rW hÐX $truerX rY j© j rZ j© j r[ js j r\ j X [string]r] r^ hÐX $ServerInstancer_ r` j© j ra js X
rb rc j© jü rd j X Parameterre rf j© jö rg j X Positionrh ri j© j rj hj% rk j© j rl js j rm j X Mandatoryrn ro j© j rp hÐX $truerq rr j© j rs j© j rt js j ru j X [string]rv rw hÐX $Databaserx ry j© j rz js X
r{ r| j© jü r} j X Parameterr~ r j© jö r j X Positionr r j© j r hjA r j© j r
js j r j X Mandatoryr r j© j r hÐX $truer r j© j r j© j r js j r j X [string]r r hÐX $Queryr r j© j r js X
r r j© jü r j X Parameterr r j© jö r j X Positionr r j© j r hjZ r j© j r js j r j X Mandatoryr r¡ j© j r¢ hÐX $falser£ r¤ j© j r¥ j© j r¦ js j r§ j X [string]r¨ r© hÐX $UserNamerª r« j© j r¬ js X
r r® j© jü r¯ j X Parameterr° r± j© jö r² j X Positionr³ r´ j© j rµ hjy r¶ j© j r· js j r¸ j X Mandatoryr¹ rº j© j r» hÐX $falser¼ r½ j© j r¾ j© j r¿ js j rÀ j X [string]rÁ r hÐX $Passwordrà rÄ j© j rÅ js X
rÆ rÇ j© jü rÈ j X ParameterrÉ rÊ j© jö rË j X PositionrÌ rÍ j© j rÎ hj³ rÏ j© j rÐ js j rÑ j X MandatoryrÒ rÓ j© j rÔ hÐX $falserÕ rÖ j© j r× j© j rØ js j rÙ j X [Int32]rÚ rÛ hÐX
$QueryTimeoutrÜ rÝ j© j rÞ js X
rß rà j© jü rá j X Parameterrâ rã j© jö rä j X Positionrå ræ j© j rç hjÌ rè j© j ré js j rê j X Mandatoryrë rì j© j rí hÐX $falserî rï j© j rð j© j rñ js j rò j X [Int32]ró rô hÐX $ConnectionTimeoutrõ rö js X
r÷ rø j© j rù js X
rú rû j X tryrü rý js j rþ j© jB rÿ js X
r r j X ifr r js j r j© jö r hÐX $Usernamer r j© j r js X
r r
j© jB r js j r hÐX $ConnectionStringr
r js j r j© j r js j r jH jk r jH X] Server={0};Database={1};User ID={2};Password={3};Trusted_Connection=False;Connect Timeout={4}r r jH jk r js j r htX -fr r js j r hÐX $ServerInstancer r j© j r hÐX $Databaser r j© j r hÐX $Usernamer r! j© j r" hÐX $Passwordr# r$ j© j r% hÐX $ConnectionTimeoutr& r' js j r( j© X }r) r* js X
r+ r, j X elser- r. js X
r/ r0 j© jB r1 js j r2 hÐX $ConnectionStringr3 r4 js j r5 j© j r6 js j r7 jH jk r8 jH XD Server={0};Database={1};Integrated Security=True;Connect Timeout={2}r9 r: jH jk r; js j r< htX -fr= r> js j r? hÐX $ServerInstancer@ rA j© j rB hÐX $DatabaserC rD j© j rE hÐX $ConnectionTimeoutrF rG js j rH j© j) rI js X
rJ rK hÐX $connrL rM j© j rN jE X
new-objectrO rP js j rQ hX SystemrR rS j© jÁ rT hX DatarU rV j© jÁ rW hX SqlClientrX rY j© jÁ rZ hX
SQLConnectionr[ r\ js X
r] r^ hÐX $connr_ r` j© jÁ ra hX ConnectionStringrb rc j© j rd hÐX $ConnectionStringre rf js X
rg rh hÐX $connri rj j© jÁ rk hX Openrl rm j© jö rn j© j ro js X
rp rq hÐX $cmdrr rs j© j rt jE X
new-objectru rv js j rw hX systemrx ry j© jÁ rz hX Datar{ r| j© jÁ r} hX SqlClientr~ r j© jÁ r hX
SqlCommandr r j© jö r hÐX $Queryr r
j© j r hÐX $connr r j© j r js X
r r hÐX $cmdr r j© jÁ r hX CommandTimeoutr r j© j r hÐX
$QueryTimeoutr r js X
r r hÐX $dsr r j© j r jE X
New-Objectr r js j r hX systemr r j© jÁ r hX Datar r j© jÁ r¡ hX DataSetr¢ r£ js X
r¤ r¥ hÐX $dar¦ r§ j© j r¨ jE X
New-Objectr© rª js j r« hX systemr¬ r j© jÁ r® hX Datar¯ r° j© jÁ r± hX SqlClientr² r³ j© jÁ r´ hX SqlDataAdapterrµ r¶ j© jö r· hÐX $cmdr¸ r¹ j© j rº js X
r» r¼ j X [void]r½ r¾ hÐX $dar¿ rÀ j© jÁ rÁ hX fillr rà j© jö rÄ hÐX $dsrÅ rÆ j© j rÇ js X
rÈ rÉ jE X Write-OutputrÊ rË js j rÌ j© jö rÍ hÐX $dsrÎ rÏ j© jÁ rÐ hX TablesrÑ rÒ j© jü rÓ hj rÔ j© j rÕ j© j rÖ js X
r× rØ j© j) rÙ js X
rÚ rÛ j X finallyrÜ rÝ js j rÞ j© jB rß js X
rà rá hÐX $connrâ rã j© jÁ rä hX Disposerå ræ j© jö rç j© j rè js X
ré rê j© j) rë js X
rì rí j© j) rî js j rï hX #Invoke-SqlCmd2rð rñ js X
rò ró hX #######################rô rõ js j» rö hX # MAIN #r÷ rø js j» rù hX #######################rú rû js j» rü j X ifrý rþ js j rÿ j© jö r hÐX $PSBoundParametersr r j© jÁ r hX Countr r js j r htX -eqr r js j r hj r
j© j r js j» r j© jB r
js X
r r jE X get-helpr r js j r hÐX
$myInvocationr r j© jÁ r hX MyCommandr r j© jÁ r hX Pathr r js j r hX -fullr r js X
r r j X breakr r! js j» r" j© j) r# js X
r$ r% j X tryr& r' js j r( j© jB r) js X
r* r+ hÐX $msgr, r- js j r. j© j r/ js j r0 hÐX $nullr1 r2 js X
r3 r4 hÐX $msgr5 r6 js j r7 j© X +r8 r9 j© j r: js j r; jH jk r< jH X Application/Job Name: r= r> jH X $r? r@ jH X ApplicationrA rB jú X `nrC rD jH jk rE js X
rF rG hÐX $msgrH rI js j rJ j© j8 rK j© j rL js j rM jH jk rN jH X Query: rO rP jH j? rQ jH X QueryrR rS jú X `nrT rU jH jk rV js X
rW rX hÐX $msgrY rZ js j r[ j© j8 r\ j© j r] js j r^ jH jk r_ jH X ServerInstance: r` ra jH j? rb jH X ServerInstancerc rd jú X `nre rf jH jk rg js X
rh ri hÐX $msgrj rk js j rl j© j8 rm j© j rn js j ro jH jk rp jH X
Database: rq rr jH j? rs jH X Databasert ru jú X `nrv rw jH jk rx js X
ry rz hÐX $msgr{ r| js j r} j© j8 r~ j© j r js j r jH jk r jH X
FilePath: r r jH j? r jH X FilePathr
r jú X `nr r jH jk r js X
r r jE X Write-EventLogr r js j r hX -LogNamer r js j r hX Applicationr r js j r hX -Sourcer r js j r jH jk r jH j? r jH X Applicationr r jH jk r js j r hX
-EntryTyper r js j r hX Informationr¡ r¢ js j r£ hX -EventIdr¤ r¥ js j r¦ hX 12345r§ r¨ js j r© hX -Messagerª r« js j r¬ jH jk r jH X Startingr® r¯ jú X `nr° r± jH j? r² jH X msgr³ r´ jH jk rµ js X
r¶ r· hÐX $dtr¸ r¹ js j rº j© j r» js j r¼ jE X Invoke-SqlCmd2r½ r¾ js j r¿ hX -ServerInstancerÀ rÁ js j r hÐX $ServerInstancerà rÄ js j rÅ hX -DatabaserÆ rÇ js j rÈ hÐX $DatabaserÉ rÊ js j rË hX -QueryrÌ rÍ js j rÎ hÐX $QueryrÏ rÐ js j rÑ hX -UserNamerÒ rÓ js j rÔ hÐX $UserNamerÕ rÖ js j r× hX -PasswordrØ rÙ js j rÚ hÐX $PasswordrÛ rÜ js j rÝ hX
-QueryTimeOutrÞ rß js j rà hÐX
$QueryTimeOutrá râ js j rã hX -ConnectionTimeouträ rå js j ræ hÐX $ConnectionTimeoutrç rè js X
ré rê j X ifrë rì js j rí j© jö rî hÐX $FilePathrï rð j© j rñ js X
rò ró j© jB rô js X
rõ rö j X ifr÷ rø js j rù j© jö rú hÐX $dtrû rü j© j rý js X
rþ rÿ j© jB r js j r hÐX $dtr r js j r j© j¤ r js j r jE X
export-csvr r js j r hX
-Delimiterr
r js j r hÐX
$Delimiterr
r js j r hX -Pathr r js j r hÐX $FilePathr r js j r hX -NoTypeInformationr r js j r j© j) r js X
r r j X elser r js j r hX #Query Returned No Output!r r js X
r! r" j© jB r# jE X Write-EventLogr$ r% js j r& hX -LogNamer' r( js j r) hX Applicationr* r+ js j r, hX -Sourcer- r. js j r/ jH jk r0 jH j? r1 jH X Applicationr2 r3 jH jk r4 js j r5 hX
-EntryTyper6 r7 js j r8 hX Warningr9 r: js j r; hX -EventIdr< r= js j r> hX 12345r? r@ js j rA hX -MessagerB rC js j rD jH jk rE jH X NoOutputrF rG jú X `nrH rI jH j? rJ jH X msgrK rL jH jk rM js j rN j© j) rO js X
rP rQ j© j) rR js X
rS rT jE X Write-EventLogrU rV js j rW hX -LogNamerX rY js j rZ hX Applicationr[ r\ js j r] hX -Sourcer^ r_ js j r` jH jk ra jH j? rb jH X Applicationrc rd jH jk re js j rf hX
-EntryTyperg rh js j ri hX Informationrj rk js j rl hX -EventIdrm rn js j ro hX 12345rp rq js j rr hX -Messagers rt js j ru jH jk rv jH X Completedrw rx jú X `nry rz jH j? r{ jH X msgr| r} jH jk r~ js j» r j© j) r js j» r j X catchr r js j r j© jB r
js X
r r hÐX
$Exceptionr r js j r j© j r js j r jH jk r jH X {0}, {1}r r jH jk r js j r htX -fr r js X r r hÐX $_r r j© jÁ r hX Exceptionr r j© jÁ r hX GetTyper r j© jö r j© j r j© jÁ r hX FullNamer¡ r¢ j© j r£ j© j? r¤ j© jö r¥ js j r¦ hÐX $_r§ r¨ j© jÁ r© hX Exceptionrª r« j© jÁ r¬ hX Messager r® js j r¯ htX -replacer° r± js j r² jH jk r³ jH X 'r´ rµ jH jk r¶ js j r· j© j r¸ js X
r¹ rº jE X Write-EventLogr» r¼ js j r½ hX -LogNamer¾ r¿ js j rÀ hX ApplicationrÁ r js j rà hX -SourcerÄ rÅ js j rÆ jH jk rÇ jH j? rÈ jH X ApplicationrÉ rÊ jH jk rË js j rÌ hX
-EntryTyperÍ rÎ js j rÏ hX ErrorrÐ rÑ js j rÒ hX -EventIdrÓ rÔ js j rÕ hX 12345rÖ r× js j rØ hX -MessagerÙ rÚ js j rÛ jH jk rÜ jH X ErrorrÝ rÞ jú X `nrß rà jH j? rá jH X msgrâ rã jú X `nrä rå jH j? ræ jH X Exceptionrç rè jH jk ré js X
rê rë j X throwrì rí js j» rî j© j) rï js j» rð e.