Posted by SQL Enthusiast
Article by our editor
When copying data into a new table using SELECT INTO it can be useful to add an identity column at the same time, especially where the source data does not already have a primary key. This tip describes how to do that.
Comments (2) • Read full article »
This SQL script creates a comma separated list of all columns in a table. This can be useful for creating SQL INSERT and SELECT statements etc.
Comments (5) • Read full article »
More SQL questions »