In this SQL Server 2012 training, we cover SQL Insert Statement. The Insert Query is used to add data to an existing MS SQL 2012 table. We start the SQL Server video training by doing an overview of the SQL INSERT statement, followed by the SQL INSERT command syntax and then some SQL query examples.
Examples of Insert command include:
-Add data to Regions table
-Insert a record to Shippers table with Set Identity_Insert On
In this SQL Server 2014 Tutorial for beginner, we cover SQL Server management studio. This is also known as SSMS.
We start the video training on MS SQL 2014 by showing you how to launch Management Studio. We cover how to use SQL Server Registered Servers. Next we move on to the Object Explorer, the heart of SSMS. We demonstrate all the various tabs including Database, Server objects, Security, Management and SQL 2014 Agent.