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 ...

I turned up something in a search I wanted to confirm - that I can't do the following:<BR><BR>INSERT INTO table_a<BR>(col_b, <BR> col_c)<BR>VALUES<BR>('blah',<BR>SELECT id FROM table_b WHERE name IS ...

CREATE TABLE TABLE_A (ID int NOT NULL IDENTITY(1,1) PRIMARY KEY, NAME varchar(32)); CREATE TABLE TABLE_B (ID int NOT NULL IDENTITY(1,1) PRIMARY KEY); CREATE TRIGGER INSERT_ON_TABLE_B ON TABLE_A FOR ...