SQL Server 2008 and using Transact SQL (TSQL)http://www.learningsqlserver2008.com/ If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins) code pour embarquer la vidéo : >>> http://www.youtube.com/embed/urs7eZppiGM <<< |