Where to find free tutoral or advice for T-SQL and Stored Procedures (1 Viewer)

Rx_

Nothing In Moderation
Local time
Today, 08:03
Joined
Oct 22, 2009
Messages
2,803
Here are some links for those looking at moving the back-end of Access into SQL Server. It also covers the concepts of converting VBA into T-SQL functions.

Does anyone have other good sites to recommend?

http://www.sqlservercentral.com/stairway/75773/
This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server.

http://www.sqlservercentral.com/stairway/104497/
Advanced T-SQL

Myself, I am usually trying to solve a problem and resort to skipping to a specific stair-step. It is my intent to start from the beginning and take the steps properlly.... someday.
Following on from his Stairway to T-SQL DML, Gregory Larsen covers more advanced aspects of the T-SQL language such as subqueries
 

Users who are viewing this thread

Top Bottom