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

Have Questions? Connect with me.

Link to my Facebook Page
Link to my Pinterest Page
Link to my Rss Page
Link to my Twitter Page
Link to my Youtube Page
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com