SQL Server: Query Data
-
-
-
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
-
-