SQL Basics: Table creation and inserting data

This SQL Screencast will demonstrate the basics of table creation and inserting data into tables using SQL. - create table (s) - set primary key (s) - add constraints - add foreign keys - insert data - read data from the table

Category:

Howto & Style

Tags:

• learn
• sql
• databases

[michaelfudge]

@dolaonline Very true! I know that works in 2008, I wonder about SQL 2005.

[thegoldabdel]

how can i create table and insert data in the same time from a nother table

[michaelfudge]

@thegoldabdel SELECT INTO newTABLE ....

[MovieMad007]

SQL 2005 Management Studio Express actually works....I tried on my Windows7 Machine no-luck and tried 2008 express ...no luck - but then I went and downloaded onto my laptop running a very old WindXP edition and SQL Server 2005 Management Studio express actually loaded up and ran like a dream. Problem is now I have Visual Web developer 2008 working on Windows7 machine at Mums house with no database working but the SQL server Man Studio working on my laptop at my house ...2 miles apart!!Options?

[dolaonline]

From 4:40...Instead of the 3 insert statements, u can do the following:

insert into product_types

(product_type) values ('book'),('hardware'),('softwa­re');

[kitty591]

@sickness2snipe yeah it is .

[WhiteKeys007]

Great video. Helped a lot. Thanks!

[sickness2snipe]

is your name really michael fudge?

[kshitij097]

good thanks!!!!!!

[sajopane]

Thanks