This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教各位大侠: how to set up a ID field in sql server 2000, it should be a autonum, plus 1 when the new record insert to the table. THANKS A LOT..:-)I know there is a data type "AutoNumber" in Access database, how to set up in sql server????
-shinning(dudu);
2003-3-27
{94}
(#1109014@0)
-
set the column to indentity, then u will have identity seed and identity increment.
-speed(如风);
2003-3-27
(#1109026@0)
-
Identity = yes, 然后可以设定Identity increment = 1.....
-luoboyang(萝卜秧);
2003-3-27
(#1109027@0)
-
u r just secs late..:D
-speed(如风);
2003-3-27
(#1109030@0)
-
看美的你~~~：）
-luoboyang(萝卜秧);
2003-3-27
(#1109031@0)
-
Thank you very much........^_^........trying..........
-shinning(dudu);
2003-3-27
(#1109087@0)