Learn SQL

External Article

The Basics of Inserting Data into a SQL Server Table

  • Article

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

2022-10-19

Blogs

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Monday Monitor Tips: Looking Back in Time

By

Often we find out about a problem reported by a customer after the incident...

Can You Tell Why a Plan Didn’t Go Parallel?

By

Let’s face it, most of the time, you probably don’t want your SQL Server...

Read the latest Blogs

Forums

SSIS how to manage source control with multiple packages / projects

By sgraflund

We've got upwards of 40 SSIS solutions all stored in one GIT repository in...

Improving the Performance of UPDATE Statements in SQL Server

By Noman072

Comments posted to this topic are about the item Improving the Performance of UPDATE...

Replacing a Null

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Replacing a Null

Visit the forum

Question of the Day

Replacing a Null

What is returned from this code in SQL Server 2022? 

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;

See possible answers