View Single Post
  #1 (permalink)  
Old December 26th, 2007, 07:15 AM
swdgaurav swdgaurav is offline
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default insert a duplicate row with one changed field only

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.