SQL

Start Here Glossary WHERE INSERT (Create) SELECT (Read) UPDATE DELETE Join Tables Sub Query Limit Records SQL Injection SSMS Meta Data Sum TABLE Apostrophe Date Identity
O O

Weather Controls

Time Of Day
Rain
Wind Speed
Wind Direction
Clouds

SQL : SELECT (Read)

2018-03-03

Basics

Get all records and all columns

SELECT  * FROM z_robsTestTable

Get 1 records and a few select columns

SELECT  primaryid, name FROM z_robsTestTable
WHERE primaryid = 1