12/30/10

Happy New Year!

Translations by Google Translate API.

LanguageTranslationPhonetic Pronunciation
AfrikaansVoorspoedige Nuwe Jaar!
AlbanianGëzuar Vitin e Ri!
Arabicسنة جديدة سعيدة
ArmenianՇնորհավոր Նոր ՏարիShnorhavor Nor Tari
BelarusianЗ Новым годам!Z Novym hodam!
BulgarianЧестита Нова Година!Chestita Nova Godina!
CatalanFeliç Any Nou!
Chinese Simplified新年快乐Xīnnián kuàilè!
Chinese Traditional新年快樂Xīnnián kuàilè!
CroatianSretna Nova Godina!
CzechŠťastný Nový Rok!
DanishGodt Nytår!
DutchGelukkig Nieuw Jaar!
EstonianHead uut Aastat!
FilipinoMasaya Bagong Taon!
FinnishHyvää Uutta Vuotta!
FrenchJoyeux Nouvel An!
GalicianFeliz Ano!
GermanGlückliches Neues Jahr!
GreekΕυτυχισμένο το Νέο Έτος!Ef̱tychisméno to Néo Étos
Haitian CreoleKontan Ane Nouvo!
Hebrewשנה טובה
Hindiनया साल मुबारक हो!Nayā sāla mubāraka hō!
HungarianBoldog Új Évet!
IcelandicGleðilegt Nýtt Ár!
IndonesianSelamat Tahun Baru!
IrishAthbhliain faoi mhaise daoibh!
ItalianFelice Anno Nuovo!
Japanese明けましておめでとうございますAkemashite omedetōgozaimasu
Korean새해 복 많이saehae bog manh-i
LatvianLaimīgu Jauno gadu!
LithuanianLaimingų Naujųjų Metų!
MacedonianСреќна Нова Година!Sreḱna Nova Godina!
MalaySelamat Tahun Baru!
MalteseSena l-ġdida Kuntenti!
NorwegianGodt Nytt År!
Persianرسید سال نوی خوشی
PolishSzczęśliwego Nowego Roku!
PortugueseFeliz Ano Novo!
RomanianAn Nou Fericit!
RussianС Новым годом!S Novym godom!
SerbianСрећна Нова година!Srećna Nova godina!
SlovakŠťastný Nový Rok!
SlovenianSrečno novo leto!
SpanishFeliz Año Nuevo!
SwahiliFuraha ya Mwaka Mpya!
SwedishGott Nytt År!
Thaiสวัสดีปีใหม่S̄wạs̄dī pī h̄ım̀
TurkishMutlu yıllar!
UkrainianЗ Новим роком!Z Novym rokom!
VietnameseChúc mừng năm mới
WelshBlwyddyn Newydd Dda!
Yiddishגליקלעך ניו יאָר

12/5/10

SQL Server Command Line Utility - SqlCmd

http://msdn.microsoft.com/en-us/library/ms162773.aspx
path: c:\program files\microsoft sql server\100\tools\binn\sqlcmd.exe

powershell examples
- execute command-line query, connect using SQL Server Authentication
  &sqlcmd -S SERVER -d DB -U LOGIN -P 'PASSWORD' -q 'select getdate()'

- execute command-line query, connect using SQL Server Authentication, password prompt
  &sqlcmd -S SERVER -d DB -U LOGIN -q 'select getdate()'

- execute command-line query, connect using Windows Authentication
  &sqlcmd -S SERVER -d DB -E -q 'select getdate()'
    
- execute sql script file
  &sqlcmd -S SERVER -d DB -E -i x:\sql\script1.sql

- execute all sql script files in a folder
  gci x:\sql\ *.* | %{ &sqlcmd -S SERVER -d DB -E -i $_.fullname }
  
- exit or quit

- command-line options
  [-? show syntax summary]
  [-a packetsize]
  [-A dedicated admin connection]
  [-b On error batch abort]
  [-c cmdend]
  [-C Trust Server Certificate]
  [-d use database name]
  [-e echo input]
  [-E trusted connection]
  [-f <codepage> | i:<codepage>[,o:<codepage>]]
  [-h headers]
  [-H hostname]
  [-i inputfile]
  [-I Enable Quoted Identifiers]
  [-k[1|2] remove[replace] control characters]
  [-l login timeout]
  [-L[c] list servers[clean output]]
  [-m errorlevel]
  [-N Encrypt Connection]
  [-o outputfile]
  [-p[1] print statistics[colon format]]
  [-P password]
  [-q "cmdline query"]
  [-Q "cmdline query" and exit]
  [-r[0|1] msgs to stderr]
  [-R use client regional setting]
  [-s colseparator]
  [-S server]
  [-t query timeout]
  [-u unicode output]
  [-U login id]
  [-v var = "value"...]
  [-V severitylevel]
  [-w screen width]
  [-W remove trailing spaces]
  [-x disable variable substitution]
  [-X[1] disable commands, startup script, enviroment variables [and exit]]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-z new password]
  [-Z new password and exit]