SQLServerCentral.com Articles tagged select

Indexing - Take the Hint and Leave it to the Experts

Mon, 30 Jan 2012 07:00:00 UT

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.

Understanding the SQL Server SELECT @@VERSION command

Fri, 30 Dec 2011 07:00:00 UT

Check out this tip to learn about the SELECT @@VERSION command in SQL Server.

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

Fri, 07 Oct 2011 06:00:00 UT

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.