写一个函数，用当前的系统时间年２位＋月２位＋日2位+时分秒，构成物品表编号；给物品表插入数据时，引用该函数。

create function getid()
returns char(12)
as
begin
return convert(varchar,GETDATE(),12)+REPLACE(convert(varchar,GETDATE(),24),':','')
end
go
select dbo.getid()
/*
------------
111226110801

(1 行受影响)

*/
go
drop function dbo.getid

select convert(char(6),getdate(),112)+replace(convert(char(8),getdate(),108),':','')

select right(YEAR(getdate()),2)+ltrim(month(getdate()))+replace(convert(varchar,GETDATE(),108),':','')
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1112111706

(1 行受影响)*/