ÈçºÎÔÚ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Öиñʽ²»»áÏûʧ¡£
Ïà¹ØÎĵµ£º
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¸ÄÉÆSQLÓï¾ä
¡¡¡¡ºÜ¶àÈ˲»ÖªµÀSQLÓï¾äÔÚSQL SERVERÖÐÊÇÈçºÎÖ´Ðеģ¬ËûÃǵ£ÐÄ×Ô¼ºËùдµÄSQLÓï¾ä»á±»SQL SERVERÎó½â¡£±ÈÈ磺
select * from table1 where name=''zhangsan'' and tID > 10000
ºÍÖ´ÐÐ:
select * from table1 where tID > 10000 and name=''zhangsan''
¡¡¡¡Ò»Ð©È˲»ÖªµÀ ......
4.6 ͨ¹ýÈÕÖ¾²é¿´·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005¿ÉÒÔ½«Ä³Ð©ÏµÍ³Ê¼þºÍÓû§×Ô¶¨ÒåµÄʼþ¼Ç¼µ½SQL Server´íÎóÈÕÖ¾ºÍWindowsÓ¦ÓóÌÐòÈÕÖ¾ÖС£ÕâÁ½ÖÖÈÕÖ¾¶¼»á×Ô¶¯±êÉÏʱ¼ä¡£
4.6.1 ÔÚ¡¾Ê¼þ²é¿´Æ÷¡¿Öв鿴·þÎñÆ÷µÄÔËÐÐÇé¿ö
SQL Server 2005·þÎñÆ÷µÄÆô¶¯¡¢¹Ø±ÕºÍÔÝÍ£¶¯×÷£¬¶¼»á²úÉúÒ»¸öʼþ¼Ç¼£¬Õâ¸ö¼Ç¼½«»á¼ÇÔÚWindows ......
SQL ServerÖÐÎİæµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
Õâ¶ÔÓÚÔÚÒª²»Í¬Êý¾Ý¿â¼ä×ªÒÆÊý¾Ý»òÕßϰ¹ßoracleÈÕÆÚ¸ñʽYYYY-MM-DD HH24:MI:SSµÄÈ˶àÉÙÓÐЩ²»·½±ã.
ÎÒÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄܾ³£»áÓõ½µÄÈÕÆÚ¸ñʽת»»·½·¨:
¾ÙÀýÈçÏÂ:
select CONV ......
Ò»¶Îʱ¼äÀ´£¬Ã¿ÌìµÄ¹¤×÷¶¼±È½ÏÔÓ£¬vb,asp,c#,sql£¬Ã¿Ï×÷¶¼Òª¸ã£¬ÊµÔÚÊÇÀÛ£¡¹¤×÷Ö®Ó࣬ÏëÏ빫˾ºÍ¹¤×÷µÄÇé¿ö£¬¿´À´ÊÇÓбØÒª»»¸ö»·¾³ÁË¡£²»¹ýÒ²ÒªÏȰÑĿǰµÄ¹¤×÷´¦ÀíÍê³É°¡¡£
×î½üÓÖÓöµ½Ò»¸öÎÊÌ⣺һ¼Ò¿Í»§Ê¹ÓÃÖеÄÊý¾Ý¿â£¬ÈÕÖ¾ÎļþÒì³£Ôö´ó£¬Æ½¾ùÿÌìÔö¼Ó´óÔ¼Ò»¸öG£¬¶øÊý¾ÝÎļþ±ä» ......
»ñÈ¡¡¢Ôö¼Ó¡¢Ð޸ġ¢É¾³ýsqlserver×Ö¶ÎÃèÊö
Select o.name AS tableName, c.name AS columnName, p.[value] AS Description
from sysproperties p INNER JOIN
sysobjects o ON o.id = p.id INNER JOIN
syscolumn ......