insert a duplicate row with one changed field only

swdgaurav · #1 (**permalink**) December 26th, 2007, 07:15 AM

hi,
i hav to insert a duplicate row with one changed field only.
table doesn't have any primary key.
field to be changed is also the field used for selection crieteria.
i m using sql server 2005.
please help.
thanks.

urtrivedi · #2 (**permalink**) December 31st, 2007, 04:54 AM

It is very poor practise, that you are using table without primary key, you will not able to delete/update record properly, if you are using sql server. Can't you write two insert statments, one by one, with changed value.

urt

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot insert duplicate key row in object 'dbo.mov	alxGramma	SQL Server 2005	4	April 15th, 2008 01:42 PM
cannot insert duplicate key row in object 'Table'	skyline666	SQL Server 2005	0	April 15th, 2008 05:03 AM
Removing duplicate Value Row	milindsaraswala	Excel VBA	0	November 14th, 2007 06:11 PM
How to duplicate 1 row in table	minhpx	SQL Language	1	December 20th, 2004 09:51 AM
hidden field to be changed to button?	dorothee	ASP.NET 1.0 and 1.1 Basics	4	June 11th, 2004 02:51 AM