SQL Server Tutorial: How to write a SQL insert statement and troubleshoot errors

Published: 08 October 2021
on channel: Dr. Todd Wolfe Technology Training and Tutorials

579

In this tutorial, Dr. Wolfe breaks down the insert statement. Best practices for writing insert statements are shared along with a review of common error messages. This includes what to do with identity columns, nullable fields, truncation and ensuring you have the proper number of fields in the insert and values list. Common errors covered include

-Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF
-Column count doesn't match value count
-There are fewer columns in the INSERT statement than values specified in the VALUES clause.
-String or binary data would be truncated

At the end of this tutorial you will know how to:

1) Create an insert statement
2) Review a table structure using the sp_help command
3) Insert an explicit value in an identity column
4) Work with null and nonnullable fields
5) Troubleshoot common error messages

On this page of the site you can watch the video online SQL Server Tutorial: How to write a SQL insert statement and troubleshoot errors with a duration of hours minute second in good quality, which was uploaded by the user Dr. Todd Wolfe Technology Training and Tutorials 08 October 2021, share the link with friends and acquaintances, this video has already been watched 579 times on youtube and it was liked by 3 viewers. Enjoy your viewing!

13,912

323