>>I have imported an Excel file into a SQL table. There is nothing unique in the data, so I want to add an Id column and populate it with 1 to the record count.
>>
>>How do I do this in SQL 2005?
>
>Create a new table with Identity column and insert from the table with Excel data.

Ok, this worked, but is there an easier way to do this without specifying all the fields?

INSERT INTO AlertImport
		(Active,
		ExpiredDate,
		ContractNo,
		SystemId,
		ItemNumber,
		Description,
		Price,
		ContractSeverityCode,
		EquipmentSerialNumber,
		LineType,
		AddressCode)
	SELECT Active,
		   ExpiredDate,
		   ContractNo,
		   SystemId,
		   ItemNumber,
		   Description,
		   Price,
		   ContractSeverityCode,
		   EquipmentSerialNumber,
		   LineType,
		   AddressCode
	FROM AlertImport