File tree

• docs/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
    • nondeterministic-convert-date-literals.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-dropresultsetcache-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-pdw-showexecutionplan-transact-sql.md
    • dbcc-pdw-showmaterializedviewoverhead-transact-sql.md
    • dbcc-pdw-showpartitionstats-transact-sql.md
    • dbcc-pdw-showspaceused-transact-sql.md
    • dbcc-proccache-transact-sql.md
    • dbcc-show-statistics-transact-sql.md
    • dbcc-showcontig-transact-sql.md
    • dbcc-showresultcachespaceused-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
    • approx-count-distinct-transact-sql.md
    • ascii-transact-sql.md
    • asin-transact-sql.md
    • assemblyproperty-transact-sql.md
    • asymkey-id-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
    • 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-timezone-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-creating-database-objects.md
  • lesson-2-configuring-permissions-on-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
    • 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-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-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-materialized-view-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-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-scoped-credential-transact-sql.md
    • create-database-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-table-as-select-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-materialized-view-as-select-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-remote-table-as-select-parallel-data-warehouse.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-as-select-azure-sql-data-warehouse.md
    • create-table-azure-sql-data-warehouse.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-classifier-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-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-classifier-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
    • rename-transact-sql.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-result-set-caching-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