Skip to main content
InSource Solutions

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

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



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


How to query in SQL Management Studio.

  1. Create a connection to your database.

sql intro.PNG

  1. Select your database, and click new query.

sql 2.PNG

sql 33.PNG

  1. Enter the following query.

SELECT pc.Name as CategoryName, as ProductName

FROM [SalesLT].[ProductCategory] pc

JOIN [SalesLT].[Product] p

ON pc.productcategoryid = p.productcategoryid;


  1. 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.


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.


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...

    • Was this article helpful?