File tree

• docs
  • database-engine
    • availability-groups/windows
      • about-client-connection-access-to-availability-replicas-sql-server.md
      • active-secondaries-backup-on-secondary-replicas-always-on-availability-groups.md
      • active-secondaries-readable-secondary-replicas-always-on-availability-groups.md
      • add-a-secondary-replica-to-an-availability-group-sql-server.md
      • add-ip-address-dialog-box-sql-server-management-studio.md
      • administration-of-an-availability-group-sql-server.md
      • always-on-availability-groups-interoperability-sql-server.md
      • always-on-availability-groups-sql-server.md
      • always-on-client-connectivity-sql-server.md
      • always-on-policies-for-operational-issues-always-on-availability.md
      • analysis-services-with-always-on-availability-groups.md
      • automatic-seeding-secondary-replicas.md
      • automatically-initialize-always-on-availability-group.md
      • availability-database-is-suspended.md
      • availability-group-add-a-database.md
      • availability-group-add-database-to-group-wizard.md
      • availability-group-is-not-ready-for-automatic-failover.md
      • availability-group-is-offline.md
      • availability-group-properties-new-availability-group-backup-preferences-page.md
      • availability-group-properties-new-availability-group-general-page.md
      • availability-modes-always-on-availability-groups.md
      • availability-replica-does-not-have-a-healthy-role.md
      • availability-replica-is-disconnected.md
      • availability-replica-is-not-joined.md
      • availability-replica-properties-general-page.md
      • basic-availability-groups-always-on-availability-groups.md
      • change-the-availability-mode-of-an-availability-replica-sql-server.md
      • change-the-failover-mode-of-an-availability-replica-sql-server.md
      • change-the-hadr-cluster-context-of-server-instance-sql-server.md
      • change-the-session-timeout-period-for-an-availability-replica-sql-server.md
      • cluster-dtc-for-sql-server-2016-availability-groups.md
      • configuration-of-a-server-instance-for-always-on-availability-groups-sql-server.md
      • configure-availability-group-for-distributed-transactions.md
      • configure-backup-on-availability-replicas-sql-server.md
      • configure-distributed-availability-groups.md
      • configure-flexible-automatic-failover-policy.md
      • configure-read-only-access-on-an-availability-replica-sql-server.md
      • configure-read-only-routing-for-an-availability-group-sql-server.md
      • configure-replication-for-always-on-availability-groups-sql-server.md
      • connect-to-existing-secondary-replicas-page.md
      • contained-databases-with-always-on-availability-groups-sql-server.md
      • create-an-availability-group-sql-server-powershell.md
      • create-an-availability-group-transact-sql.md
      • create-clustered-dtc-for-an-always-on-availability-group.md
      • create-or-configure-an-availability-group-listener-sql-server.md
      • creation-and-configuration-of-availability-groups-sql-server.md
      • data-synchronization-state-of-availability-database-is-not-healthy.md
      • data-synchronization-state-of-some-availability-database-is-not-healthy.md
      • database-mirroring-always-on-availability-groups-powershell.md
      • database-snapshots-with-always-on-availability-groups-sql-server.md
      • distributed-availability-groups.md
      • domain-independent-availability-groups.md
      • enable-and-disable-always-on-availability-groups-sql-server.md
      • encrypted-databases-with-always-on-availability-groups-sql-server.md
      • enhanced-database-failover.md
      • enter-passwords-page-add-replica-wizard.md
      • failover-and-failover-modes-always-on-availability-groups.md
      • failover-clustering-and-always-on-availability-groups-sql-server.md
      • filestream-and-filetable-with-always-on-availability-groups-sql-server.md
      • flexible-automatic-failover-policy-availability-group.md
      • getting-started-with-always-on-availability-groups-sql-server.md
      • join-a-secondary-database-to-an-availability-group-sql-server.md
      • join-a-secondary-replica-to-an-availability-group-sql-server.md
      • listeners-client-connectivity-application-failover.md
      • logins-and-jobs-for-availability-group-databases.md
      • maintaining-an-always-on-publication-database-sql-server.md
      • manually-prepare-a-secondary-database-for-an-availability-group-sql-server.md
      • monitor-availability-groups-transact-sql.md
      • monitoring-of-availability-groups-sql-server.md
      • options-sql-server-always-on-dashboard-page.md
      • overview-of-always-on-availability-groups-sql-server.md
      • overview-of-powershell-cmdlets-for-always-on-availability-groups-sql-server.md
      • perform-a-forced-manual-failover-of-an-availability-group-sql-server.md
      • perform-a-planned-manual-failover-of-an-availability-group-sql-server.md
      • policy-evaluation-result-always-on.md
      • possible-failures-during-sessions-between-availability-replicas-sql-server.md
      • prereqs-migrating-log-shipping-to-always-on-availability-groups.md
      • prereqs-restrictions-recommendations-always-on-availability.md
      • progress-page-always-on-availability-group-wizards.md
      • read-scale-availability-groups.md
      • remote-blob-store-rbs-and-always-on-availability-groups-sql-server.md
      • remove-a-primary-database-from-an-availability-group-sql-server.md
      • remove-a-secondary-database-from-an-availability-group-sql-server.md
      • remove-a-secondary-replica-from-an-availability-group-sql-server.md
      • remove-an-availability-group-listener-sql-server.md
      • remove-an-availability-group-sql-server.md
      • replicate-track-change-data-capture-always-on-availability.md
      • replication-subscribers-and-always-on-availability-groups-sql-server.md
      • reporting-services-with-always-on-availability-groups-sql-server.md
      • results-page-always-on-availability-group-wizards.md
      • resume-an-availability-database-sql-server.md
      • secondary-database-is-not-joined.md
      • select-databases-page-new-availability-group-wizard-and-add-database-wizard.md
      • select-initial-data-synchronization-page-always-on-availability-group-wizards.md
      • service-broker-with-always-on-availability-groups-sql-server.md
      • some-availability-replicas-are-disconnected.md
      • some-availability-replicas-are-not-synchronizing-data.md
      • some-availability-replicas-do-not-have-a-healthy-role.md
      • some-synchronous-replicas-are-not-synchronized.md
      • specify-availability-group-name-page.md
      • specify-endpoint-url-adding-or-modifying-availability-replica.md
      • specify-replicas-page-new-availability-group-wizard-add-replica-wizard.md
      • sql-server-always-on-database-health-detection-failover-option.md
      • start-data-movement-on-an-always-on-secondary-database-sql-server.md
      • summary-page-always-on-availability-group-wizards.md
      • suspend-an-availability-database-sql-server.md
      • take-an-availability-group-offline-sql-server.md
      • transact-sql-statements-for-always-on-availability-groups.md
      • transactions-always-on-availability-and-database-mirroring.md
      • troubleshoot-a-failed-add-file-operation-always-on-availability-groups.md
      • troubleshoot-always-on-availability-groups-configuration-sql-server.md
      • tune-compression-for-availability-group.md
      • upgrading-always-on-availability-group-replica-instances.md
      • use-always-on-policies-to-view-the-health-of-an-availability-group-sql-server.md
      • use-object-explorer-details-to-monitor-availability-groups.md
      • use-the-add-azure-replica-wizard-sql-server.md
      • use-the-add-replica-to-availability-group-wizard-sql-server-management-studio.md
      • use-the-always-on-dashboard-sql-server-management-studio.md
      • use-the-availability-group-wizard-sql-server-management-studio.md
      • use-the-fail-over-availability-group-wizard-sql-server-management-studio.md
      • use-the-new-availability-group-dialog-box-sql-server-management-studio.md
      • validation-page-always-on-availability-group-wizards.md
      • view-availability-group-listener-properties-sql-server.md
      • view-availability-group-properties-sql-server.md
      • view-availability-replica-properties-sql-server.md
      • wsfc-cluster-service-is-offline.md
    • breaking-changes-to-database-engine-features-in-sql-server-2016.md
    • breaking-changes-to-database-engine-features-in-sql-server-2017.md
    • configure-windows
      • access-check-cache-server-configuration-options.md
      • ad-hoc-distributed-queries-server-configuration-option.md
      • affinity-input-output-mask-server-configuration-option.md
      • affinity-mask-server-configuration-option.md
      • affinity64-input-output-mask-server-configuration-option.md
      • affinity64-mask-server-configuration-option.md
      • agent-xps-server-configuration-option.md
      • allow-updates-server-configuration-option.md
      • backup-checksum-default.md
      • blocked-process-threshold-server-configuration-option.md
      • broadcast-a-shutdown-message-command-prompt.md
      • buffer-pool-extension.md
      • c2-audit-mode-server-configuration-option.md
      • change-server-authentication-mode.md
      • check-the-odbc-sql-server-driver-version-windows.md
      • client-network-configuration.md
      • clr-enabled-server-configuration-option.md
      • clr-strict-security.md
      • common-criteria-compliance-enabled-server-configuration-option.md
      • configure-a-server-to-listen-on-a-specific-tcp-port.md
      • configure-a-server-to-listen-on-an-alternate-pipe.md
      • configure-a-windows-firewall-for-database-engine-access.md
      • configure-client-protocols.md
      • configure-database-engine-instances-sql-server.md
      • configure-file-system-permissions-for-database-engine-access.md
      • configure-the-cost-threshold-for-parallelism-server-configuration-option.md
      • configure-the-cursor-threshold-server-configuration-option.md
      • configure-the-database-engine-to-listen-on-multiple-tcp-ports.md
      • configure-the-default-full-text-language-server-configuration-option.md
      • configure-the-default-language-server-configuration-option.md
      • configure-the-fill-factor-server-configuration-option.md
      • configure-the-index-create-memory-server-configuration-option.md
      • configure-the-locks-server-configuration-option.md
      • configure-the-max-degree-of-parallelism-server-configuration-option.md
      • configure-the-max-text-repl-size-server-configuration-option.md
      • configure-the-max-worker-threads-server-configuration-option.md
      • configure-the-media-retention-server-configuration-option.md
      • configure-the-min-memory-per-query-server-configuration-option.md
      • configure-the-nested-triggers-server-configuration-option.md
      • configure-the-network-packet-size-server-configuration-option.md
      • configure-the-priority-boost-server-configuration-option.md
      • configure-the-query-governor-cost-limit-server-configuration-option.md
      • configure-the-query-wait-server-configuration-option.md
      • configure-the-recovery-interval-server-configuration-option.md
      • configure-the-remote-access-server-configuration-option.md
      • configure-the-remote-data-archive-server-configuration-option.md
      • configure-the-remote-login-timeout-server-configuration-option.md
      • configure-the-remote-proc-trans-server-configuration-option.md
      • configure-the-remote-query-timeout-server-configuration-option.md
      • configure-the-scan-for-startup-procs-server-configuration-option.md
      • configure-the-two-digit-year-cutoff-server-configuration-option.md
      • configure-the-user-connections-server-configuration-option.md
      • configure-the-user-options-server-configuration-option.md
      • configure-windows-service-accounts-and-permissions.md
      • connect-to-sql-server-through-a-proxy-server-sql-server-configuration-manager.md
      • connect-to-sql-server-when-system-administrators-are-locked-out.md
      • connect-to-the-database-engine-using-extended-protection.md
      • contained-database-authentication-server-configuration-option.md
      • create-or-delete-a-server-alias-for-use-by-a-client.md
      • cross-db-ownership-chaining-server-configuration-option.md
      • database-engine-instances-sql-server.md
      • database-engine-service-startup-options.md
      • database-mail-xps-server-configuration-option.md
      • default-sql-server-network-protocol-configuration.md
      • default-trace-enabled-server-configuration-option.md
      • determine-whether-the-database-engine-is-installed-and-started.md
      • diagnostic-connection-for-database-administrators.md
      • disallow-results-from-triggers-server-configuration-option.md
      • ekm-provider-enabled-server-configuration-option.md
      • enable-encrypted-connections-to-the-database-engine.md
      • enable-or-disable-a-server-network-protocol.md
      • enable-the-lock-pages-in-memory-option-windows.md
      • external-scripts-enabled-server-configuration-option.md
      • filestream-access-level-server-configuration-option.md
      • ft-crawl-bandwidth-server-configuration-option.md
      • ft-notify-bandwidth-server-configuration-option.md
      • hide-an-instance-of-sql-server-database-engine.md
      • in-doubt-xact-resolution-server-configuration-option.md
      • lightweight-pooling-server-configuration-option.md
      • log-in-to-an-instance-of-sql-server-command-prompt.md
      • logging-in-to-sql-server.md
      • manage-the-database-engine-services.md
      • map-tcp-ip-ports-to-numa-nodes-sql-server.md
      • max-full-text-crawl-range-server-configuration-option.md
      • ole-automation-procedures-server-configuration-option.md
      • open-objects-server-configuration-option.md
      • open-the-odbc-data-source-administrator.md
      • optimize-for-ad-hoc-workloads-server-configuration-option.md
      • ph-timeout-server-configuration-option.md
      • polybase-connectivity-configuration-transact-sql.md
      • precompute-rank-server-configuration-option.md
      • register-a-service-principal-name-for-kerberos-connections.md
      • remote-admin-connections-server-configuration-option.md
      • remote-servers.md
      • replication-xps-server-configuration-option.md
      • run-sql-server-with-or-without-a-network.md
      • scm-services-change-the-password-of-the-accounts-used.md
      • scm-services-change-the-service-startup-account.md
      • scm-services-configure-server-startup-options.md
      • scm-services-configure-sql-server-error-logs.md
      • scm-services-connect-to-another-computer.md
      • scm-services-prevent-automatic-startup-of-an-instance.md
      • scm-services-set-an-instance-to-start-automatically.md
      • security-requirements-for-managing-services.md
      • server-configuration-options-sql-server.md
      • server-memory-server-configuration-options.md
      • server-network-configuration.md
      • server-properties-advanced-page.md
      • server-properties-connections-page.md
      • server-properties-database-settings-page.md
      • server-properties-filestream-page.md
      • server-properties-general-page.md
      • server-properties-memory-page.md
      • server-properties-misc-server-settings-page.md
      • server-properties-processors-page.md
      • server-properties-security-page.md
      • server-trigger-recursion-server-configuration-option.md
      • set-working-set-size-server-configuration-option.md
      • show-advanced-options-server-configuration-option.md
      • smo-and-dmo-xps-server-configuration-option.md
      • soft-numa-sql-server.md
      • sql-server-2016-express-localdb.md
      • sql-server-browser-service-database-engine-and-ssas.md
      • sql-server-monitor-overview.md
      • sql-server-service-broker.md
      • sql-writer-service.md
      • start-sql-server-in-single-user-mode.md
      • start-sql-server-with-minimal-configuration.md
      • start-stop-pause-resume-restart-sql-server-services.md
      • transform-noise-words-server-configuration-option.md
      • troubleshoot-connecting-to-the-sql-server-database-engine.md
      • view-or-change-server-properties-sql-server.md
      • view-or-change-the-default-locations-for-data-and-log-files.md
      • view-or-configure-remote-server-connection-options-sql-server.md
      • view-or-configure-the-backup-compression-default-server-configuration-option.md
      • xp-cmdshell-server-configuration-option.md
    • database-mirroring
      • add-a-database-mirroring-witness-using-windows-authentication-transact-sql.md
      • add-or-replace-a-database-mirroring-witness-sql-server-management-studio.md
      • change-transaction-safety-in-a-database-mirroring-session-transact-sql.md
      • choose-servers-to-configure-configure-database-mirroring-security-wizard.md
      • connect-clients-to-a-database-mirroring-session-sql-server.md
      • create-a-database-mirroring-endpoint-for-windows-authentication-transact-sql.md
      • database-mirroring-allow-network-access-windows-authentication.md
      • database-mirroring-and-database-snapshots-sql-server.md
      • database-mirroring-and-full-text-catalogs-sql-server.md
      • database-mirroring-and-log-shipping-sql-server.md
      • database-mirroring-and-replication-sql-server.md
      • database-mirroring-and-sql-server-failover-cluster-instances.md
      • database-mirroring-establish-session-windows-authentication.md
      • database-mirroring-history.md
      • database-mirroring-interoperability-and-coexistence-sql-server.md
      • database-mirroring-monitor-overview.md
      • database-mirroring-monitor-status-page.md
      • database-mirroring-monitor-warnings-page.md
      • database-mirroring-operating-modes.md
      • database-mirroring-sql-server.md
      • database-mirroring-use-certificates-for-inbound-connections.md
      • database-mirroring-use-certificates-for-outbound-connections.md
      • database-mirroring-witness.md
      • establish-database-mirroring-session-windows-authentication.md
      • estimate-the-interruption-of-service-during-role-switching-database-mirroring.md
      • example-setting-up-database-mirroring-using-certificates-transact-sql.md
      • example-setting-up-database-mirroring-using-windows-authentication-transact-sql.md
      • force-service-in-a-database-mirroring-session-transact-sql.md
      • include-witness-server-configure-database-mirroring-security-wizard.md
      • manually-fail-over-a-database-mirroring-session-sql-server-management-studio.md
      • manually-fail-over-a-database-mirroring-session-transact-sql.md
      • mirror-server-instance-configure-database-mirroring-security-wizard.md
      • mirroring-states-sql-server.md
      • monitoring-database-mirroring-sql-server.md
      • pause-or-resume-a-database-mirroring-session-sql-server.md
      • pausing-and-resuming-database-mirroring-sql-server.md
      • possible-failures-during-database-mirroring.md
      • prepare-a-mirror-database-for-mirroring-sql-server.md
      • prerequisites-restrictions-and-recommendations-for-database-mirroring.md
      • principal-server-instance-configure-database-mirroring-security-wizard.md
      • quorum-how-a-witness-affects-database-availability-database-mirroring.md
      • register-mirrored-database.md
      • remove-database-mirroring-sql-server.md
      • remove-the-witness-from-a-database-mirroring-session-sql-server.md
      • removing-database-mirroring-sql-server.md
      • role-switching-during-a-database-mirroring-session-sql-server.md
      • service-accounts-configure-database-mirroring-security-wizard.md
      • set-up-a-mirror-database-to-use-the-trustworthy-property-transact-sql.md
      • set-up-an-encrypted-mirror-database.md
      • set-up-login-accounts-database-mirroring-always-on-availability.md
      • set-warning-thresholds.md
      • setting-up-database-mirroring-sql-server.md
      • specify-a-server-network-address-database-mirroring.md
      • start-database-mirroring-monitor-sql-server-management-studio.md
      • start-the-configuring-database-mirroring-security-wizard.md
      • the-database-mirroring-endpoint-sql-server.md
      • transport-security-database-mirroring-always-on-availability.md
      • troubleshoot-database-mirroring-configuration-sql-server.md
      • upgrading-mirrored-instances.md
      • use-certificates-for-a-database-mirroring-endpoint-transact-sql.md
      • use-warning-thresholds-and-alerts-on-mirroring-performance-metrics-sql-server.md
      • view-the-state-of-a-mirrored-database-sql-server-management-studio.md
      • witness-server-instance-configure-database-mirroring-security-wizard.md
    • deprecated-database-engine-features-in-sql-server-2016.md
    • deprecated-database-engine-features-in-sql-server-2017.md
    • discontinued-database-engine-functionality-in-sql-server-2016.md
    • install-windows
      • add-features-to-an-instance-of-sql-server-setup.md
      • are-you-upgrading-from-sql-server-2005.md
      • change-the-database-compatibility-mode-and-use-the-query-store.md
      • check-parameters-for-the-system-configuration-checker.md
      • choose-a-database-engine-upgrade-method.md
      • complete-the-database-engine-upgrade.md
      • configure-sql-server-on-a-server-core-installation.md
      • considerations-for-installing-sql-server-using-sysprep.md
      • install-sql-server-database-engine.md
      • install-sql-server-from-the-command-prompt.md
      • install-sql-server-from-the-installation-wizard-setup.md
      • install-sql-server-on-server-core.md
      • install-sql-server-powershell.md
      • install-sql-server-replication.md
      • install-sql-server-servicing-updates.md
      • install-sql-server-using-a-configuration-file.md
      • install-sql-server-using-sysprep.md
      • install-sql-server-with-smb-fileshare-as-a-storage-option.md
      • install-sql-server.md
      • installation-for-sql-server.md
      • installing-updates-from-the-command-prompt.md
      • local-audit-for-sql-server-usage-feedback-collection.md
      • plan-and-test-the-database-engine-upgrade-plan.md
      • prepare-for-upgrade-by-running-data-migration-assistant.md
      • rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server.md
      • repair-a-failed-sql-server-installation.md
      • supported-version-and-edition-upgrades-2017.md
      • supported-version-and-edition-upgrades.md
      • upgrade-analysis-services.md
      • upgrade-data-quality-services.md
      • upgrade-database-engine.md
      • upgrade-master-data-services.md
      • upgrade-power-pivot-for-sharepoint.md
      • upgrade-replicated-databases.md
      • upgrade-sql-server-management-tools.md
      • upgrade-sql-server-using-the-installation-wizard-setup.md
      • upgrade-sql-server.md
      • upgrade-to-a-different-edition-of-sql-server-setup.md
      • validate-a-sql-server-installation.md
      • view-and-read-sql-server-setup-log-files.md
    • log-shipping
      • about-log-shipping-sql-server.md
      • add-a-secondary-database-to-a-log-shipping-configuration-sql-server.md
      • change-roles-between-primary-and-secondary-log-shipping-servers-sql-server.md
      • configure-log-shipping-sql-server.md
      • fail-over-to-a-log-shipping-secondary-sql-server.md
      • log-shipping-and-replication-sql-server.md
      • log-shipping-tables-and-stored-procedures.md
      • monitor-log-shipping-transact-sql.md
      • remove-a-secondary-database-from-a-log-shipping-configuration-sql-server.md
      • remove-log-shipping-sql-server.md
      • upgrading-log-shipping-to-sql-server-2016-transact-sql.md
      • view-the-log-shipping-report-sql-server-management-studio.md
    • sql-server-business-continuity-dr.md
    • sql-server-database-engine-backward-compatibility.md
    • sql-server-database-engine-overview.md
    • whats-new-in-sql-server-2016.md
    • whats-new-in-sql-server-2017.md
  • t-sql
    • data-types
      • binary-and-varbinary-transact-sql.md
      • bit-transact-sql.md
      • char-and-varchar-transact-sql.md
      • constants-transact-sql.md
      • cursor-transact-sql.md
      • data-type-conversion-database-engine.md
      • data-type-precedence-transact-sql.md
      • data-type-synonyms-transact-sql.md
      • data-types-transact-sql.md
      • date-and-time-types.md
      • date-transact-sql.md
      • datetime-transact-sql.md
      • datetime2-transact-sql.md
      • datetimeoffset-transact-sql.md
      • decimal-and-numeric-transact-sql.md
      • float-and-real-transact-sql.md
      • getancestor-database-engine.md
      • getdescendant-database-engine.md
      • getlevel-database-engine.md
      • getreparentedvalue-database-engine.md
      • getroot-database-engine.md
      • hierarchyid-data-type-method-reference.md
      • int-bigint-smallint-and-tinyint-transact-sql.md
      • isdescendantof-database-engine.md
      • money-and-smallmoney-transact-sql.md
      • nchar-and-nvarchar-transact-sql.md
      • ntext-text-and-image-transact-sql.md
      • numeric-types.md
      • parse-database-engine.md
      • precision-scale-and-length-transact-sql.md
      • read-database-engine.md
      • rowversion-transact-sql.md
      • smalldatetime-transact-sql.md
      • sql-variant-transact-sql.md
      • string-and-binary-types.md
      • table-transact-sql.md
      • time-transact-sql.md
      • tostring-database-engine.md
      • uniqueidentifier-transact-sql.md
      • write-database-engine.md
    • database-console-commands
      • database-console-commands.md
      • dbcc-checkalloc-transact-sql.md
      • dbcc-checkcatalog-transact-sql.md
      • dbcc-checkconstraints-transact-sql.md
      • dbcc-checkdb-transact-sql.md
      • dbcc-checkfilegroup-transact-sql.md
      • dbcc-checkident-transact-sql.md
      • dbcc-checktable-transact-sql.md
      • dbcc-cleantable-transact-sql.md
      • dbcc-dbreindex-transact-sql.md
      • dbcc-dllname-free-transact-sql.md
      • dbcc-dropcleanbuffers-transact-sql.md
      • dbcc-flushauthcache-transact-sql.md
      • dbcc-freeproccache-transact-sql.md
      • dbcc-freesessioncache-transact-sql.md
      • dbcc-freesystemcache-transact-sql.md
      • dbcc-help-transact-sql.md
      • dbcc-indexdefrag-transact-sql.md
      • dbcc-inputbuffer-transact-sql.md
      • dbcc-opentran-transact-sql.md
      • dbcc-outputbuffer-transact-sql.md
      • dbcc-proccache-transact-sql.md
      • dbcc-show-statistics-transact-sql.md
      • dbcc-showcontig-transact-sql.md
      • dbcc-shrinkdatabase-transact-sql.md
      • dbcc-shrinkfile-transact-sql.md
      • dbcc-shrinklog-azure-sql-data-warehouse.md
      • dbcc-sqlperf-transact-sql.md
      • dbcc-traceoff-transact-sql.md
      • dbcc-traceon-trace-flags-transact-sql.md
      • dbcc-traceon-transact-sql.md
      • dbcc-tracestatus-transact-sql.md
      • dbcc-transact-sql.md
      • dbcc-updateusage-transact-sql.md
      • dbcc-useroptions-transact-sql.md
    • functions
      • abs-transact-sql.md
      • acos-transact-sql.md
      • aggregate-functions-transact-sql.md
      • analytic-functions-transact-sql.md
      • app-name-transact-sql.md
      • applock-mode-transact-sql.md
      • applock-test-transact-sql.md
      • ascii-transact-sql.md
      • asin-transact-sql.md
      • assemblyproperty-transact-sql.md
      • asymkey-id-transact-sql.md
      • asymkeyproperty-transact-sql.md
      • atan-transact-sql.md
      • atn2-transact-sql.md
      • avg-transact-sql.md
      • binary-checksum-transact-sql.md
      • cast-and-convert-transact-sql.md
      • ceiling-transact-sql.md
      • cert-id-transact-sql.md
      • certencoded-transact-sql.md
      • certprivatekey-transact-sql.md
      • certproperty-transact-sql.md
      • char-transact-sql.md
      • charindex-transact-sql.md
      • checksum-agg-transact-sql.md
      • checksum-transact-sql.md
      • col-length-transact-sql.md
      • col-name-transact-sql.md
      • collation-functions-collationproperty-transact-sql.md
      • collation-functions-tertiary-weights-transact-sql.md
      • columnproperty-transact-sql.md
      • columns-updated-transact-sql.md
      • compress-transact-sql.md
      • concat-transact-sql.md
      • concat-ws-transact-sql.md
      • configuration-functions-transact-sql.md
      • connectionproperty-transact-sql.md
      • connections-transact-sql.md
      • context-info-transact-sql.md
      • conversion-functions-transact-sql.md
      • cos-transact-sql.md
      • cot-transact-sql.md
      • count-big-transact-sql.md
      • count-transact-sql.md
      • cpu-busy-transact-sql.md
      • crypt-gen-random-transact-sql.md
      • cryptographic-functions-transact-sql.md
      • cume-dist-transact-sql.md
      • current-request-id-transact-sql.md
      • current-timestamp-transact-sql.md
      • current-transaction-id-transact-sql.md
      • current-user-transact-sql.md
      • cursor-functions-transact-sql.md
      • cursor-rows-transact-sql.md
      • cursor-status-transact-sql.md
      • data-type-functions-transact-sql.md
      • database-principal-id-transact-sql.md
      • databasepropertyex-transact-sql.md
      • datalength-transact-sql.md
      • date-and-time-data-types-and-functions-transact-sql.md
      • dateadd-transact-sql.md
      • datediff-big-transact-sql.md
      • datediff-transact-sql.md
      • datefirst-transact-sql.md
      • datefromparts-transact-sql.md
      • datename-transact-sql.md
      • datepart-transact-sql.md
      • datetime2fromparts-transact-sql.md
      • datetimefromparts-transact-sql.md
      • datetimeoffsetfromparts-transact-sql.md
      • day-transact-sql.md
      • db-id-transact-sql.md
      • db-name-transact-sql.md
      • dbts-transact-sql.md
      • decompress-transact-sql.md
      • decryptbyasymkey-transact-sql.md
      • decryptbycert-transact-sql.md
      • decryptbykey-transact-sql.md
      • decryptbykeyautoasymkey-transact-sql.md
      • decryptbykeyautocert-transact-sql.md
      • decryptbypassphrase-transact-sql.md
      • degrees-transact-sql.md
      • dense-rank-transact-sql.md
      • difference-transact-sql.md
      • encryptbyasymkey-transact-sql.md
      • encryptbycert-transact-sql.md
      • encryptbykey-transact-sql.md
      • encryptbypassphrase-transact-sql.md
      • eomonth-transact-sql.md
      • error-line-transact-sql.md
      • error-message-transact-sql.md
      • error-number-transact-sql.md
      • error-procedure-transact-sql.md
      • error-severity-transact-sql.md
      • error-state-transact-sql.md
      • error-transact-sql.md
      • eventdata-transact-sql.md
      • exp-transact-sql.md
      • fetch-status-transact-sql.md
      • file-id-transact-sql.md
      • file-idex-transact-sql.md
      • file-name-transact-sql.md
      • filegroup-id-transact-sql.md
      • filegroup-name-transact-sql.md
      • filegroupproperty-transact-sql.md
      • fileproperty-transact-sql.md
      • first-value-transact-sql.md
      • floor-transact-sql.md
      • format-transact-sql.md
      • formatmessage-transact-sql.md
      • fulltextcatalogproperty-transact-sql.md
      • fulltextserviceproperty-transact-sql.md
      • functions.md
      • get-filestream-transaction-context-transact-sql.md
      • getansinull-transact-sql.md
      • getdate-transact-sql.md
      • getutcdate-transact-sql.md
      • grouping-id-transact-sql.md
      • grouping-transact-sql.md
      • has-dbaccess-transact-sql.md
      • has-perms-by-name-transact-sql.md
      • hashbytes-transact-sql.md
      • host-id-transact-sql.md
      • host-name-transact-sql.md
      • ident-current-transact-sql.md
      • ident-incr-transact-sql.md
      • ident-seed-transact-sql.md
      • identity-function-transact-sql.md
      • identity-transact-sql.md
      • idle-transact-sql.md
      • index-col-transact-sql.md
      • indexkey-property-transact-sql.md
      • indexproperty-transact-sql.md
      • io-busy-transact-sql.md
      • is-member-transact-sql.md
      • is-objectsigned-transact-sql.md
      • is-rolemember-transact-sql.md
      • is-srvrolemember-transact-sql.md
      • isdate-transact-sql.md
      • isjson-transact-sql.md
      • isnull-transact-sql.md
      • isnumeric-transact-sql.md
      • json-functions-transact-sql.md
      • json-modify-transact-sql.md
      • json-query-transact-sql.md
      • json-value-transact-sql.md
      • key-guid-transact-sql.md
      • key-id-transact-sql.md
      • key-name-transact-sql.md
      • lag-transact-sql.md
      • langid-transact-sql.md
      • language-transact-sql.md
      • last-value-transact-sql.md
      • lead-transact-sql.md
      • left-transact-sql.md
      • len-transact-sql.md
      • lock-timeout-transact-sql.md
      • log-transact-sql.md
      • log10-transact-sql.md
      • logical-functions-choose-transact-sql.md
      • logical-functions-iif-transact-sql.md
      • loginproperty-transact-sql.md
      • lower-transact-sql.md
      • ltrim-transact-sql.md
      • mathematical-functions-transact-sql.md
      • max-connections-transact-sql.md
      • max-precision-transact-sql.md
      • max-transact-sql.md
      • metadata-functions-transact-sql.md
      • min-active-rowversion-transact-sql.md
      • min-transact-sql.md
      • month-transact-sql.md
      • nchar-transact-sql.md
      • nestlevel-transact-sql.md
      • newid-transact-sql.md
      • newsequentialid-transact-sql.md
      • next-value-for-transact-sql.md
      • ntile-transact-sql.md
      • object-definition-transact-sql.md
      • object-id-transact-sql.md
      • object-name-transact-sql.md
      • object-schema-name-transact-sql.md
      • objectproperty-transact-sql.md
      • objectpropertyex-transact-sql.md
      • odbc-scalar-functions-transact-sql.md
      • opendatasource-transact-sql.md
      • openjson-transact-sql.md
      • openquery-transact-sql.md
      • openrowset-transact-sql.md
      • openxml-transact-sql.md
      • options-transact-sql.md
      • original-db-name-transact-sql.md
      • original-login-transact-sql.md
      • pack-received-transact-sql.md
      • pack-sent-transact-sql.md
      • packet-errors-transact-sql.md
      • parse-transact-sql.md
      • parsename-transact-sql.md
      • partition-transact-sql.md
      • patindex-transact-sql.md
      • percent-rank-transact-sql.md
      • percentile-cont-transact-sql.md
      • percentile-disc-transact-sql.md
      • permissions-transact-sql.md
      • pi-transact-sql.md
      • power-transact-sql.md
      • procid-transact-sql.md
      • pwdcompare-transact-sql.md
      • pwdencrypt-transact-sql.md
      • quotename-transact-sql.md
      • radians-transact-sql.md
      • rand-transact-sql.md
      • rank-transact-sql.md
      • ranking-functions-transact-sql.md
      • remserver-transact-sql.md
      • replace-transact-sql.md
      • replicate-transact-sql.md
      • replication-functions-publishingservername.md
      • reverse-transact-sql.md
      • right-transact-sql.md
      • round-transact-sql.md
      • row-number-transact-sql.md
      • rowcount-big-transact-sql.md
      • rowcount-transact-sql.md
      • rowset-functions-transact-sql.md
      • rtrim-transact-sql.md
      • schema-id-transact-sql.md
      • schema-name-transact-sql.md
      • scope-identity-transact-sql.md
      • security-functions-transact-sql.md
      • servername-transact-sql.md
      • serverproperty-transact-sql.md
      • servicename-transact-sql.md
      • session-context-transact-sql.md
      • session-id-transact-sql.md
      • session-user-transact-sql.md
      • sessionproperty-transact-sql.md
      • sign-transact-sql.md
      • signbyasymkey-transact-sql.md
      • signbycert-transact-sql.md
      • sin-transact-sql.md
      • smalldatetimefromparts-transact-sql.md
      • soundex-transact-sql.md
      • space-transact-sql.md
      • spid-transact-sql.md
      • sql-variant-property-transact-sql.md
      • sqrt-transact-sql.md
      • square-transact-sql.md
      • stats-date-transact-sql.md
      • stdev-transact-sql.md
      • stdevp-transact-sql.md
      • str-transact-sql.md
      • string-agg-transact-sql.md
      • string-escape-transact-sql.md
      • string-functions-transact-sql.md
      • string-split-transact-sql.md
      • stuff-transact-sql.md
      • substring-transact-sql.md
      • sum-transact-sql.md
      • suser-id-transact-sql.md
      • suser-name-transact-sql.md
      • suser-sid-transact-sql.md
      • suser-sname-transact-sql.md
      • switchoffset-transact-sql.md
      • symkeyproperty-transact-sql.md
      • sysdatetime-transact-sql.md
      • sysdatetimeoffset-transact-sql.md
      • system-functions-transact-sql.md
      • system-statistical-functions-transact-sql.md
      • system-user-transact-sql.md
      • sysutcdatetime-transact-sql.md
      • tan-transact-sql.md
      • text-and-image-functions-textptr-transact-sql.md
      • text-and-image-functions-textvalid-transact-sql.md
      • textsize-transact-sql.md
      • timefromparts-transact-sql.md
      • timeticks-transact-sql.md
      • todatetimeoffset-transact-sql.md
      • total-errors-transact-sql.md
      • total-read-transact-sql.md
      • total-write-transact-sql.md
      • trancount-transact-sql.md
      • translate-transact-sql.md
      • trigger-functions-transact-sql.md
      • trigger-nestlevel-transact-sql.md
      • trim-transact-sql.md
      • try-cast-transact-sql.md
      • try-convert-transact-sql.md
      • try-parse-transact-sql.md
      • type-id-transact-sql.md
      • type-name-transact-sql.md
      • typeproperty-transact-sql.md
      • unicode-transact-sql.md
      • update-trigger-functions-transact-sql.md
      • upper-transact-sql.md
      • user-id-transact-sql.md
      • user-name-transact-sql.md
      • user-transact-sql.md
      • var-transact-sql.md
      • varp-transact-sql.md
      • verifysignedbyasymkey-transact-sql.md
      • verifysignedbycert-transact-sql.md
      • version-transact-sql-configuration-functions.md
      • version-transact-sql-metadata-functions.md
      • xact-state-transact-sql.md
      • year-transact-sql.md
    • language-elements
      • add-equals-transact-sql.md
      • add-transact-sql.md
      • all-transact-sql.md
      • and-transact-sql.md
      • any-transact-sql.md
      • arithmetic-operators-transact-sql.md
      • assignment-operator-transact-sql.md
      • begin-distributed-transaction-transact-sql.md
      • begin-end-transact-sql.md
      • begin-transaction-transact-sql.md
      • between-transact-sql.md
      • bitwise-and-equals-transact-sql.md
      • bitwise-and-transact-sql.md
      • bitwise-exclusive-or-equals-transact-sql.md
      • bitwise-exclusive-or-transact-sql.md
      • bitwise-not-transact-sql.md
      • bitwise-operators-transact-sql.md
      • bitwise-or-equals-transact-sql.md
      • bitwise-or-transact-sql.md
      • break-transact-sql.md
      • case-transact-sql.md
      • checkpoint-transact-sql.md
      • close-transact-sql.md
      • coalesce-transact-sql.md
      • comment-transact-sql.md
      • commit-transaction-transact-sql.md
      • commit-work-transact-sql.md
      • comparison-operators-transact-sql.md
      • compound-operators-transact-sql.md
      • continue-transact-sql.md
      • control-of-flow.md
      • create-diagnostics-session-transact-sql.md
      • cursors-transact-sql.md
      • deallocate-transact-sql.md
      • declare-cursor-transact-sql.md
      • declare-local-variable-transact-sql.md
      • divide-equals-transact-sql.md
      • divide-transact-sql.md
      • else-if-else-transact-sql.md
      • end-begin-end-transact-sql.md
      • equals-transact-sql.md
      • execute-transact-sql.md
      • exists-transact-sql.md
      • expressions-transact-sql.md
      • fetch-transact-sql.md
      • goto-transact-sql.md
      • greater-than-or-equal-to-transact-sql.md
      • greater-than-transact-sql.md
      • if-else-transact-sql.md
      • in-transact-sql.md
      • kill-query-notification-subscription-transact-sql.md
      • kill-stats-job-transact-sql.md
      • kill-transact-sql.md
      • language-elements-transact-sql.md
      • less-than-or-equal-to-transact-sql.md
      • less-than-transact-sql.md
      • like-transact-sql.md
      • logical-operators-transact-sql.md
      • modulo-equals-transact-sql.md
      • modulo-transact-sql.md
      • multiply-equals-transact-sql.md
      • multiply-transact-sql.md
      • not-equal-to-transact-sql-exclamation.md
      • not-equal-to-transact-sql-traditional.md
      • not-greater-than-transact-sql.md
      • not-less-than-transact-sql.md
      • not-transact-sql.md
      • null-and-unknown-transact-sql.md
      • nullif-transact-sql.md
      • open-transact-sql.md
      • operator-precedence-transact-sql.md
      • operators-transact-sql.md
      • or-transact-sql.md
      • percent-character-wildcard-character-s-to-match-transact-sql.md
      • print-transact-sql.md
      • raiserror-transact-sql.md
      • reconfigure-transact-sql.md
      • reserved-keywords-transact-sql.md
      • return-transact-sql.md
      • rollback-transaction-transact-sql.md
      • rollback-work-transact-sql.md
      • save-transaction-transact-sql.md
      • scope-resolution-operator-transact-sql.md
      • select-local-variable-transact-sql.md
      • set-local-variable-transact-sql.md
      • set-operators-except-and-intersect-transact-sql.md
      • set-operators-union-transact-sql.md
      • shutdown-transact-sql.md
      • slash-star-comment-transact-sql.md
      • some-any-transact-sql.md
      • sql-server-utilities-statements-backslash.md
      • sql-server-utilities-statements-go.md
      • string-concatenation-equal-transact-sql.md
      • string-concatenation-transact-sql.md
      • string-operators-transact-sql.md
      • subtract-equals-transact-sql.md
      • subtract-transact-sql.md
      • throw-transact-sql.md
      • transact-sql-syntax-conventions-transact-sql.md
      • transaction-isolation-levels.md
      • transactions-sql-data-warehouse.md
      • transactions-transact-sql.md
      • try-catch-transact-sql.md
      • unary-operators-negative.md
      • unary-operators-positive.md
      • use-transact-sql.md
      • variables-transact-sql.md
      • waitfor-transact-sql.md
      • while-transact-sql.md
      • wildcard-character-s-not-to-match-transact-sql.md
      • wildcard-character-s-to-match-transact-sql.md
      • wildcard-match-one-character-transact-sql.md
    • language-reference.md
    • lesson-1-1-creating-a-database.md
    • lesson-1-2-creating-a-table.md
    • lesson-1-3-inserting-and-updating-data-in-a-table.md
    • lesson-1-4-reading-the-data-in-a-table.md
    • lesson-1-5-summary-creating-database-objects.md
    • lesson-1-creating-database-objects.md
    • lesson-2-1-creating-a-login.md
    • lesson-2-2-granting-access-to-a-database.md
    • lesson-2-3-creating-views-and-stored-procedures.md
    • lesson-2-4-granting-access-to-a-database-object.md
    • lesson-2-5-summary-configuring-permissions-on-database-objects.md
    • lesson-2-configuring-permissions-on-database-objects.md
    • lesson-3-1-deleting-database-objects.md
    • lesson-3-deleting-database-objects.md
    • queries
      • aliasing-azure-sql-data-warehouse-parallel-data-warehouse.md
      • at-time-zone-transact-sql.md
      • contains-transact-sql.md
      • explain-transact-sql.md
      • freetext-transact-sql.md
      • from-transact-sql.md
      • from-using-pivot-and-unpivot.md
      • hints-transact-sql-join.md
      • hints-transact-sql-query.md
      • hints-transact-sql-table.md
      • hints-transact-sql.md
      • is-null-transact-sql.md
      • match-sql-graph.md
      • option-clause-transact-sql.md
      • output-clause-transact-sql.md
      • predicates.md
      • predict-transact-sql.md
      • queries.md
      • readtext-transact-sql.md
      • search-condition-transact-sql.md
      • select-clause-transact-sql.md
      • select-examples-transact-sql.md
      • select-for-clause-transact-sql.md
      • select-group-by-transact-sql.md
      • select-having-transact-sql.md
      • select-into-clause-transact-sql.md
      • select-order-by-clause-transact-sql.md
      • select-over-clause-transact-sql.md
      • select-sql-graph.md
      • select-transact-sql.md
      • subqueries-azure-sql-data-warehouse-parallel-data-warehouse.md
      • table-value-constructor-transact-sql.md
      • top-transact-sql.md
      • update-transact-sql.md
      • updatetext-transact-sql.md
      • where-transact-sql.md
      • with-common-table-expression-transact-sql.md
      • writetext-transact-sql.md
    • spatial-geography
      • asbinaryzm-geography-data-type.md
      • asgml-geography-data-type.md
      • astextzm-geography-data-type.md
      • bufferwithcurves-geography-data-type.md
      • bufferwithtolerance-geography-data-type.md
      • collectionaggregate-geography-data-type.md
      • convexhullaggregate-geography-data-type.md
      • curvetolinewithtolerance-geography-data-type.md
      • envelopeaggregate-geography-data-type.md
      • envelopeangle-geography-data-type.md
      • envelopecenter-geography-data-type.md
      • extended-methods-on-geography-instances.md
      • extended-static-geography-methods.md
      • filter-geography-data-type.md
      • geomfromgml-geography-data-type.md
      • hasm-geography-data-type.md
      • hasz-geography-data-type.md
      • instanceof-geography-data-type.md
      • isnull-geography-data-type.md
      • isvaliddetailed-geography-data-type.md
      • lat-geography-data-type.md
      • long-geography-data-type.md
      • m-geography-data-type.md
      • makevalid-geography-data-type.md
      • mindbcompatibilitylevel-geography-data-type.md
      • null-geography-data-type.md
      • numrings-geography-data-type.md
      • ogc-methods-on-geography-instances.md
      • ogc-static-geography-methods.md
      • parse-geography-data-type.md
      • point-geography-data-type.md
      • reduce-geography-data-type.md
      • reorientobject-geography-data-type.md
      • ringn-geography-data-type.md
      • shortestlineto-geography-data-type.md
      • spatial-types-geography.md
      • starea-geography-data-type.md
      • stasbinary-geography-data-type.md
      • stastext-geography-data-type.md
      • static-aggregate-geography-methods.md
      • stbuffer-geography-data-type.md
      • stcontains-geography-data-type.md
      • stconvexhull-geography-data-type.md
      • stcurven-geography-data-type.md
      • stcurvetoline-geography-data-type.md
      • stdifference-geography-data-type.md
      • stdimension-geography-data-type.md
      • stdisjoint-geography-data-type.md
      • stdistance-geography-data-type.md
      • stendpoint-geography-data-type.md
      • stequals-geography-data-type.md
      • stgeomcollfromtext-geography-data-type.md
      • stgeomcollfromwkb-geography-data-type.md
      • stgeometryn-geography-data-type.md
      • stgeometrytype-geography-data-type.md
      • stgeomfromtext-geography-data-type.md
      • stgeomfromwkb-geography-data-type.md
      • stintersection-geography-data-type.md
      • stintersects-geography-data-type.md
      • stisclosed-geography-data-type.md
      • stisempty-geography-data-type.md
      • stisvalid-geography-data-type.md
      • stlength-geography-data-type.md
      • stlinefromtext-geography-data-type.md
      • stlinefromwkb-geography-data-type.md
      • stmlinefromtext-geography-data-type.md
      • stmlinefromwkb-geography-data-type.md
      • stmpointfromtext-geography-data-type.md
      • stmpointfromwkb-geography-data-type.md
      • stmpolyfromtext-geography-data-type.md
      • stmpolyfromwkb-geography-data-type.md
      • stnumcurves-geography-data-type.md
      • stnumgeometries-geography-data-type.md
      • stnumpoints-geography-data-type.md
      • stoverlaps-geography-data-type.md
      • stpointfromtext-geography-data-type.md
      • stpointfromwkb-geography-data-type.md
      • stpointn-geography-data-type.md
      • stpolyfromtext-geography-data-type.md
      • stpolyfromwkb-geography-data-type.md
      • stsrid-geography-data-type.md
      • ststartpoint-geography-data-type.md
      • stsymdifference-geography-data-type.md
      • stunion-geography-data-type.md
      • stwithin-geography-data-type.md
      • tostring-geography-data-type.md
      • unionaggregate-geography-data-type.md
      • z-geography-data-type.md
    • spatial-geometry
      • asbinaryzm-geometry-datatype.md
      • asgml-geometry-data-type.md
      • astextzm-geometry-data-type.md
      • bufferwithcurves-geometry-data-type.md
      • bufferwithtolerance-geometry-data-type.md
      • collectionaggregate-geometry-data-type.md
      • convexhullaggregate-geometry-data-type.md
      • curvetolinewithtolerance-geometry-data-type.md
      • envelopeaggregate-geometry-data-type.md
      • extended-methods-on-geometry-instances.md
      • extended-static-geometry-methods.md
      • filter-geometry-data-type.md
      • geomfromgml-geometry-data-type.md
      • hasm-geometry-datatype.md
      • hasz-geometry-datatype.md
      • instanceof-geometry-data-type.md
      • isnull-geometry-data-type.md
      • isvaliddetailed-geometry-datatype.md
      • m-geometry-data-type.md
      • makevalid-geometry-data-type.md
      • mindbcompatibilitylevel-geometry-data-type.md
      • null-geometry-data-type.md
      • ogc-methods-on-geometry-instances.md
      • ogc-static-geometry-methods.md
      • parse-geometry-data-type.md
      • point-geometry-data-type.md
      • reduce-geometry-data-type.md
      • shortestlineto-geometry-data-type.md
      • spatial-types-geometry-transact-sql.md
      • starea-geometry-data-type.md
      • stasbinary-geometry-data-type.md
      • stastext-geometry-data-type.md
      • static-aggregate-geometry-methods.md
      • stboundary-geometry-data-type.md
      • stbuffer-geometry-data-type.md
      • stcentroid-geometry-data-type.md
      • stcontains-geometry-data-type.md
      • stconvexhull-geometry-data-type.md
      • stcrosses-geometry-data-type.md
      • stcurven-geometry-data-type.md
      • stcurvetoline-geometry-data-type.md
      • stdifference-geometry-data-type.md
      • stdimension-geometry-data-type.md
      • stdisjoint-geometry-data-type.md
      • stdistance-geometry-data-type.md
      • stendpoint-geometry-data-type.md
      • stenvelope-geometry-data-type.md
      • stequals-geometry-data-type.md
      • stexteriorring-geometry-data-type.md
      • stgeomcollfromtext-geometry-data-type.md
      • stgeomcollfromwkb-geometry-data-type.md
      • stgeometryn-geometry-data-type.md
      • stgeometrytype-geometry-data-type.md
      • stgeomfromtext-geometry-data-type.md
      • stgeomfromwkb-geometry-data-type.md
      • stinteriorringn-geometry-data-type.md
      • stintersection-geometry-data-type.md
      • stintersects-geometry-data-type.md
      • stisclosed-geometry-data-type.md
      • stisempty-geometry-data-type.md
      • stisring-geometry-data-type.md
      • stissimple-geometry-data-type.md
      • stisvalid-geometry-data-type.md
      • stlength-geometry-data-type.md
      • stlinefromtext-geometry-data-type.md
      • stlinefromwkb-geometry-data-type.md
      • stmlinefromtext-geometry-data-type.md
      • stmlinefromwkb-geometry-data-type.md
      • stmpointfromtext-geometry-data-type.md
      • stmpointfromwkb-geometry-data-type.md
      • stmpolyfromtext-geometry-data-type.md
      • stmpolyfromwkb-geometry-data-type.md
      • stnumcurves-geometry-data-type.md
      • stnumgeometries-geometry-data-type.md
      • stnuminteriorring-geometry-data-type.md
      • stnumpoints-geometry-data-type.md
      • stoverlaps-geometry-data-type.md
      • stpointfromtext-geometry-data-type.md
      • stpointfromwkb-geometry-data-type.md
      • stpointn-geometry-data-type.md
      • stpointonsurface-geometry-data-type.md
      • stpolyfromtext-geometry-data-type.md
      • stpolyfromwkb-geometry-data-type.md
      • strelate-geometry-data-type.md
      • stsrid-geometry-data-type.md
      • ststartpoint-geometry-data-type.md
      • stsymdifference-geometry-data-type.md
      • sttouches-geometry-data-type.md
      • stunion-geometry-data-type.md
      • stwithin-geometry-data-type.md
      • stx-geometry-data-type.md
      • sty-geometry-data-type.md
      • tostring-geometry-data-type.md
      • unionaggregate-geometry-data-type.md
      • z-geometry-data-type.md
    • statements
      • add-signature-transact-sql.md
      • alter-application-role-transact-sql.md
      • alter-assembly-transact-sql.md
      • alter-asymmetric-key-transact-sql.md
      • alter-authorization-transact-sql.md
      • alter-availability-group-transact-sql.md
      • alter-broker-priority-transact-sql.md
      • alter-certificate-transact-sql.md
      • alter-column-encryption-key-transact-sql.md
      • alter-credential-transact-sql.md
      • alter-cryptographic-provider-transact-sql.md
      • alter-database-audit-specification-transact-sql.md
      • alter-database-encryption-key-transact-sql.md
      • alter-database-parallel-data-warehouse.md
      • alter-database-scoped-configuration-transact-sql.md
      • alter-database-scoped-credential-transact-sql.md
      • alter-database-transact-sql-compatibility-level.md
      • alter-database-transact-sql-database-mirroring.md
      • alter-database-transact-sql-file-and-filegroup-options.md
      • alter-database-transact-sql-set-hadr.md
      • alter-database-transact-sql-set-options.md
      • alter-database-transact-sql.md
      • alter-endpoint-transact-sql.md
      • alter-event-session-transact-sql.md
      • alter-external-data-source-transact-sql.md
      • alter-external-library-transact-sql.md
      • alter-external-resource-pool-transact-sql.md
      • alter-fulltext-catalog-transact-sql.md
      • alter-fulltext-index-transact-sql.md
      • alter-fulltext-stoplist-transact-sql.md
      • alter-function-transact-sql.md
      • alter-index-selective-xml-indexes.md
      • alter-index-transact-sql.md
      • alter-login-transact-sql.md
      • alter-master-key-transact-sql.md
      • alter-message-type-transact-sql.md
      • alter-partition-function-transact-sql.md
      • alter-partition-scheme-transact-sql.md
      • alter-procedure-transact-sql.md
      • alter-queue-transact-sql.md
      • alter-remote-service-binding-transact-sql.md
      • alter-resource-governor-transact-sql.md
      • alter-resource-pool-transact-sql.md
      • alter-role-transact-sql.md
      • alter-route-transact-sql.md
      • alter-schema-transact-sql.md
      • alter-search-property-list-transact-sql.md
      • alter-security-policy-transact-sql.md
      • alter-sequence-transact-sql.md
      • alter-server-audit-specification-transact-sql.md
      • alter-server-audit-transact-sql.md
      • alter-server-configuration-transact-sql.md
      • alter-server-role-transact-sql.md
      • alter-service-master-key-transact-sql.md
      • alter-service-transact-sql.md
      • alter-symmetric-key-transact-sql.md
      • alter-table-column-constraint-transact-sql.md
      • alter-table-column-definition-transact-sql.md
      • alter-table-computed-column-definition-transact-sql.md
      • alter-table-index-option-transact-sql.md
      • alter-table-table-constraint-transact-sql.md
      • alter-table-transact-sql.md
      • alter-trigger-transact-sql.md
      • alter-user-transact-sql.md
      • alter-view-transact-sql.md
      • alter-workload-group-transact-sql.md
      • alter-xml-schema-collection-transact-sql.md
      • backup-certificate-transact-sql.md
      • backup-database-parallel-data-warehouse.md
      • backup-master-key-transact-sql.md
      • backup-service-master-key-transact-sql.md
      • backup-transact-sql.md
      • begin-conversation-timer-transact-sql.md
      • begin-dialog-conversation-transact-sql.md
      • bulk-insert-transact-sql.md
      • close-master-key-transact-sql.md
      • close-symmetric-key-transact-sql.md
      • collation-precedence-transact-sql.md
      • collations.md
      • create-aggregate-transact-sql.md
      • create-application-role-transact-sql.md
      • create-assembly-transact-sql.md
      • create-asymmetric-key-transact-sql.md
      • create-availability-group-transact-sql.md
      • create-broker-priority-transact-sql.md
      • create-certificate-transact-sql.md
      • create-column-encryption-key-transact-sql.md
      • create-column-master-key-transact-sql.md
      • create-columnstore-index-transact-sql.md
      • create-contract-transact-sql.md
      • create-credential-transact-sql.md
      • create-cryptographic-provider-transact-sql.md
      • create-database-audit-specification-transact-sql.md
      • create-database-encryption-key-transact-sql.md
      • create-database-parallel-data-warehouse.md
      • create-database-scoped-credential-transact-sql.md
      • create-database-sql-server-transact-sql.md
      • create-default-transact-sql.md
      • create-endpoint-transact-sql.md
      • create-event-notification-transact-sql.md
      • create-event-session-transact-sql.md
      • create-external-data-source-transact-sql.md
      • create-external-file-format-transact-sql.md
      • create-external-library-transact-sql.md
      • create-external-resource-pool-transact-sql.md
      • create-external-table-transact-sql.md
      • create-fulltext-catalog-transact-sql.md
      • create-fulltext-index-transact-sql.md
      • create-fulltext-stoplist-transact-sql.md
      • create-function-sql-data-warehouse.md
      • create-function-transact-sql.md
      • create-index-transact-sql.md
      • create-login-transact-sql.md
      • create-master-key-transact-sql.md
      • create-message-type-transact-sql.md
      • create-partition-function-transact-sql.md
      • create-partition-scheme-transact-sql.md
      • create-procedure-transact-sql.md
      • create-queue-transact-sql.md
      • create-remote-service-binding-transact-sql.md
      • create-resource-pool-transact-sql.md
      • create-role-transact-sql.md
      • create-route-transact-sql.md
      • create-rule-transact-sql.md
      • create-schema-transact-sql.md
      • create-search-property-list-transact-sql.md
      • create-security-policy-transact-sql.md
      • create-selective-xml-index-transact-sql.md
      • create-sequence-transact-sql.md
      • create-server-audit-specification-transact-sql.md
      • create-server-audit-transact-sql.md
      • create-server-role-transact-sql.md
      • create-service-transact-sql.md
      • create-spatial-index-transact-sql.md
      • create-statistics-transact-sql.md
      • create-symmetric-key-transact-sql.md
      • create-synonym-transact-sql.md
      • create-table-sql-graph.md
      • create-table-transact-sql-identity-property.md
      • create-table-transact-sql.md
      • create-trigger-transact-sql.md
      • create-type-transact-sql.md
      • create-user-transact-sql.md
      • create-view-transact-sql.md
      • create-workload-group-transact-sql.md
      • create-xml-index-selective-xml-indexes.md
      • create-xml-index-transact-sql.md
      • create-xml-schema-collection-transact-sql.md
      • delete-transact-sql.md
      • deny-assembly-permissions-transact-sql.md
      • deny-asymmetric-key-permissions-transact-sql.md
      • deny-availability-group-permissions-transact-sql.md
      • deny-certificate-permissions-transact-sql.md
      • deny-database-permissions-transact-sql.md
      • deny-database-principal-permissions-transact-sql.md
      • deny-database-scoped-credential-transact-sql.md
      • deny-endpoint-permissions-transact-sql.md
      • deny-full-text-permissions-transact-sql.md
      • deny-object-permissions-transact-sql.md
      • deny-schema-permissions-transact-sql.md
      • deny-search-property-list-permissions-transact-sql.md
      • deny-server-permissions-transact-sql.md
      • deny-server-principal-permissions-transact-sql.md
      • deny-service-broker-permissions-transact-sql.md
      • deny-symmetric-key-permissions-transact-sql.md
      • deny-system-object-permissions-transact-sql.md
      • deny-transact-sql.md
      • deny-type-permissions-transact-sql.md
      • deny-xml-schema-collection-permissions-transact-sql.md
      • disable-trigger-transact-sql.md
      • drop-aggregate-transact-sql.md
      • drop-application-role-transact-sql.md
      • drop-assembly-transact-sql.md
      • drop-asymmetric-key-transact-sql.md
      • drop-availability-group-transact-sql.md
      • drop-broker-priority-transact-sql.md
      • drop-certificate-transact-sql.md
      • drop-column-encryption-key-transact-sql.md
      • drop-column-master-key-transact-sql.md
      • drop-contract-transact-sql.md
      • drop-credential-transact-sql.md
      • drop-cryptographic-provider-transact-sql.md
      • drop-database-audit-specification-transact-sql.md
      • drop-database-encryption-key-transact-sql.md
      • drop-database-scoped-credential-transact-sql.md
      • drop-database-transact-sql.md
      • drop-default-transact-sql.md
      • drop-endpoint-transact-sql.md
      • drop-event-notification-transact-sql.md
      • drop-event-session-transact-sql.md
      • drop-external-data-source-transact-sql.md
      • drop-external-file-format-transact-sql.md
      • drop-external-library-transact-sql.md
      • drop-external-resource-pool-transact-sql.md
      • drop-external-table-transact-sql.md
      • drop-fulltext-catalog-transact-sql.md
      • drop-fulltext-index-transact-sql.md
      • drop-fulltext-stoplist-transact-sql.md
      • drop-function-transact-sql.md
      • drop-index-selective-xml-indexes.md
      • drop-index-transact-sql.md
      • drop-login-transact-sql.md
      • drop-master-key-transact-sql.md
      • drop-message-type-transact-sql.md
      • drop-partition-function-transact-sql.md
      • drop-partition-scheme-transact-sql.md
      • drop-procedure-transact-sql.md
      • drop-queue-transact-sql.md
      • drop-remote-service-binding-transact-sql.md
      • drop-resource-pool-transact-sql.md
      • drop-role-transact-sql.md
      • drop-route-transact-sql.md
      • drop-rule-transact-sql.md
      • drop-schema-transact-sql.md
      • drop-search-property-list-transact-sql.md
      • drop-security-policy-transact-sql.md
      • drop-sequence-transact-sql.md
      • drop-server-audit-specification-transact-sql.md
      • drop-server-audit-transact-sql.md
      • drop-server-role-transact-sql.md
      • drop-service-transact-sql.md
      • drop-signature-transact-sql.md
      • drop-statistics-transact-sql.md
      • drop-symmetric-key-transact-sql.md
      • drop-synonym-transact-sql.md
      • drop-table-transact-sql.md
      • drop-trigger-transact-sql.md
      • drop-type-transact-sql.md
      • drop-user-transact-sql.md
      • drop-view-transact-sql.md
      • drop-workload-group-transact-sql.md
      • drop-xml-schema-collection-transact-sql.md
      • enable-trigger-transact-sql.md
      • end-conversation-transact-sql.md
      • execute-as-clause-transact-sql.md
      • execute-as-transact-sql.md
      • get-conversation-group-transact-sql.md
      • get-transmission-status-transact-sql.md
      • grant-assembly-permissions-transact-sql.md
      • grant-asymmetric-key-permissions-transact-sql.md
      • grant-availability-group-permissions-transact-sql.md
      • grant-certificate-permissions-transact-sql.md
      • grant-database-permissions-transact-sql.md
      • grant-database-principal-permissions-transact-sql.md
      • grant-database-scoped-credential-transact-sql.md
      • grant-endpoint-permissions-transact-sql.md
      • grant-full-text-permissions-transact-sql.md
      • grant-object-permissions-transact-sql.md
      • grant-schema-permissions-transact-sql.md
      • grant-search-property-list-permissions-transact-sql.md
      • grant-server-permissions-transact-sql.md
      • grant-server-principal-permissions-transact-sql.md
      • grant-service-broker-permissions-transact-sql.md
      • grant-symmetric-key-permissions-transact-sql.md
      • grant-system-object-permissions-transact-sql.md
      • grant-transact-sql.md
      • grant-type-permissions-transact-sql.md
      • grant-xml-schema-collection-permissions-transact-sql.md
      • insert-sql-graph.md
      • insert-transact-sql.md
      • merge-transact-sql.md
      • move-conversation-transact-sql.md
      • open-master-key-transact-sql.md
      • open-symmetric-key-transact-sql.md
      • permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md
      • receive-transact-sql.md
      • restore-database-parallel-data-warehouse.md
      • restore-master-key-transact-sql.md
      • restore-service-master-key-transact-sql.md
      • restore-statements-arguments-transact-sql.md
      • restore-statements-filelistonly-transact-sql.md
      • restore-statements-for-restoring-recovering-and-managing-backups-transact-sql.md
      • restore-statements-headeronly-transact-sql.md
      • restore-statements-labelonly-transact-sql.md
      • restore-statements-rewindonly-transact-sql.md
      • restore-statements-transact-sql.md
      • restore-statements-verifyonly-transact-sql.md
      • revert-transact-sql.md
      • revoke-assembly-permissions-transact-sql.md
      • revoke-asymmetric-key-permissions-transact-sql.md
      • revoke-availability-group-permissions-transact-sql.md
      • revoke-certificate-permissions-transact-sql.md
      • revoke-database-permissions-transact-sql.md
      • revoke-database-principal-permissions-transact-sql.md
      • revoke-database-scoped-credential-transact-sql.md
      • revoke-endpoint-permissions-transact-sql.md
      • revoke-full-text-permissions-transact-sql.md
      • revoke-object-permissions-transact-sql.md
      • revoke-schema-permissions-transact-sql.md
      • revoke-search-property-list-permissions-transact-sql.md
      • revoke-server-permissions-transact-sql.md
      • revoke-server-principal-permissions-transact-sql.md
      • revoke-service-broker-permissions-transact-sql.md
      • revoke-symmetric-key-permissions-transact-sql.md
      • revoke-system-object-permissions-transact-sql.md
      • revoke-transact-sql.md
      • revoke-type-permissions-transact-sql.md
      • revoke-xml-schema-collection-permissions-transact-sql.md
      • send-transact-sql.md
      • set-ansi-defaults-transact-sql.md
      • set-ansi-null-dflt-off-transact-sql.md
      • set-ansi-null-dflt-on-transact-sql.md
      • set-ansi-nulls-transact-sql.md
      • set-ansi-padding-transact-sql.md
      • set-ansi-warnings-transact-sql.md
      • set-arithabort-transact-sql.md
      • set-arithignore-transact-sql.md
      • set-concat-null-yields-null-transact-sql.md
      • set-context-info-transact-sql.md
      • set-cursor-close-on-commit-transact-sql.md
      • set-datefirst-transact-sql.md
      • set-dateformat-transact-sql.md
      • set-deadlock-priority-transact-sql.md
      • set-fips-flagger-transact-sql.md
      • set-fmtonly-transact-sql.md
      • set-forceplan-transact-sql.md
      • set-identity-insert-transact-sql.md
      • set-implicit-transactions-transact-sql.md
      • set-language-transact-sql.md
      • set-lock-timeout-transact-sql.md
      • set-nocount-transact-sql.md
      • set-noexec-transact-sql.md
      • set-numeric-roundabort-transact-sql.md
      • set-offsets-transact-sql.md
      • set-parseonly-transact-sql.md
      • set-query-governor-cost-limit-transact-sql.md
      • set-quoted-identifier-transact-sql.md
      • set-remote-proc-transactions-transact-sql.md
      • set-rowcount-transact-sql.md
      • set-showplan-all-transact-sql.md
      • set-showplan-text-transact-sql.md
      • set-showplan-xml-transact-sql.md
      • set-statements-transact-sql.md
      • set-statistics-io-transact-sql.md
      • set-statistics-profile-transact-sql.md
      • set-statistics-time-transact-sql.md
      • set-statistics-xml-transact-sql.md
      • set-textsize-transact-sql.md
      • set-transaction-isolation-level-transact-sql.md
      • set-xact-abort-transact-sql.md
      • setuser-transact-sql.md
      • sql-server-collation-name-transact-sql.md
      • statements.md
      • truncate-table-transact-sql.md
      • update-statistics-transact-sql.md
      • windows-collation-name-transact-sql.md
    • tutorial-writing-transact-sql-statements.md
    • xml
      • binding-relational-data-inside-xml-data.md
      • delete-xml-dml.md
      • exist-method-xml-data-type.md
      • guidelines-for-using-xml-data-type-methods.md
      • insert-xml-dml.md
      • modify-method-xml-data-type.md
      • nodes-method-xml-data-type.md
      • query-method-xml-data-type.md
      • replace-value-of-xml-dml.md
      • value-method-xml-data-type.md
      • with-xmlnamespaces.md
      • xml-data-modification-language-xml-dml.md
      • xml-data-type-methods.md
      • xml-schema-namespace.md
      • xml-transact-sql.md