Join Simon Allardice for an in-depth discussion in this video Writing INSERT statements, part of SQL Server 2008 Essential Training.
- View Offline
- Exercise Files
Selecting information is all very well, but after a while we are going to need…to start inserting some information into those databases.…Now of course if you have SQL Server Management Studio you can do the kind of…cheap and nasty way of doing it, which is right-click one of these tables,…select the Edit Top 200 Rows, and either start clicking and selecting in here to…change things, or you can scroll right down to the bottom and where the asterisk…row is just start typing.…But this is not really a very scalable way of doing some inserts.…
It's really just there for emergencies.…We need to understand how to construct SQL statements to do this.…Having said that, it is very useful to often look at this this way to…familiarize yourself with what data you are about to enter.…So I'm going to create a new query and I'll be using AdventureWorksLT, as we…have been all along.…I'm going to insert into the ProductCategory table here, simply because…it's quite a small one.…Again before I start writing the insert statement let me take a quick look at…
- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.