|
|
|
|
SELECT top 20 [vc_ggnr], [vc_gglx],[i_ggtw], [i_ggtj],[id], [i_ggfbrdm], [vc_ggfbr], [vc_ggbt], [d_ggrq] FROM [DK_gg] WHERE ([i_ggfbrdm] = 1 or [i_ggfbrdm] = 2) and i_state=0 order by [d_ggrq] desc,[i_ggtj] asc
 |
 |
|
|
 |
|
 |
|
 |
| SELECT top 10 [id], '·'+[vc_ggbt] as vc_ggbt FROM [DK_gg] where ([i_ggfbrdm] =1 or [i_ggfbrdm] =2) and ([vc_gglx]='通知公告' and [i_state]=0) order by [d_ggrq] desc,[i_ggtj] asc
|
|
SELECT top 10 [id], '·'+[vc_ggbt] as vc_ggbt FROM [DK_gg] where ([i_ggfbrdm] =1 or [i_ggfbrdm] =2) and ([vc_gglx]='相关文件' and [i_state]=0) order by [d_ggrq] desc,[i_ggtj] asc
|
|
SELECT top 10 [id], '·'+[vc_ggbt] as vc_ggbt FROM [DK_gg] where ([i_ggfbrdm] =1 or [i_ggfbrdm] =2) and ([vc_gglx]='帮助信息' and [i_state]=0) order by [d_ggrq] desc,[i_ggtj] asc
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
河北省教育厅 版权所有
河北师范大学网络技术研究所设计开发 2007/6 |
|
|
|
| |
|