Str1 = "update phoneinfo set A.projectname='" & TxtProjectID.Text & "',A.outdate={fn now()} FROM phoneinfo A INNER JOIN (SELECT TOP 10 * FROM phoneinfo) B ON A.關鍵字 = B.關鍵字 where .....
Str1 = "update phoneinfo set A.projectname='" & TxtProjectID.Text & "',A.outdate={fn now()} FROM phoneinfo A INNER JOIN (SELECT TOP 10 * FROM phoneinfo) B ON A.關鍵字 = B.關鍵字 where .....
Str1 = "Update phoneinfo Set projectname='" & TxtProjectID.Text & "',outdate={fn now()}
Where id in (Select Top " & TxtSelectNum.Text & " from phoneinfo)"