Question1£º
Êý¾ÝÀàÐÍ£ºchar¡¢varchar¡¢nvacharµÄÇø±ð¡£
£¨1£©charµÄ³¤¶ÈÊǹú¶¨µÄ£¬×î´óÖ§³Ö2000¸ö×Ö½Ú£¬Eg:¶¨Òåchar£¨20£©£¬¼´Ê¹Äã²åÈëabc3¸ö×Ö½Ú£¬Êý¾Ý¿âÒ²»áÔÚabcºóÃæ×Ô¶¯¼ÓÈë17¸ö¿Õ¸ñ£¬ÒÔ²¹×ã20¸ö×Ö½Ú¡£charÊÇÇø·ÖÖÐÓ¢Îĵģ¬ÖÐÎÄÔÚcharÖÐÊÇÕ¼2¸ö×Ö½Ú£¬¶øÓ¢ÎÄÊÇÕ¼Ò»¸ö×Ö½Ú¡£
£¨2£©varcharÊdz¤¶È²»¹Ì¶¨µÄ¡¢×î´óÖ§³Ö4000¸ö×Ö½Ú¡£µ±Ä㶨ÒåÁËvarchar£¨20£©£¬Ö»²åÈëabc3¸ö×Ö½Úʱ£¬ÔòÊý¾Ý¿âÒ²Õ¼3¸ö×Ö½Ú¡££¨varcharͬÑùÇø·ÖÖÐÓ¢ÎÄ£¬Ò»°ã²»ÓÃÓ뺬ÖÐÎĵÄÇé¿ö£©¡£
£¨3£©nvarchar²»Çø·ÖÖÐÓ¢ÎÄ£¬¶¨ÒåÁËnvarchar£¨20£©£¬¿ÉÒÔ´æ·Å20¸öÓ¢ÎÄ×Öĸ»ò20¸öºº×Ö£¬Õâ¸ö20¶¨ÒåÊÇ×Ö·ûÊý»¹²»ÊÇ×Ö½ÚÊý£¬ÊÊÓÃÓÚ´æ·ÅÖÐÎÄ¡£
Question2£º
Éæ¼°µ½SQL SERVERÊý¾Ý¿â£º
ÈëÃż¶£ºSelect£¬Insert£¬Update£¬Delete
½ø½×¼¶£ºInner Join£¬Left Join£¬Right Join£¬Union All
ÒÔ¼°ÏÂÃæsqlµÄÓï¾äµÄÒâ˼¡£
ETL¼¶£ºSelect¡¡Into¡¡From¡¡ Where¡¡
Insert Into¡¡Select¡¡From¡¡ Where¡¡
Update¡¡Set¡¡From¡¡Where¡¡
Truncate table£¬Drop table£¬Delete From table
SQLÖг£¼û¸ÅÄÖ÷¼ü¡¢Ë÷Òý¡¢ÊÓͼ¡¢´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢×÷Òµ
SQL SERVER ±¸·ÝÀàÐÍ£ºÍêÕû¡¢²îÒì
µ±ÄãÄÜÀí½âÒÔÉÏÄÚÈÝ£¬¾Í¿ÉÒÔͨ¹ýSQLÊý¾Ý¿âµÄÃæÊÔÁË¡£