Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset - Quick Tips Ep55

Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset
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.
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
www.sqltrainingonline.com/crea...
UA-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ua-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

[@sirfondeck651]

Thanks, Sir, please can you make a tutorial on 'foreign key'? thanks

[@soumilssinha5010]

hi there.. Could you please add some videos explaining about entities in sql scripts and also about Entity Relationship(ER) diagrams??

[@benballier9580]

Whenever I click “edit last 100” it gives me a screen where I can’t type anything in. I don’t have the three dots…im on PostgreSQL 14 btw

[@techsavy8211]

Great presentation, sir! So, how could we make the ID column to start from 1 instead of 21?

[@joeyblue1]

Hi Yared,
When you create the table, the identity will start at 1 if you put in "Identity(1,1)".
If you need to reseed the table, you use the following command:
DBCC CHECKIDENT ('HomerunLeaders', RESEED, 0);
GO

[@waruntalukder1275]

I am the *First* one!