- 博客(2)
- 资源 (12)
- 收藏
- 关注
原创 忆龙2009:自动计算相邻两条记录指定字段的差值
select a.*, a.lottery_idx - b.lottery_idx as delta_period from dbo.GetAllRecordByResult('555') a left join dbo.GetAllRecordByResult('555') b on a.id = b.id + 1 select a.*, a.lottery_idx - b.lottery_id
2012-10-13 00:51:50 1056
原创 忆龙2009:SQL查询自动生成ID列
use lottery3D if OBJECT_ID('dbo.GetAllRecordByResult','IF') is not null drop function dbo.GetAllRecordByResult; go create function dbo.GetAllRecordByResult(@result nvarchar(3)) retur
2012-10-13 00:39:23 1243
ANDROID应用-教你玩魔方(源代码)
2012-09-02
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人