1SELECT *FROM mylist WHERE (CONVERT(varchar(30), [datetime],21) = '2005-05-05 07:%')
解决方案 »
- 数组求和
- 问个简单问题create or replace 在sql server 里该怎么写?
- (下)今天去面试的题,我贴出来,大家看看
- 存储过程或函数能不能接受表变量?
- 存储过程调用存储过程
- 提问:我把excel表导入到sql2000中,怎么连excel表中没有记录的行也导进来了?
- 执行效率问题
- SQL Server 2005 date类型数据修改问题
- 怎样删除SQL Server库中的一个表?
- 请教SQL Server Business Intelligence
- 如何删除表中字段值最小的记录
- 如何在同一个记录的text类型的字段内容尾部添加上一个 varchar字段的值与一个字符串的连接后的字符串?
SELECT * FROM mylist
WHERE datepart(hour,[datetime])=7--2.
select time,
ValueOfIndex0=max(case [index] when 0 then val end),
ValueOfIndex1=max(case [index] when 1 then val end),
ValueOfIndex2=max(case [index] when 2 then val end)
from list
group by time
--2.如果index值不固定
declare @s nvarchar(4000)
set @s=''
select @s=@s+','+quotename('ValueOfIndex'+rtrim([index]))
+'=max(case [index] when '+rtrim([index])+' then val end)'
from list
group by [index]
exec('
select time'+@s+'
from list
group by time')
2、
创建视图:
------------------------------------------------------------
declare @view varchar(20)
declare @s varchar(8000)
set @view = 'new_view'
set @s = 'create view '+@view+' as select time'select @s = @s + ',[ValueOfIndex'+rtrim(index)+']=max(case when index = '+rtrim(index)+' then val end)'
from list group by index order by indexset @s = @s + ' from val group by time'
exec(@s)