27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #T
(CHARNO VARCHAR(20),
DT date)
Declare
@x1 int,
@y1 char(8)
select @x1= COUNT(CharNo) from #T where CAST(DT as date)=CAST(GETDATE() as date)
select @y1=SUBSTRING(convert(char(8),getdate(),112),1,4)
if(@x1=0)
begin
select @y1=SUBSTRING(convert(char(8),getdate(),112),1,4)
insert #T(CharNo,DT) values(
@y1+'company'+'001'
,GETDATE())
end
else
begin
insert #T(CharNo,DT) values(
@y1+'company'+
right('000'+cast((select MAX(CAST(SUBSTRING(charno,16,20) as bigint ))+1 from #T where CAST(DT as date)=CAST(GETDATE() as date))as varchar(50)),3)
,GETDATE())
end
CREATE TABLE testtab
(
ID INT IDENTITY,
PRIMARYKEY AS RTRIM(YEAR(GETDATE()))+'testtab' + RIGHT(1000 + id, 3),
TESTVALUE VARCHAR(50)
);
INSERT INTO dbo.testtab
(
TESTVALUE
)
VALUES
(
'测试1' -- TESTVALUE - varchar(50)
)
SELECT * FROM testtab