Very interesting, but again it gets me thinking - I hate when that happens.... ๐
What is the difference between these 2 variations of today's QOD and how would you change the first one to make it as good at the second. Of course I'm talking about field length.
SELECT IDENTITY(INT, 1,1) AS id,bt.FirstName
INTO CustomerNames
FROM (SELECT * FROM (VALUES ('Steve'), ('Andy'), ('Brian')) AS Names(FirstName)) AS bt
---------------
CREATE TABLE Names
(firstname VARCHAR(100));
GO
INSERT dbo.Names (FirstName) VALUES ('Steve'), ('Andy'), ('Brian');
GO
SELECT IDENTITY(INT, 1,1) AS id,bt.FirstName
INTO CustomerNames
FROM Names AS bt
The only thing I noticed was varchar(5) as opposed to varchar(100).