Not sure where you found this syntax for a SQL INSERT... I would
expect to see something along the lines of INSERT INTO <table1> SELECT
a,c,b FROM <table2> ...
The SQL INSERT appends new rows to a table. The SQL UPDATE replaces
values in specific columns of a table (and often includes conditions).
"Jon Bodfish" <email@example.com> wrote in message news:<firstname.lastname@example.org>...
> Unfortunately, I am experiencing some trouble when loading SAS data from
> proc sql into a SQL Server (SQL 2000) table. After submitting the
> statements listed below my log states the following: "[ODBC SQL Server
> Driver][SQL Server]Cannot insert explicit value for identity column in
> table 't_PAT_patients' when IDENTITY_INSERT is set to OFF"
> libname a odbc dsn=TestBase;
> proc sql;
> insert into a.t_PAT_Patients (PAT_RACE)
> select PAT_RACE from WWDPat;
> But PAT_RACE is not an identity column in t_PAT_Patients. However, if I
> upload the SAS dataset to a junk table in SQL server, then run the same
> insert either from proc dbload or direcly in SQL then I do not
> experience any problems.
> Thanks for you help in advance.