insert into GradeLog([UserName], [IP],
[LogTime], [LogSource], [Description])
select [UserName], [IP], [LogTime], [LogSource], [Description] from
(
select 'yifan' as [UserName], '201.44.58.78' as
[IP], getDate() as [LogTime], 1 as [LogSource], 'bbbb' as
[Description]
union all
select 'yifan' as [UserName], '201.44.58.78' as
[IP], getDate() as [LogTime], 1 as [LogSource], 'cccc' as
[Description]
union all
select 'yifan' as [UserName], '201.44.58.78' as
[IP], getDate() as [LogTime], 1 as [LogSource], 'dddd' as
[Description]
union all
select 'yifan' as [UserName], '201.44.58.78' as
[IP], getDate() as [LogTime], 1 as [LogSource], 'eeee' as
[Description]
union all
select 'yifan' as [UserName], '201.44.58.78' as
[IP], getDate() as [LogTime], 1 as [LogSource], 'ffff' as
[Description]
) as temp
select [UserName], [IP], [LogTime], [LogSource], [Description] from
(
) as temp
插入表情