René's URL Explorer Experiment


Title: Run Transact-SQL Commands with the sqlcmd Utility - SQL Server | Microsoft Learn

Open Graph Title: Run Transact-SQL Commands with the sqlcmd Utility - SQL Server

Description: The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files using different modes, using go-mssqldb or ODBC to run T-SQL batches.

Open Graph Description: The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files using different modes, using go-mssqldb or ODBC to run T-SQL batches.

Opengraph URL: https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver17

X: @MicrosoftLearn

direct link

Domain: docs.microsoft.com

color-schemelight dark
twitter:cardsummary_large_image
og:typewebsite
og:image:altMicrosoft Learn
og:imagehttps://learn.microsoft.com/en-us/media/open-graph-image.png
platform_idc89bca61-b723-36fd-2a10-e0aeb5e85a23
scopesql
localeen-us
uhfHeaderIdMSDocsHeader-DocsSQL
page_typeconceptual
toc_previewtrue
feedback_systemStandard
feedback_product_urlhttps://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
feedback_help_link_urlhttps://learn.microsoft.com/answers/tags/191/sql-server
feedback_help_link_typeget-help-at-qna
recommendationstrue
breadcrumb_path../../breadcrumb/toc.json
monikerRange>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2017 || >=sql-server-linux-2017 || =fabric-sqldb
ms.update-cycle365-days
authorrwestMSFT
ms.authorrandolphwest
ms.reviewerdlevy
ms.date2026-01-29T00:00:00Z
ms.servicesql
ms.subservicetools-other
ms.topicconcept-article
ms.collectiondata-tools
ms.customignite-2025
zone_pivot_groupscs1-command-shell
document_id8da1f57b-a8fd-cca7-4cf0-9d594d365062
document_version_independent_id60c46780-6a03-7958-c77a-e7c94e3b9e85
updated_at2026-07-21T00:29:00Z
original_content_git_urlhttps://github.com/MicrosoftDocs/sql-docs-pr/blob/live/docs/tools/sqlcmd/sqlcmd-utility.md
gitcommithttps://github.com/MicrosoftDocs/sql-docs-pr/blob/4f43f815712bfe38231ce50021bfd788a7269693/docs/tools/sqlcmd/sqlcmd-utility.md
git_commit_id4f43f815712bfe38231ce50021bfd788a7269693
monikerssql-server-ver17
default_monikersql-server-ver17
site_nameDocs
depot_nameSQL.sql-content
schemaConceptual
toc_rel../../toc.json
pdf_url_templatehttps://learn.microsoft.com/pdfstore/en-us/SQL.sql-content/{branchName}{pdfName}
word_count7014
config_moniker_range=azuresqldb-current || =azuresqldb-mi-current || =azure-sqldw-latest || >=aps-pdw-2016 || >=sql-server-2017 || >=sql-server-linux-2017 || =fabric || =fabric-sqldb
asset_idtools/sqlcmd/sqlcmd-utility
moniker_range_name566ce1900aff08773acb307531080631
item_typeContent
source_pathdocs/tools/sqlcmd/sqlcmd-utility.md
previous_tlsh_hash74EF6303A72CD702FF829E06255EAB5171F2CB4D65A0BF48003D1593EA2A2D33576989D6D727AB88273A238311D2215DE2C5AB39C1AE236157555C6CC34CB217FB8D3FBBF4
github_feedback_content_git_urlhttps://github.com/MicrosoftDocs/sql-docs/blob/live/docs/tools/sqlcmd/sqlcmd-utility.md
markdown_urlhttps://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver17&accept=text/markdown
cmProductshttps://microsoft-devrel.poolparty.biz/DevRelOfferingOntology/1433a524-c01f-4b87-beab-670c040dea4f
spProductshttps://microsoft-devrel.poolparty.biz/DevRelOfferingOntology/312f1f05-a431-4193-8a4d-e6245d5966de

Links:

Skip to main content https://docs.microsoft.com/sql/tools/sqlcmd-utility#main
Skip to Ask Learn chat experience https://docs.microsoft.com/sql/tools/sqlcmd-utility
Download Microsoft Edge https://go.microsoft.com/fwlink/p/?LinkID=2092881
More info about Internet Explorer and Microsoft Edge https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-edge
Read in English https://docs.microsoft.com/sql/tools/sqlcmd-utility
Edit https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/tools/sqlcmd/sqlcmd-utility.md
signing inhttps://docs.microsoft.com/sql/tools/sqlcmd-utility
SQL Serverhttps://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
Azure SQL Databasehttps://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
Azure SQL Managed Instancehttps://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
Azure Synapse Analyticshttps://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
Analytics Platform System (PDW)https://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
SQL database in Microsoft Fabrichttps://docs.microsoft.com/sql-server/sql-docs-navigation-guide?view=sql-server-ver17#applies-to
SQLCMD modehttps://docs.microsoft.com/en-us/ssms/scripting/sqlcmd-scripts-query-editor
new name for Azure Active Directory (Azure AD)https://docs.microsoft.com/en-us/entra/fundamentals/new-name
Check installed version of sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-installed-version?view=sql-server-ver17
Download and install the sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-download-install?view=sql-server-ver17
sqlcmd (Go)https://docs.microsoft.com/sql/tools/sqlcmd-utility#tabpanel_1_go
sqlcmd (ODBC)https://docs.microsoft.com/sql/tools/sqlcmd-utility#tabpanel_1_odbc
Prioritize implementation of back-compat flagshttps://github.com/microsoft/go-sqlcmd/discussions/292
MS-TDS PRELOGINhttps://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/60f56408-0188-4cd5-8b90-25c6f2423868
Authenticate with Microsoft Entra ID in sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-authentication?view=sql-server-ver17
Login-related optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#login-related-options
-Ahttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-a
-Chttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-c
-d db_namehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-d-db_name
-Dhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-d
-l login_timeouthttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-l-login_timeout
-Ehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-e-trusted
-F hostname_in_certificatehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-f-hostname_in_certificate
-ghttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-g-column
-Ghttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-g-entra
-H workstation_namehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-h-workstation_name
-jhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-j
-J server_certificatehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-j-server_certificate
-K application_intenthttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-k-application_intent
-M multisubnet_failoverhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-m-multisubnet_failover
-N[s|m|o]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-nsmo
-P passwordhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-p-password
-S [protocol:]server[\instance_name][,port]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-s-protocolserverinstance_nameport
-U login_idhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-u-login_id
-z new_passwordhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-z-new_password
-Z new_passwordhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-z-exit
Input/output optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#input-and-output-options
-f codepage | i:codepage[,o:codepage] | o:codepage[,i:codepage]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-f-codepage--icodepageocodepage--ocodepageicodepage
-i input_file[,input_file2...]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-i-input_fileinput_file2
-o output_filehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-o-output_file
-r[0 | 1]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-r0--1
-Rhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-r
-uhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-u
Query execution optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#query-execution-options
-ehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-e-stdout
-Ihttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-i
-q "cmdline query"https://docs.microsoft.com/sql/tools/sqlcmd-utility#-q-cmdline-query
-Q "cmdline query"https://docs.microsoft.com/sql/tools/sqlcmd-utility#-q-exit
-t query_timeouthttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-t-query_timeout
-v var = value [ var = value... ]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-v-var--value--var--value-
-xhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-x
Format optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#format-options
-h headershttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-h-headers
-k [1 | 2]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-k-1--2
-s col_separatorhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-s-col_separator
-w screen_widthhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-w-screen_width
-Whttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-w
-y variable_length_type_display_widthhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-y-variable_length_type_display_width
-Y fixed_length_type_display_widthhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-y-fixed_length_type_display_width
Error reporting optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#error-reporting-options
-bhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-b
-m error_levelhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-m-error_level
-V error_severity_levelhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-v-error_severity_level
Miscellaneous optionshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#miscellaneous-options
-a packet_sizehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-a-packet_size
-c batch_terminatorhttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-c-batch_terminator
-L[c]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-lc
-p[1]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-p1
-X[1]https://docs.microsoft.com/sql/tools/sqlcmd-utility#-x1
-?https://docs.microsoft.com/sql/tools/sqlcmd-utility#-version
Diagnostic connection for database administratorshttps://docs.microsoft.com/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver17
Programming Guidelineshttps://docs.microsoft.com/connect/odbc/linux-mac/programming-guidelines?view=sql-server-ver17
DSN support in sqlcmd and bcphttps://docs.microsoft.com/sql/tools/sqlcmd-utility#dsn-support-in-sqlcmd-and-bcp
Using Integrated Authenticationhttps://docs.microsoft.com/connect/odbc/linux-mac/using-integrated-authentication?view=sql-server-ver17
Always Encryptedhttps://docs.microsoft.com/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver17
13.1https://go.microsoft.com/fwlink/?LinkID=825643
13.1https://go.microsoft.com/fwlink/?LinkID=825643
Microsoft Entra authentication for Azure SQLhttps://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
Download ODBC Driver for SQL Serverhttps://docs.microsoft.com/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver17
properly configured Kerberos environmenthttps://docs.microsoft.com/connect/odbc/linux-mac/using-integrated-authentication?view=sql-server-ver17
Authenticate with Microsoft Entra ID in sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-authentication?view=sql-server-ver17
Offload read-only workload to secondary replica of an Always On availability grouphttps://docs.microsoft.com/database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver17
DSN Support in sqlcmd and bcphttps://docs.microsoft.com/sql/tools/sqlcmd-utility#dsn-support-in-sqlcmd-and-bcp
High availability and disaster recovery on Linux and macOShttps://docs.microsoft.com/connect/odbc/linux-mac/odbc-driver-on-linux-support-for-high-availability-disaster-recovery?view=sql-server-ver17
Connect to an Always On availability group listenerhttps://docs.microsoft.com/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver17
Reference for the creation and configuration of Always On availability groupshttps://docs.microsoft.com/database-engine/availability-groups/windows/creation-and-configuration-of-availability-groups-sql-server?view=sql-server-ver17
Failover Clustering and Always On availability groups (SQL Server)https://docs.microsoft.com/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver17
Offload read-only workload to secondary replica of an Always On availability grouphttps://docs.microsoft.com/database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver17
DSN Support in sqlcmd and bcphttps://docs.microsoft.com/sql/tools/sqlcmd-utility#dsn-support-in-sqlcmd-and-bcp
High availability and disaster recovery on Linux and macOShttps://docs.microsoft.com/connect/odbc/linux-mac/odbc-driver-on-linux-support-for-high-availability-disaster-recovery?view=sql-server-ver17
strong passwordhttps://docs.microsoft.com/relational-databases/security/strong-passwords?view=sql-server-ver17
SET QUOTED_IDENTIFIERhttps://docs.microsoft.com/t-sql/statements/set-quoted-identifier-transact-sql?view=sql-server-ver17
elsewherehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-b
elsewherehttps://docs.microsoft.com/sql/tools/sqlcmd-utility#-b
Windowshttps://docs.microsoft.com/sql/tools/sqlcmd-utility#tabpanel_2_windows-support
Linux and macOShttps://docs.microsoft.com/sql/tools/sqlcmd-utility#tabpanel_2_linux-support
sqlcmd - Use with scripting variableshttps://docs.microsoft.com/sql/tools/sqlcmd-use-scripting-variables?view=sql-server-ver17
Use sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-use-utility?view=sql-server-ver17
DSN and Connection String Keywords and Attributeshttps://docs.microsoft.com/connect/odbc/dsn-connection-string-attribute?view=sql-server-ver17
severity 16 level messageshttps://docs.microsoft.com/relational-databases/errors-events/database-engine-error-severities?view=sql-server-ver17#levels-of-severity
@@ERRORhttps://docs.microsoft.com/t-sql/functions/error-transact-sql?view=sql-server-ver17
Check installed version of sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-installed-version?view=sql-server-ver17
Download and install the sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-download-install?view=sql-server-ver17
Commands in the sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-commands?view=sql-server-ver17
Use sqlcmd with scripting variableshttps://docs.microsoft.com/sql/tools/sqlcmd-use-scripting-variables?view=sql-server-ver17
Quickstart: Run SQL Server Linux container images with Dockerhttps://docs.microsoft.com/linux/quickstart-install-connect-docker?view=sql-server-ver17
Start the sqlcmd utilityhttps://docs.microsoft.com/sql/tools/sqlcmd-start-utility?view=sql-server-ver17
Execute T-SQL from a script file with sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-run-transact-sql-script-files?view=sql-server-ver17
Use sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-use-utility?view=sql-server-ver17
Connect to SQL Server with sqlcmdhttps://docs.microsoft.com/sql/tools/sqlcmd-connect-database-engine?view=sql-server-ver17
Edit SQLCMD scripts with Query Editorhttps://docs.microsoft.com/en-us/ssms/scripting/sqlcmd-scripts-query-editor
Create a CmdExec Job Stephttps://docs.microsoft.com/en-us/ssms/agent/create-a-cmdexec-job-step
en-ushttps://docs.microsoft.com/sql/tools/sqlcmd-utility
Your Privacy Choiceshttps://aka.ms/yourcaliforniaprivacychoices
AI Disclaimerhttps://learn.microsoft.com/en-us/principles-for-ai-generated-content
Previous Versionshttps://learn.microsoft.com/en-us/previous-versions/
Bloghttps://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog
Contributehttps://learn.microsoft.com/en-us/contribute
Privacyhttps://go.microsoft.com/fwlink/?LinkId=521839
Consumer Health Privacyhttps://go.microsoft.com/fwlink/?linkid=2259814
Terms of Usehttps://learn.microsoft.com/en-us/legal/termsofuse
Trademarkshttps://www.microsoft.com/legal/intellectualproperty/Trademarks/

Viewport: width=device-width, initial-scale=1.0

URLs of crawlers that visited me.