create table #t1 (Invoice_no int, item VARCHAR(5), price MONEY ,Inserted_date DATETIME DEFAULT GETDATE() ,Updated_date DATETIME DEFAULT GETDATE())insert into #t1 (invoice_no, item, price)select 102,'#1', 6.21 union all select 102,'#2', 3.56union all select 102,'#3', 4.28union all select 105,'#4', 1.90union all select 105,'#5', 3.66union all select 107,'#6', 2.01SELECT Invoice_no, item, price, Inserted_date, updated_date FROM #T1UPDATE #T1SET price = 5.00 ,updated_date = DEFAULTWHERE invoice_no = 107SELECT Invoice_no, item, price, Inserted_date, updated_date FROM #T1DROP TABLE #T1