sql server 2000Óï¾äÇóÀß - MS-SQL Server / Ó¦ÓÃʵÀý
ÎÒÕâÓжþÕÅ±í£¬
±íÒ»£ºArvichFile
CameraSign(int 4),FileEndTime(datetime),FileEndTime(datetime)
303101 2010-3-18 15:51:12 2010-3-18:15:35:26
303201 2010-3-18 15:54:42 2010-3-18 16:00:00
303101 2010-4-1 09:20:07 2010-4-1 12:30:00
303201 2010-4-1 09:20:07 2010-4-1 12:30:40
303501 2010-4-1 09:20:07 2010-4-1 12:30:00
204101 2010-4-1 09:27:07 2010-4-1 12:30:00
204201 2010-4-1 09:27:07 2010-4-1 12:30:00
204301 2010-4-1 09:27:07 2010-4-1 12:30:00
204101 2010-4-22 09:27:07 2010-4-22 12:30:00
204201 2010-4-22 09:27:47 2010-4-22 12:30:00
204301 2010-4-22 09:27:07 2010-4-22 11:30:00
304101 2010-4-1 13:00:04 2010-4-1 18:00:04
304201 2010-4-1 13:00:04 2010-4-1 18:00:05
304301 2010-4-1 13:00:01 2010-4-1 18:00:54
305101 2010-4-1 18:00:04 2010-4-1 18:15:00
305201 2010-4-1 18:00:04 2010-4-1 18:15:00
305301 2010-4-1 18:00:04 2010-4-1 18:15:01
±í¶þ£ºCamera
StationID(int 4) CameraSign(int 4)
1 303101
1 303201
1 303501
2 204101
2 204201
2 204301
3 304101
3 304201
3 304301
4 305101
4 305201
4 305301
ÏÖÔÚÒÑÖªµÄÊÇStationID
ÒªµÃ³öµÄ½á¹ûÊÇ£º
StationID FileBeginTime FileEndTime
1 2010-4-1 09:20:07 2010-4-1 12:30:00
2 2010-4-1 09:27:07 2010-4-1 12:30:00
3 2010-4-1 13:00:04 2010-4-1 18:00:04
4 2
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......