写一个函数,放在默认值里:
create function getNumber()
returns char(5)
as
return (select right('00000'+cast(isnull(max(字段),0)+1 as varchar(5)),5) from 表)
go你在你的表里的那个字段的默认值里写:
dbo.getNumber()
------------------------------
注
默认值里的dbo和()不要漏写了,函数你只要把中文的部分改成你的表名和列名就OK了
create function getNumber()
returns char(5)
as
return (select right('00000'+cast(isnull(max(字段),0)+1 as varchar(5)),5) from 表)
go你在你的表里的那个字段的默认值里写:
dbo.getNumber()
------------------------------
注
默认值里的dbo和()不要漏写了,函数你只要把中文的部分改成你的表名和列名就OK了
http://expert.csdn.net/Expert/topic/1782/1782997.xml?temp=.9814112
是不是SQL7不支持 function?create function getNumber()
returns char(5)
as
return (select right('00000'+cast(isnull(max(ID),0)+1 as varchar(5)),5) from T_B)
goServer: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'function'.
Server: Msg 178, Level 15, State 1, Line 4
A RETURN statement with a return status can only be used in a stored procedure.