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ÉÏ£¬³ý·
Ïà¹ØÎÊ´ð£º
Ôõô»¹Ã»³öÀ´£¿£¿
ËÔÚ͵ÀÁÂð£¿!
Íê±Ï¡£
1
SF
3
bd
ûÁË
00
還ÒÔ為ÊÇÐÂ聞~~
ÒýÓÃ
還ÒÔ為ÊÇÐÂ聞~~
w
...
..
ÒýÓÃ
ű ......
SQL code:
For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice
from T_BO_DeclareInvoice Di
WHERE bs_code = as_bs_code)
LOOP
IF Ls_desc.Di_ename IS ......
ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿
with Query do begin
tempParam=parameters.addparameter;
tempParam.name='@begindate';
tempParam.Da ......
ĿǰÓбíAºÍ±íB
ÆäÖÐ×Ö¶ÎÏàͬ
±íAÖÐÖ÷¼üidΪ×ÔÔö³¤
²¢ÇÒΪ´óÊý¾ÝÁ¿´¢´æ
ÔõôÑùʹÓô洢¹ý³Ì¿ÉÒÔ½«±íAÖеÄÊý¾Ý±¸·Ýµ½±íBÖУ¬²¢ÇÒɾ³ý±íAÖб¸·Ý¹ýµÄÊý¾Ý
¸ßÊÖ¸øÒ»¸ö´æ´¢¹ýÊ££¬Ð»Ð»
·ÖÇø±í¿ÉÒÔ½«±íÖÐµÄ ......
ÇëÎÊÔÚ¸³ÓèÊý¾Ý¿â½Çɫʱ£¬»áÓÐÕâ¸öȨÏÞÑ¡ÔñÃæ°å£¬Í¨³£MSSQLÀïÃæµÄ¿ò¿ò¶¼ÊÇ¿Õ×Å£¬Õâ¸öȨÏÞÑ¡Ôñ¿òÓÐÈýÖÖ״̬£¬
1¡¢¿Õ×Å
2¡¢Ñ¡ÖУ¬ÂÌÉ«µÄ¹´
3¡¢È¡Ïû£¬ºìÉ«µÄ²æ²æ¡£
Ñ¡ÖкÜÈÝÒ×Àí½â£¬µ«Èç¹û¶¼²» ......