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.