GitHub

insert-transact-sql.md

Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement. The result set is derived from a SELECT statement. For more ...
Visual Studio Magazine

Using SQL Bulk Insert with the .NET Framework

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...
GitHub

SQL: ON CONFLICT clause for INSERT, UPDATE statements

In SQL we support non-standard clause called ON CONFLICT / OR. It is not a separate clause which can appear in INSERT/UPDATE statements or as a column option in CREATE TABLE statements. See examples ...
Ars Technica

SQL: Inserting NULL when the value is

If I have a variable rs ("ColumnA") that is an empty string "" and I want to insert it into a table as a NULL instead, isn't there a SQL function that would ...
TechRepublic

Inserting specific values into an identity column with SQL

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...
Simon Fraser University

Example 1: Creating a Table and Inserting Data into It

proc sql; create table proclib.paylist (IdNum char(4), Gender char(1), Jobcode char(3), Salary num, Birth num informat=date7. format=date7., Hired num informat=date7 ...