34,590
社区成员
发帖
与我相关
我的任务
分享
create table tb
(
id1 int identity(1,1),
id2 as '''10000000000000000000000'+ cast(id1 as varchar)+convert(varchar(8),getdate(),112)+'''' ,
val varchar(10)
)
go
insert tb values('a')
insert tb values('b')
insert tb values('c')
go
select * from tb
drop table tb
/*
id1 id2 val
----------- --------------------------------------------------------------- ----------
1 '10000000000000000000000120090310' a
2 '10000000000000000000000220090310' b
3 '10000000000000000000000320090310' c
(所影响的行数为 3 行)
*/
create table tb
(
id1 int identity(1,1),
id2 as '10000000000000000000000'+ cast(id1 as varchar)+convert(varchar(8),getdate(),112) ,
val varchar(10)
)
go
insert tb values('a')
insert tb values('b')
insert tb values('c')
go
select * from tb
drop table tb
/*
id1 id2 val
----------- ------------------------------------------------------------- ----------
1 10000000000000000000000120090310 a
2 10000000000000000000000220090310 b
3 10000000000000000000000320090310 c
(所影响的行数为 3 行)
*/
create table #1(id int identity(1,1),idd as '''10000000000000000000000'+ rtrim(id)+convert(varchar,getdate(),112)+'''' ,col1 varchar(256))
insert #1 values('abc1')
insert #1 values('abc2')
insert #1 values('abc3')
select * from #1
id idd col1
----------- ------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 '10000000000000000000000120090309' abc1
2 '10000000000000000000000220090309' abc2
3 '10000000000000000000000320090309' abc3
(3 row(s) affected)
create table [tb]
(
id int identity(1,1),
col as '10000000000000000000000'+ltrim(id)+convert(varchar,getdate(),112),
content varchar(20)
)
insert into tb select 'abc'
select * from tb
/**
id col content
----------- ----------------------------------------------------------------- --------------------
1 10000000000000000000000120090309 abc
(所影响的行数为 1 行)
**/
declare @t table (id int identity,fid as '10000000000000000000000'+ltrim(id)+convert(varchar,getdate(),112),col varchar(20))
insert @t select 'abcd'
union all select 'efgh'
select * from @t
id fid col
----------- ----------------------------------------------------------------- --------------------
1 10000000000000000000000120090309 abcd
2 10000000000000000000000220090309 efgh
(所影响的行数为 2 行)