SQL Server Tutorials - Getting Started with Transact-SQL Statements

SQL Server Tutorials - Getting Started with Transact-SQL Statements

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

1. How to use Transact-SQL statements to access the database engine?


2. How to create new databases with "CREATE DATABASE" statements?


3. How to create new table with "CREATE TABLE" statements?


4. How to insert and update data into a table with "INSERT" and "UPDATE" statements?


5. How to read data in a table with "SELECT" statements?


6. How to create a login to access the database engine using "CREATE LOGIN" statements?


7. How to create a user to access a database using "CREATE USER" statements?


8. How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements?


9. How to grant a permission using "GRANT EXECUTE" statements?


10. How to delete database objects with "DROP" statements?

More...