|
  
- 帖子
- 16
- 精华
- 0
- 积分
- 891
- 威望
- 0
- IT币
- 889
|
1#
发表于 2009-3-23 21:54
| 只看该作者
sql2005取得資料庫行數
| select billno, billdt from(SELECT ROW_NUMBER() OVER (ORDER BY billdt,cast(substring(billno,8,len(billno)) as int) desc) as rown, billno, billdt FROM commain)x where rown = @count -1 |
|
