[dba-SQLServer] Delete first record

jwcolby jwcolby at colbyconsulting.com
Mon Jun 8 08:16:03 CDT 2009


Is there any way to delete the first record in a table in SQL Server.  I am importing a csv file 
into a temp table, and from there appending the data to a permanent table.  The csv has the field 
names in the first row.  When I try to append to the permanent table the append fails because the 
row name fields aren't the correct data types, thus I need to just delete that first row.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list