TN - 1154 Guide for querying Historical data in the SQL Management Studio

Description

This article from InSource provides a guide for querying Historical data in the SQL Management Studio.

• Author: Mataia Ross
• Published: 06/15/2021
• Applies to: Historian

Details

How to query in SQL Management Studio.

1. Create a connection to your database.

2. Select your database, and click new query.

3. Enter the following query.

SELECT pc.Name as CategoryName, p.name as ProductName

FROM [SalesLT].[ProductCategory] pc

JOIN [SalesLT].[Product] p

ON pc.productcategoryid = p.productcategoryid;

4. Click Execute 

The following are a few tips that will help you to understand SQL. This will also be a cheat sheet when needed to allow you to access information in your data tables.

Here are some of the most common SQL commands and what they do:

SELECT - extracts data from a database

UPDATE - updates data in a database

DELETE - deletes data from a database

INSERT INTO - inserts new data into a database

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index

SELECT is how every query will start. This statement is used to get data from the DB.

FROM gives the location in which information should be gathered.

The data is then returned and stored in a result table, called the result-set.

Example:

SELECT column1, column2, ...
FROM table_name;

WHERE is used the filter the Data

This allows you to choose exact data that matches a specific condition that has been given.

Example:

SELECT column_names
FROM table_name
WHERE column_name IS NULL;

This query will only pull data that's value is set to NULL

Here are some interesting things about...