Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ͳ¼ÆÎÊÌâ

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
......

mssql ÈçºÎÍêÕûµÄµ¼Èë±í½á¹¹

¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔ­À´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô­»òÕ߸½¼ÓÊÇΨ ......

Çë½Ì¸ßÊÖMSSQLÈ¥¿Õ¸ñÎÊÌ⣿THK£¡

Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó

    A(×Ö¶Î)
------------------------
a b  c
ab  c
f c d


½á¹û:

    A(×Ö¶Î)
------------------------È ......

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý

±í2ÓÐ
1  10
2  30
3  5

ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......

¹ØÓÚoracleÊý¾Ý¿âÒÆÖ²µ½mssqlµÄÎÊÌâ.

ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î


oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ