学生ID順に連番を振ることを考えます。ROW_ NUMBER関数が使える環境なら、 リスト1のように簡単に記述でき、 図1の実行結果が得られます。 リスト1主キーが1列の場合(ROW_ NUMBER) SELECT student_id, ROW_NUMBER() OVER (ORDER BY student_id) AS seq FROM Weights; 図1 リスト1、 2の実行 ...

I have a table called PurchaseOrder, each row in that table has a unique auto incrementing field named ID. I simply want to get the highest ID and assign it to a string variable in VB .Net - I can't ...