Writing INSERT statements


show more Writing INSERT statements provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

Writing INSERT statements

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 befo...

Writing INSERT statements
Video duration: 5m 47s 6h 54m Beginner

Viewers:

Writing INSERT statements provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...