34,576
社区成员
发帖
与我相关
我的任务
分享
if object_id('[table1]') is not null drop table [table1]
go
create table [table1]([tid] int,[tname] varchar(5),[ttime] datetime,[tvalue] varchar(7))
insert [table1]
select 1,'name','2008-10-11','zhao' union all
select 2,'name','2008-10-12','qian' union all
select 3,'name','2008-10-13','sun' union all
select 4,'class','2008-10-13','math' union all
select 5,'class','2008-10-14','english'