Microsoft SQL BI & Power BI blog
Tuesday, February 28, 2017
Insert multiple rows using a single SQL INSERT statement
How to insert multiple rows using a single SQL INSERT statement.
INSERT
INTO
MyTable
(
Column1
,
Column2
)
VALUES
(
Value1
,
Value2
),
(
Value1
,
Value2
)
Example of updating SQL table with join's and subselect
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)