select convert(varchar(10,getdate(),108)+right('000'+ltrim(row_number()over(order by getdate())),2) from tb
--创建实现自动增加收集号的函数 CREATE FUNCTION SJL_GETID() RETURNS INT AS BEGIN RETURN (select convert(varchar(10,getdate(),108)+right('000'+ltrim(row_number()over(order by getdate())),2) from 收集蓝) end 这样写还是有问题吧?
CREATE FUNCTION SJL_GETID()
RETURNS INT
AS
BEGIN
RETURN (select convert(varchar(10,getdate(),108)+right('000'+ltrim(row_number()over(order by getdate())),2) from 收集蓝)
end
这样写还是有问题吧?