关于触发器建立主索引,(sql2000)(50分)

W

wzb_shipman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #1

怎么用触发器(insert)建立主索引不用delphi
table1(a,b,c)
if (table2.eof and table2.bof) then 索引=table1.a+000001
else 索引=(select max(索引) from table2)+1

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-13

• #2

利用存储过程吧

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-13

• #3

同感