Understanding T-SQL SELECT

One of the most fundamental aspects of working with SQL Server is querying data stored inside a database. To query data from a database you use the SQL SELECT statement. There are two important things to understand about the SELECT statement. The first is syntax, which are the rules and structure of the SQL statement that allows the statement to be sent to the database and have results returned. The second thing to understand is the “logical processing order” of select statements. The way the SQL Server engine processes select statements to retrieve data, is different from the order statement appears in the query. When you write syntactically correct SELECT statements in SQL Server Management Studio. Continue reading “Understanding T-SQL SELECT”