Skip to content

query-data.md

Latest commit

 

History

History
284 lines (283 loc) · 15.3 KB

query-data.md

File metadata and controls

284 lines (283 loc) · 15.3 KB
layout HubPage
hide_bc true
experimental true
experiment_id 81ba5f65-59fb-4d
title SQL Server - Query Data
description Explore the features that make it easy to query the data in your SQL Server database.
ms.topic hub-page
featureFlags
clicktale

SQL Server: Query Data

      • Cursors

        Allows for the processing of a result set one row at a time

      • Full-text Search

        Full-text indexes include one or more character-based columns in a table, and full-text search allows you to query them.

      • Joins

        Explores the different sort, intersection and union operations performed by SQL Server when using joins.

      • Scripting

        Explores the various scripting languages supported by SQL Server, such as Powershell, and xQuery.

      • Subqueries

        A subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery.

      • Synonyms

        A database object that provides a layer of abstraction to protect client application from changes to the name or location of a base object.

      • User-Defined Functions

        Routines that accept parameters, perform an action, and return the result of that action as a value.

      • Database Design

        Filestream, Filetable, Spatial Data, Views, Triggers, Graphs, Sequence Numbers, Stored Procedures, Track Changes