File tree

• docs
  • includes/paragraph-content
    • specify-application-intent-read-only-routing.md
  • relational-databases
    • extended-events
      • advanced-viewing-of-target-data-from-extended-events-in-sql-server.md
      • alter-an-extended-events-session.md
      • convert-an-existing-sql-trace-script-to-an-extended-events-session.md
      • determine-which-queries-are-holding-locks.md
      • event-tracing-for-windows-target.md
      • extended-events-tools.md
      • extended-events.md
      • find-the-objects-that-have-the-most-locks-taken-on-them.md
      • manage-event-sessions-in-the-object-explorer.md
      • monitor-system-activity-using-extended-events.md
      • quick-start-extended-events-in-sql-server.md
      • selects-and-joins-from-system-views-for-extended-events-in-sql-server.md
      • sql-server-extended-events-engine.md
      • sql-server-extended-events-packages.md
      • sql-server-extended-events-sessions.md
      • targets-for-extended-events-in-sql-server.md
      • use-the-powershell-provider-for-extended-events.md
      • use-the-system-health-session.md
      • view-the-extended-events-equivalents-to-sql-trace-event-classes.md
      • xevents-references-system-objects.md
    • in-memory-oltp
      • a-guide-to-query-processing-for-memory-optimized-tables.md
      • accessing-memory-optimized-tables-using-interpreted-transact-sql.md
      • altering-memory-optimized-tables.md
      • altering-natively-compiled-t-sql-modules.md
      • application-pattern-for-partitioning-memory-optimized-tables.md
      • blog-hardware-in-memory-oltp.md
      • create-and-access-tables-in-tempdb-from-stored-procedures.md
      • cross-database-queries.md
      • determining-if-a-table-or-stored-procedure-should-be-ported-to-in-memory-oltp.md
      • hash-indexes-for-memory-optimized-tables.md
      • implementing-a-case-expression-in-a-natively-compiled-stored-procedure.md
      • implementing-an-outer-join.md
      • implementing-identity-in-a-memory-optimized-table.md
      • implementing-merge-functionality-in-a-natively-compiled-stored-procedure.md
      • implementing-sql-variant-in-a-memory-optimized-table.md
      • implementing-update-with-from-or-subqueries.md
      • in-memory-oltp-in-memory-optimization.md
      • indexes-for-memory-optimized-tables.md
      • introduction-to-memory-optimized-tables.md
      • memory-optimization-advisor.md
      • migrating-computed-columns.md
      • migrating-triggers.md
      • native-compilation-advisor.md
      • native-compilation-of-tables-and-stored-procedures.md
      • plan-your-adoption-of-in-memory-oltp-features-in-sql-server.md
      • powershell-cmdlet-for-migration-evaluation.md
      • sample-database-for-in-memory-oltp.md
      • scalability.md
      • scalar-user-defined-functions-for-in-memory-oltp.md
      • simulating-an-if-while-exists-statement-in-a-natively-compiled-module.md
      • statistics-for-memory-optimized-tables.md
      • supported-data-types-for-in-memory-oltp.md
      • supported-ddl-for-natively-compiled-t-sql-modules.md
      • supported-features-for-natively-compiled-t-sql-modules.md
      • survey-of-initial-areas-in-in-memory-oltp.md
      • table-and-row-size-in-memory-optimized-tables.md
      • transact-sql-constructs-not-supported-by-in-memory-oltp.md
      • transact-sql-support-for-in-memory-oltp.md
      • transactions-with-memory-optimized-tables.md
      • unsupported-sql-server-features-for-in-memory-oltp.md
    • maintenance-plans
      • rebuild-index-task-maintenance-plan.md
      • reorganize-index-task-maintenance-plan.md
    • sqlxml-annotated-xsd-schemas-using
      • creating-cdata-sections-using-sql-use-cdata-sqlxml-4-0.md
      • creating-constant-elements-using-sql-is-constant-sqlxml-4-0.md
      • creating-valid-id-idref-and-idrefs-type-attributes-using-sql-prefix-sqlxml-4-0.md
      • data-type-coercions-and-the-sql-datatype-annotation-sqlxml-4-0.md
      • default-mapping-of-xsd-elements-and-attributes-to-tables-and-columns-sqlxml-4-0.md
      • excluding-schema-elements-from-the-xml-document-using-sql-mapped.md
      • explicit-mapping-xsd-elements-and-attributes-to-tables-and-columns.md
      • filtering-values-using-sql-limit-field-and-sql-limit-value-sqlxml-4-0.md
      • hiding-elements-and-attributes-by-using-sql-hide.md
      • identifying-key-columns-using-sql-key-fields-sqlxml-4-0.md
      • mapping-xsd-data-types-to-xpath-data-types-sqlxml-4-0.md
      • requesting-url-references-to-blob-data-using-sql-encode-sqlxml-4-0.md
      • retrieving-unconsumed-data-using-the-sql-overflow-field-sqlxml-4-0.md
      • specifying-a-target-namespace-using-the-targetnamespace-attribute-sqlxml-4-0.md
      • specifying-depth-in-recursive-relationships-by-using-sql-max-depth.md
      • specifying-relationships-using-sql-relationship-sqlxml-4-0.md
      • specifying-the-sql-inverse-attribute-on-sql-relationship-sqlxml-4-0.md
      • using-annotations-in-xsd-schemas-sqlxml-4-0.md
      • using-the-sql-identity-and-sql-guid-annotations.md
      • xsd-annotations-sqlxml-4-0.md
    • sqlxml-annotated-xsd-schemas-xpath-queries
      • bulk-load-xml
        • annotation-interpretation-other-annotations.md
        • annotation-interpretation-sql-limit-field-and-sql-limit-value.md
        • annotation-interpretation-sql-mapped.md
        • annotation-interpretation-sql-overflow-field.md
        • annotation-interpretation-sql-relationship-and-key-ordering-rule.md
        • annotation-interpretation-sqlxml-4-0.md
        • data-types-and-xml-bulk-load-behavior-sqlxml-4-0.md
        • guidelines-and-limitations-of-xml-bulk-load-sqlxml-4-0.md
        • introduction-to-xml-bulk-load-sqlxml-4-0.md
        • performing-bulk-load-of-xml-data-sqlxml-4-0.md
        • record-generation-process-sqlxml-4-0.md
        • sql-server-xml-bulk-load-object-model-sqlxml-4-0.md
        • xml-bulk-load-examples-sqlxml-4-0.md
      • caching-templates-xml-schemas
        • caching-templates-xsl-and-schemas-sqlxml-4-0.md
        • schema-caching-sqlxml-4-0.md
        • template-caching-sqlxml-4-0.md
        • xsl-caching-sqlxml-4-0.md
      • data-access-components-provider
        • applying-an-xsl-transformation-sqlxmloledb-provider.md
        • executing-sql-queries-sqlxmloledb-provider.md
        • executing-templates-that-contain-sql-queries-sqlxmloledb-provider.md
        • executing-templates-that-contain-xpath-queries-sqlxmloledb-provider.md
        • executing-xpath-queries-sqlxmloledb-provider.md
        • executing-xpath-queries-with-namespaces-sqlxmloledb-provider.md
        • introduction-to-the-sqlxmloledb-provider-sqlxml-4-0.md
        • sqlxml-4-0-data-access-components-sqlxmloledb-provider.md
        • using-the-sqlxmloledb-provider-sqlxml-4-0.md
      • diffgram
        • diffgram-examples-sqlxml-4-0.md
        • executing-a-diffgram-by-using-ado-sqlxml-4-0.md
        • executing-a-diffgram-by-using-sqlxml-managed-classes.md
        • guidelines-and-limitations-of-diffgrams-in-sqlxml.md
        • introduction-to-diffgrams-in-sqlxml-4-0.md
        • sqlxml-4-0-net-framework-support-using-diffgrams-to-modify-data.md
      • guidelines-and-limitations-of-sqlxml-4-0.md
      • introduction-to-using-xpath-queries-sqlxml-4-0.md
      • location-path
        • specifying-a-location-path-sqlxml-4-0.md
        • specifying-a-node-test-in-the-location-path-sqlxml-4-0.md
        • specifying-an-axis-sqlxml-4-0.md
        • specifying-selection-predicates-in-the-location-path-sqlxml-4-0.md
      • net-framework-classes
        • accessing-sqlxml-functionality-in-the-net-environment.md
        • applying-an-xsl-transformation-sqlxml-managed-classes.md
        • executing-sql-queries-by-using-the-executexmlreader-method.md
        • executing-sql-queries-sqlxml-managed-classes.md
        • executing-template-files-by-using-the-commandstream-property.md
        • executing-template-files-by-using-the-commandtext-property.md
        • executing-xpath-queries-sqlxml-managed-classes.md
        • executing-xpath-queries-with-namespaces-sqlxml-managed-classes.md
        • processing-xml-on-the-client-side-sqlxml-managed-classes.md
        • sqlxml-4-0-net-framework-support-managed-classes.md
        • sqlxml-managed-classes-sqlxmladapter-object.md
        • sqlxml-managed-classes-sqlxmlcommand-object.md
        • sqlxml-managed-classes-sqlxmlparameter-object.md
      • samples
        • sample-annotated-xsd-schema-for-xpath-examples-sqlxml-4-0.md
        • sample-xpath-queries-sqlxml-4-0.md
        • specifying-arithmetic-operators-in-xpath-queries-sqlxml-4-0.md
        • specifying-axes-in-xpath-queries-sqlxml-4-0.md
        • specifying-boolean-functions-in-xpath-queries-sqlxml-4-0.md
        • specifying-boolean-operators-in-xpath-queries-sqlxml-4-0.md
        • specifying-boolean-valued-predicates-in-xpath-queries-sqlxml-4-0.md
        • specifying-explicit-conversion-functions-in-xpath-queries-sqlxml-4-0.md
        • specifying-relational-operators-in-xpath-queries-sqlxml-4-0.md
        • specifying-xpath-variables-in-xpath-queries-sqlxml-4-0.md
      • security
        • annotated-schema-security-considerations-sqlxml-4-0.md
        • bulk-load-security-considerations-sqlxml-4-0.md
        • core-sqlxml-security-considerations.md
        • for-xml-security-considerations-sqlxml-4-0.md
        • sqlxml-4-0-security-considerations.md
        • updategram-security-considerations-sqlxml-4-0.md
      • sqlxml-4-0-net-framework-support-using-bulk-load.md
      • updategrams
        • deleting-data-using-xml-updategrams-sqlxml-4-0.md
        • executing-an-updategram-by-using-ado-sqlxml-4-0.md
        • executing-an-updategram-by-using-ole-db-sqlxml-4-0.md
        • guidelines-and-limitations-of-xml-updategrams-sqlxml-4-0.md
        • handling-database-concurrency-issues-in-updategrams-sqlxml-4-0.md
        • inserting-data-using-xml-updategrams-sqlxml-4-0.md
        • introduction-to-updategrams-sqlxml-4-0.md
        • null-handling-sqlxml-4-0.md
        • passing-parameters-to-updategrams-sqlxml-4-0.md
        • specifying-an-annotated-mapping-schema-in-an-updategram-sqlxml-4-0.md
        • updating-data-using-xml-updategrams-sqlxml-4-0.md
        • using-an-updategram-in-a-sample-asp-application-sqlxml-4-0.md
        • using-updategrams-to-modify-data-in-sqlxml-4-0.md
      • using-xpath-queries-in-sqlxml-4-0.md
      • xpath-data-types-sqlxml-4-0.md
    • sqlxml
      • annotated-xsd-schemas
        • annotated-xdr-schemas-deprecated-in-sqlxml-4-0.md
        • annotated-xsd-schemas-in-sqlxml-4-0.md
        • converting-annotated-xdr-schemas-to-equivalent-xsd-schemas-sqlxml-4-0.md
        • introduction-to-annotated-xsd-schemas-sqlxml-4-0.md
        • using-annotated-xsd-schemas-in-queries-sqlxml-4-0.md
      • formatting
        • architecture-of-client-side-and-server-side-xml-formatting-sqlxml-4-0.md
        • client-side-and-server-side-formatting-sqlxml-4-0.md
        • client-side-vs-server-side-xml-formatting-sqlxml-4-0.md
        • client-side-xml-formatting-sqlxml-4-0.md
        • server-side-xml-formatting-sqlxml-4-0.md
      • requirements-for-running-sqlxml-examples.md
      • sqlxml-4-0-programming-concepts.md
      • sqlxml-is-not-installed-in-sql-server.md
      • using-ado-to-execute-sqlxml-4-0-queries.md
      • what-s-new-in-sqlxml-4-0-sp1.md
      • xml-data-type-support-in-sqlxml-4-0.md
    • xml
      • add-business-logic-to-xml-data.md
      • add-namespaces-to-queries-with-with-xmlnamespaces.md
      • basic-syntax-of-the-for-xml-clause.md
      • canonical-forms-and-pattern-restrictions.md
      • change-existing-columns-to-xml-columns.md
      • column-names-with-the-path-specified-as-data.md
      • columns-that-contain-a-null-value-by-default.md
      • columns-with-a-name-specified-as-a-wildcard-character.md
      • columns-with-a-name.md
      • columns-with-the-name-of-an-xpath-node-test.md
      • compare-typed-xml-to-untyped-xml.md
      • create-alter-and-drop-secondary-selective-xml-indexes.md
      • create-alter-and-drop-selective-xml-indexes.md
      • create-instances-of-xml-data.md
      • create-views-over-xml-columns.md
      • create-xml-data-type-variables-and-columns.md
      • create-xml-indexes.md
      • define-the-serialization-of-xml-data.md
      • deny-permissions-on-an-xml-schema-collection.md
      • drop-xml-indexes.md
      • enumeration-facets.md
      • example-constructing-siblings-with-explicit-mode.md
      • example-querying-xmltype-columns.md
      • example-renaming-the-row-element.md
      • example-requesting-schemas-as-results-with-the-xmldata-and-xmlschema-options.md
      • example-retrieving-employee-information.md
      • example-retrieving-product-model-information-as-xml.md
      • example-specifying-a-root-element-for-the-xml-generated-by-for-xml.md
      • example-specifying-the-cdata-directive.md
      • example-specifying-the-element-directive-and-entity-encoding.md
      • example-specifying-the-element-directive.md
      • example-specifying-the-elementxsinil-directive.md
      • example-specifying-the-hide-directive.md
      • example-specifying-the-id-and-idref-directives.md
      • example-specifying-the-id-and-idrefs-directives.md
      • example-specifying-the-xmltext-directive.md
      • example-specifying-xsinil-with-the-elements-directive.md
      • examples-using-auto-mode.md
      • examples-using-openxml.md
      • examples-using-path-mode.md
      • for-xml-query-compared-to-nested-for-xml-query.md
      • for-xml-support-for-string-data-types.md
      • for-xml-support-for-the-timestamp-data-type.md
      • for-xml-support-for-the-user-defined-data-types-udt.md
      • for-xml-support-for-the-xml-data-type.md
      • for-xml-support-for-various-sql-server-data-types.md
      • generate-an-inline-xdr-schema.md
      • generate-an-inline-xsd-schema.md
      • generate-elements-for-null-values-with-the-xsinil-parameter.md
      • generate-siblings-with-a-nested-auto-mode-query.md
      • generate-xml-from-rowsets-with-for-xml.md
      • grant-permissions-on-an-xml-schema-collection.md
      • invalid-characters-and-escape-rules.md
      • large-xml-schema-collections-and-out-of-memory-conditions.md
      • load-xml-data.md
      • mixed-type-and-simple-content.md
      • modify-xml-indexes.md
      • namespace-support-in-path-mode.md
      • non-deterministic-content-models.md
      • openxml-sql-server.md
      • preprocess-a-schema-to-merge-included-schemas.md
      • promote-frequently-used-xml-values-with-computed-columns.md
      • reference-the-built-in-xml-schema-collection-sys.md
      • requirements-and-limitations-for-xml-schema-collections-on-the-server.md
      • retrieve-and-query-xml-data.md
      • revoke-permissions-on-an-xml-schema-collection.md
      • selective-xml-indexes-sxi.md
      • shape-xml-with-nested-for-xml-queries.md
      • specify-metaproperties-in-openxml.md
      • specify-paths-and-optimization-hints-for-selective-xml-indexes.md
      • the-xs-qname-type.md
      • the-xsd-redefine-element.md
      • type-directive-in-for-xml-queries.md
      • unique-particle-attribution-constraint.md
      • use-auto-mode-with-for-xml.md
      • use-explicit-mode-with-for-xml.md
      • use-for-xml-results-in-application-code.md
      • use-full-text-search-with-xml-columns.md
      • use-nested-for-xml-queries-in-asp-net.md
      • use-nested-for-xml-queries.md
      • use-path-mode-with-for-xml.md
      • use-raw-mode-with-for-xml.md
      • use-the-value-and-nodes-methods-with-openxml.md
      • use-xml-data-in-applications.md
      • use-xml-in-computed-columns.md
      • values-for-xsd-simpletype-declarations.md
      • view-a-stored-xml-schema-collection.md
      • wildcard-components-and-content-validation.md
      • xml-data-type-and-columns-sql-server.md
      • xml-indexes-sql-server.md
      • xml-schema-collections-sql-server.md
      • xml-system-stored-procedures.md
  • sql-server
    • versioning-system-monikers-ui-sql-server.md
  • t-sql/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