SQL Server ÎÞÕʺŻòÍü¼ÇÃÜÂëµÇ½ÎÊÌâ
Question 1£º
Êý¾Ý¿âµÄÑé֤ģʽΪWindowsÑéÖ¤£¬É¾³ýÁËMS SQL ServerÕʺÅBUILTIN\Administrators,µÇ½²»ÉÏSQL Server¹ÜÀíÆ÷£¿
Answer£º
1.ÖØÐÂÔËÐÐMS SQL SERVERµÄ°²×°³ÌÐò£¬ÔÚ“°²×°Ñ¡ÏçÃæÀïÑ¡Ôñ“¸ß¼¶Ñ¡Ï¬ÏÂÒ»²½ºóÑ¡Ôñ“×¢²á±íÖؽ¨”£¬½ÓÏÂÀ´¸ú°²×°¹ý³Ì²î²»¶à£¬×¢ÒâÔÚÑ¡Ôñ“Éí·ÝÑé֤ģʽ”µÄʱºòÑ¡Ôñ“»ìºÏģʽ”£¬Ä¿µÄÊÇʹsaÕÊ»§ÓÐЧ¡£
2.Öؽ¨Íê³ÉÒÔºó£¬Óòéѯ·ÖÎöÆ÷£¬Ê¹ÓÃsaÕÊ»§µÇ¼£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐ sp_grantlogin 'builtin\administrators'£¬ÕâÑù¾Í»Ö¸´windowsÉí·ÝÑéÖ¤ÁË¡£
Question 2£º
Êý¾Ý¿âµÄÑé֤ģʽΪ»ìºÏÑéÖ¤£¬ÎÞsaÕʺŵÄÃÜÂ룬ɾ³ýÁËMS SQL ServerÕʺÅBUILTIN\Administrators,µÇ½²»ÉÏSQL Server¹ÜÀíÆ÷£¿
Answer£º
1.°ÑMSsqlserver·þÎñÍ£Ö¹£¬°Ñ master.mdfºÍmastlog.ldf Îļþ¿½±´³öÀ´¡£
2.ÔÚ±ðµÄsqlserver·þÎñÆ÷ÉÏ£¬°ÑÎļþ¸½¼Ó³ÉÊý¾Ý¿âAAA(Êý¾Ý¿âÃû³Æ×Ô¼º¾ö¶¨£¬ÕâÀï¼ÙÉèÊÇAAA),È»ºóÖ´ÐÐ update AAA..sysxlogins set password=null where name='sa'
3.°Ñmaster.mdfºÍmastlog.ldfÁ½¸öÎļþ¸²¸Çµ½SQL Server°²×°Ä¿Â¼µÄdataĿ¼Ï£¬Æô¶¯SQL Server£¬´ËʱsaÃÜÂëΪ¿Õ.
Ïà¹ØÎĵµ£º
1¡¢Î½´Ê ν´ÊÔÊÐíÄú¹¹ÔìÌõ¼þ£¬ÒÔ±ãÖ»´¦ÀíÂú×ãÕâЩÌõ¼þµÄÄÇЩÐС£
2¡¢Ê¹Óà IN ν´Ê
ʹÓà IN ν´Ê½«Ò»¸öÖµÓëÆäËû¼¸¸öÖµ½øÐбȽϡ£ÀýÈ磺
SELECT NAME from STAFF WHERE DEPT IN (20, 15)
´ËʾÀýÏ൱ÓÚ£º
SELECT NAME from STAFF WHERE DEPT = 20 OR DEPT = 15
µ±×Ó²éѯ·µ»ØÒ»×éֵʱ£¬¿ÉʹÓà IN ºÍ NOT IN ÔËËã·û¡£ÀýÈç£ ......
shopxpÍøÉϹºÎïϵͳ v7.4´æÔÚSql×¢È멶´¡£
ÎÊÌâÎļþ£ºxpCatalog_xpDesc.asp£¬xpCatalog_xpsmall_Desc.asp
ÎÊÌâ´úÂ룺
<%
dim shopxpbe_id, anclassname, shopxpse_id, nclassname
dim totalPut
dim CurrentPage, TotalPages
if request("shopxpbe_id")<>"" then
shopxpbe_id=request("shopxpbe_id")
e ......
1 PLS_INTEGER
PLS_INTEGER¿ÉÒÔ´æ´¢Ò»¸öÓзûºÅµÄÕûÐÎÖµ£¬Æ侫¶È·¶Î§ºÍBINARY_INTEGERÒ»Ñù£¬ÊÇ£º-2^31~2^31¡£
PLS_INTEGERºÍNUMBER±È½ÏÆðÀ´£¬ÆäÓŵãÊÇ£º
1).Õ¼ÓнÏÉٵĴ洢¿Õ¼ä£»
2).¿ÉÒÔÖ±½Ó½øÐÐËãÊõÔËË㣨ÔÚNUMBERÉϲ»ÄÜÖ±½Ó½øÐÐËãÊõÔËË㣬Èç¹ûÒª¼ÆË㣬NUMBER±ØÐëÏȱ»×ª»»³É¶þ½øÖÆ£©¡£ËùÒÔÔÚ½øÐÐËãÊõµÄʱºòPLS_INTEGER ......
·½·¨Ò»£º
´ò¿ªÆóÒµ¹ÜÀíÆ÷£>SQL SERVRE ×é£>(local)window NT ->ÊôÐÔ
²úÆ·:ÓÐpersonalµÄÊǸöÈË°æµÄ£¬ÓÐEnterpriseµÄÊÇÆóÒµ°æµÄ
²úÆ·°æ±¾£º8.00.2039(sp4);8.00.760(sp3)
·½·¨¶þ£º
µÚÒ»²½£ºÔÚ²éѯ·ÖÎöÆ÷
select @@version
print @@version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 ......