SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

September 12, 2017 by Joey Blue Leave a Comment

Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

How to use the Create Table Statement to store data in SQL Server

In this video I show you how to take some baseball data from a website, create a SQL Server table, and insert it into the table.

Video: Create Table Statement in SQL Server


How to use the Create Table Statement to store data in SQL Server..

Here is the Homerun Leaders Page that I use for the data.

The following Scripts are used in the video:

--Create Table
create table dbo.HomerunLeaders
(
 id int primary key identity(1,1),
 [Rank] int,
 Player varchar(50),
 Homeruns int,
 Bats varchar(1)
);

--Select from table
select * from dbo.HomerunLeaders
where Rank < 10;

See the original SQL Create Table video.

Related

Filed Under: SQL Tip Tagged With: Create Table, SQL Create Table, SQL Delete, SQL Identity, SQL Server

Leave a Question, Comment, or Reply. All are welcome! Cancel reply

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com