stored procedure 問題

luckiejacky

1. BEGIN
   
2.     select max(customers.CustomerID)+1 INTO para from customers;
   
3.    
   
4. END

複製代碼

如果無records怎辨?
THX

henrywho

if no record, max() returns null
and .... null +1 => null

zenchiu

select isnull(max(customers.CustomerID),0) INTO para from customers;
冇record會return 0
但你好似冇drop para TABLE 先喎.

luckiejacky

是否唔應該set Customer ID 做AUTO-INCREMENT?