自定义函数只能第一次插入数据
CREATE VIEW v_GetDate
as
select dt=Convert(Char(6),getdate(),12)
Create function f_nextBH()
RETURNS char(14)
AS
BEGIN
dECLARE @dt char(6)
select @dt=dt from v_GetDate
return (
select 'TS'+@dt+right(1000001+ISNULL(RIGHT(MAX(TSPKID),6),0),6)
FROM Clientts with(xlock,paglock)
where tspkid like @dt+'%'
)
end
create table clientts
(
tspkid char(14) primary key defult dbo.f_NextBH(),
COL INT
)
插入数据后,tspkid结果为
TS060909000001
第二此插入就报错呀
Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__clientts__50C5FA01'. Cannot insert duplicate key in object 'clientts'.
The statement has been terminated.