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.

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.