mssqlÀïµÄÕâЩÓû§ÊǸÉÂïµÄ£¬Ó¦¸Ãɾ³ý»¹ÊǾܾø·ÃÎÊ£¿
sql 2005ÀïÓÐЩ2000ÀïûÓеÄÓû§£¬²»ÖªµÀ·Ö±ðÓÐʲô¹¦ÄÜ£¿
³öÓÚ°²È«¿¼ÂÇ£¬ÄÄЩӦ¸Ãɾ³ýÄÄЩӦ¸Ã¾Ü¾ø·ÃÎÊ£¿
лл£¡
BUILTIN\Administrators
BUILTIN\Users
NT AUTHORITY\SYSTEM
xxxx\SQLServer2005MSSQLUser$xxxx$SQLEXPRESS
##MS_AgentSigningCertificate##
INFORMATION_SCHEMA
ѧϰ`
BUILTIN\Administrators
BUILTIN\Users
ÕâЩÊÇÓû§×é°É
ÔÚ°²×°SQL Server 2000 £¬°²×°½ø³Ì×Ô¶¯µØÎªBUILTIN\Administrators”´´½¨Ò»¸öµÇ¼Õʺţ¬¸ÃÕʺÅΪsysadmin”½ÇÉ«³ÉÔ±¡£BUILTIN\Administrators”µÇ¼ÕʺŴú±íÁËMicrosoft Window2000 ÉϵÄϵͳ¹ÜÀíÔ±±¾µØ×é¡£ Windows 2000µÄAdministrator”ÕÊ»§ÊÇϵͳ¹ÜÀíÔ±±¾µØ×éµÄ³ÉÔ±¡£
´ËÍ⣬Èç¹ûÄúµÄ·þÎñÆ÷ÊÇÒ»¸öÓòµÄ³ÉÔ±£¬Domain Admins”È«¾Ö×éÒ²»á³ÉΪ±¾µØÏµÍ³¹ÜÀíÔ±×éµÄ³ÉÔ±¡£ÕâÒâζ×Åϵͳ¹ÜÀíÔ±±¾µØ×éµÄËùÓгÉÔ±¶¼»á×Ô¶¯µØ»ñµÃSQL ServerÉϵÄsysadmin”ȨÏÞ¡£ÎªÁ˼ÓÇ¿ÄúµÄSQL ServerµÄ°²È«ÐÔ£¬¿ÉÒÔ´´½¨×Ô¼ºµÄ×é²¢ÊÚÓèËüsysadmin”ȨÏÞ£¬È»ºóɾ³ýBUILTIN\Administrators”µÇ¼Õʺţ¬»òÕßÖÁÉÙ´Ósysadmin”·þÎñÆ÷½ÇÉ«ÖÐɾ³ýËü¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÒԽϺõضÔË¿ÉÒÔ·ÃÎÊÄúµÄSQL Server½øÐпØÖÆ¡£ÕâÖÖ·½·¨Ò²¶Ï¿ªÁËSQL Server ϵͳ¹ÜÀíÔ±ºÍWindows 2000 ¹ÜÀíÔ±Ö®¼äµÄÁªÏµ£¬ÒòΪËûÃÇͨ³£Óв»Í¬µÄÈÎÎñ£¬²¢ÇÒÐèÒª²»Í¬µÄȨÏÞ¡£ÎªÁ˼ÓÇ¿°²È«ÐÔ£¬Äú¿ÉÄÜÏë°ÑSQL ServerÅäÖóÉÖ»Ö§³ÖWindowsÉí·ÝÑéÖ¤¡£µ«ÊÇ£¬±ØÐëÒª¼Çס£ºÕâÖÖÅäÖûá½ûÓÃÄúµÄsa”ÕÊ»§¡£Èç¹ûÄúÒÔ´íÎóµÄ˳ÐòʵʩÁËÕâ¸ö°²È«´ëÊ©£¬Äú½«²»ÄÜÔÙÒÔ>sysadmin”µÄÉí·ÝµÇ¼µ½SQL ServerÉÏ£¬³ý·
Ïà¹ØÎÊ´ð£º
asp+mssql ¸ÃÈçºÎ·µ»ØÈçÏÂÐÅÏ¢ÄØ
±ÈÈçÒ»¸ö±íÀïÃæµÄÊý¾Ý
date info
2009-1-1 13:00:00 12345
2009-1-1 13:00:01 12345
2009-1-1 13:00:02 12345
......
¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔÀ´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô»òÕ߸½¼ÓÊÇΨ ......
Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó
A(×Ö¶Î)
------------------------
a b c
ab c
f c d
½á¹û:
A(×Ö¶Î)
------------------------È ......
asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿
±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý
±í2ÓÐ
1 10
2 30
3 5
ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......
ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î
oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......