SQL Server Course for Beginners with 100+ examples - Insert Records

The video tutorial demonstrates how to create a database and a table in SQL Server, followed by inserting records into the table using the INSERT INTO command. It also covers verifying the inserted records using the SELECT command. The tutorial provides a step-by-step guide to creating a database named 'amiddb', setting up an 'employee' table with specific fields, and inserting sample data into the table. Finally, it shows how to verify the data insertion by executing SQL commands.

What is the data type of the 'salary' field in the employee table?

• varchar

• int

• float

• char

Which command is used to insert records into a table in SQL Server?

• ADD RECORD

• INSERT INTO

• INSERT RECORD

• ADD INTO

What is the first step in inserting a record into the employee table?

• Write the SELECT command

• Specify the table name

• Execute the command

• Define the database

How do you verify the records added to the employee table?

• Use the SELECT * command

• Check the database properties

• Review the table schema

• Use the INSERT INTO command

What indicates the successful addition of a record in SQL Server?

• A message saying 'table updated'

• A message saying 'command executed'

• A message saying 'one row affected'

• A message saying 'record added'