June 2006
Beginner
456 pages
10h 3m
English
Not only can you use T-SQL to select data, you can also use it to update data. T-SQL enables you to update, insert into, and delete data from tables. In this hour you’ll learn:
• How to use the UPDATE statement to update table data
• How to use the INSERT statement to insert data into an existing table
• How to use the SELECT INTO statement to insert data into a new table
• How to use the DELETE statement to selectively delete data from a table
• How to use the TRUNCATE statement to remove all data from a table
The examples that follow are based on a database called Northwind which is included on the sample code CD. Instructions as to how to install the Northwind database are included in ...
Read now
Unlock full access