ÈçºÎÔÚ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Öиñʽ²»»áÏûʧ¡£
Ïà¹ØÎĵµ£º
1. »ñÈ¡Êý¾Ý¿âÖе±Ç°Ô·ݵÄÏà¹ØÊý¾Ý
SELECT WorkerSortID, SUM(WorkerCount) AS WorkerMothCount
from WorkerRecord
WHERE (YEAR(WorkerTime) = YEAR({ fn NOW() })) AND (MONTH(WorkerTime)
= MONTH({ fn NOW() })) AND (WorkerCount > 0) AND (WorkerID = 'wy')
GROUP BY Worker ......
SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Ò»£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ ......
Distinct
SELECT DISTINCT "À¸Î»"
from "±í¸ñÃû"
Where
SELECT "À¸Î»"
from "±í¸ñÃû"
WHERE "condition"
And/Or
SELECT "À¸Î»"
from "±í¸ñÃû"
WHERE "¼òµ¥Ìõ¼þ"
{[AND|OR] "¼òµ¥Ìõ¼þ"}+
In
SELECT "À ......
»ñÈ¡¡¢Ôö¼Ó¡¢Ð޸ġ¢É¾³ý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 ......
Ò».Êý¾Ý¿ØÖÆÓï¾ä (DML) ²¿·Ö
1.Insert (ÍùÊý¾Ý±íÀï²åÈë¼Ç¼µÄÓï¾ä)
Insert INTO ±íÃû(×Ö¶ÎÃû1, ×Ö¶ÎÃû2, ……) VALUES ( Öµ1, Öµ2, ……);
&nb ......