Technical Blog

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Saturday, 23 April 2011

SQLCMD Syntax

Posted on 11:58 by Unknown
sqlcmd
[-U login id] [-P password] [-S server] [-H hostname]
[-E trusted connection] [-d use database name] [-l login timeout]
[-N encrypt connection] [-C trust the server certificate]
[-t query timeout] [-h headers] [-s colseparator] [-w screen width]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-c cmdend] [-L[c] list servers[clean output]] [-q "cmdline query"]
[-Q "cmdline query" and exit] [-m errorlevel] [-V severitylevel]
[-W remove trailing spaces] [-u unicode output]
[-r[0|1] msgs to stderr] [-i inputfile] [-o outputfile]
[-f | i:[,o:]]
[-k[1|2] remove[replace] control characters]
[-y variable length type display width]
[-Y fixed length type display width]
[-p[1] print statistics[colon format]]
[-R use client regional setting] [-b On error batch abort]
[-v var = "value"...]
[-X[1] disable commands[and exit with warning]]
[-? show syntax summary]
 
Click here for SQLCMD Utility 
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in Scripting | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Rename a Windows Server 2003 domain controller (DC)
    Follow the below link: http://windowsitpro.com/article/articleid/41055/how-can-i-rename-a-windows-server-2003-domain-controller-dc.html
  • NetBackup Interview Questions
    Click Here NetBackup Interview Questions
  • Create a Folder Using Batch Script
    ECHO Starts Creating Folder Set FDate=%Date:~-10,10% Set Fdate=%FDate:/=-% MD C:\test\%FDate% Move C:\test\DATA\*.* C:\test\%FDate% Copy abo...
  • How to Redirect Computer OU and User's OU
    Redirecting  "users"  Organizational unit to Specified Organizantional Unit Go to - C:\windows\system32>redirusr ou=newusers,DC...
  • Citrix Interview Questions Citrix XenApp
    What is Farm? Farm is a collection of citrix servers which provide published applications to all users. It also prevent singel of failure o...
  • Windows 7 Deployment using MDT ( Microsoft Deployment Tool kit 2010)
    How to Deploy Windows 7 using MDT Open Deployment work bench and create a deployment share  as Windows 7 and finish the wizard.  After creat...
  • Active Directory Saved Queries Templates ( very useful)
    In order to configure and use server query follow the below link ( Very useful link) http://www.kreslavsky.com/2008/08/active-directory-save...
  • How To Create PST In Outlook 2010
    http://www.addictivetips.com/windows-tips/how-to-create-data-file-in-outlook-2010/
  • Click here Batch Script ABCs (Basics)
    Batch Script Basics 1) http://www.computerhope.com/batch.htm#01 2) http://www.csie.ntu.edu.tw/~r92092/ref/win32/win32scripting.html
  • VMware ESX 3.5 Update to Build Number
    ESX 3.5.0 Update 1 = Build 64607 ESX 3.5.0 Update 2 = Build 110268 ESX 3.5.0 Update 3 = Build 123630 ESX 3.5.0 Update 4 = Build 153875 ESX 3...

Categories

  • Active Directory
  • Citrix
  • Downloads
  • Exchange Server
  • HPSA
  • IIS
  • SCCM
  • SCOM 2007
  • Scripting
  • SQL
  • Storage
  • VMWARE
  • Windows
  • Windows 7
  • Windows Server 2003
  • Windows Server 2008

Blog Archive

  • ▼  2011 (25)
    • ►  November (5)
    • ►  July (1)
    • ►  June (1)
    • ►  May (3)
    • ▼  April (12)
      • SCCM / SMS Interview Questions
      • Microsoft Exchange Server Interview Questions 200...
      • HP server Automation - Opsware - HPSA Interview Qu...
      • Click here Batch Script ABCs (Basics)
      • Converting DOS Batch Files to Shell Scripts
      • Download Links
      • SQLCMD Syntax
      • Click here for DOS commands with XP
      • Create a Folder Using Batch Script
      • Upgrading ESX server (Virtual Infrastructure) 3.5 ...
      • What is a server farm in Citrix
      • HPSA - HP server Automation - Opsware
    • ►  March (3)
  • ►  2010 (12)
    • ►  June (1)
    • ►  May (3)
    • ►  April (8)
  • ►  2009 (24)
    • ►  November (1)
    • ►  July (1)
    • ►  June (16)
    • ►  May (2)
    • ►  March (4)
Powered by Blogger.

About Me

Unknown
View my complete profile