Sql Server×Ö¶ÎÀàÐ͵Ä×Ö·û³¤¶È
sql serverÊý¾ÝÀàÐÍcharºÍnchar,varcharºÍnvarchar,textºÍntextÔÊÐíµÄ×Ö·û³¤¶È
×Ö·û´®
char
¹Ì¶¨³¤¶ÈµÄ·Ç Unicode ×Ö·ûÊý¾Ý£¬×î´ó³¤¶ÈΪ 8,000 ¸ö×Ö·û¡£
varchar
¿É±ä³¤¶ÈµÄ·Ç Unicode Êý¾Ý£¬×Ϊ 8,000 ¸ö×Ö·û¡£
text
¿É±ä³¤¶ÈµÄ·Ç Unicode Êý¾Ý£¬×î´ó³¤¶ÈΪ 2^31 - 1 (2,147,483,647) ¸ö×Ö·û¡£
Unicode ×Ö·û´®
nchar
¹Ì¶¨³¤¶ÈµÄ Unicode Êý¾Ý£¬×î´ó³¤¶ÈΪ 4,000 ¸ö×Ö·û¡£
nvarchar
¿É±ä³¤¶È Unicode Êý¾Ý£¬Æä×î´ó³¤¶ÈΪ 4,000 ×Ö·û¡£sysname ÊÇϵͳÌṩÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÔÚ¹¦ÄÜÉϵÈͬÓÚ nvarchar(128)£¬ÓÃÓÚÒýÓÃÊý¾Ý¿â¶ÔÏóÃû¡£
ntext
¿É±ä³¤¶È Unicode Êý¾Ý£¬Æä×î´ó³¤¶ÈΪ 2^30 - 1 (1,073,741,823) ¸ö×Ö·û¡£
¶þ½øÖÆ×Ö·û´®
binary
¹Ì¶¨³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý£¬Æä×î´ó³¤¶ÈΪ 8,000 ¸ö×Ö½Ú¡£
varbinary
¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý£¬Æä×î´ó³¤¶ÈΪ 8,000 ¸ö×Ö½Ú¡£
image
¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý£¬Æä×î´ó³¤¶ÈΪ 2^31 - 1 (2,147,483,647) ¸ö×Ö½Ú¡£
Ïà¹ØÎĵµ£º
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËØ¸öÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûºÅ
)
......
¶àÓàµÄ»°¾Í²»¶à˵ÁË£¬ÕýÊÔlinq to sqlµÄѧϰ¡£
ÏÈÀ´¿´¿´linq to sql µÄÌØÐÔ:
×Ô¶¯ÊôÐÔ(Auto-Implemented Properties)
Òþº¬ÀàÐ;ֲ¿±äÁ¿(Local Variable Type Inference)
ÄäÃûÀàÐÍ(Anonymous Types)
¶ÔÏóÓ뼯ºÏ³õʼ»¯Æ÷(Object and Collection Initializers)
À©Õ¹·½·¨(Extension Methods)
Lambda±í´ïʽºÍLambda±í´ïʽ ......
ÏÖÔÚÓÃMSSQLµÄµØ·½Ì«¶àÁË£¬Óкܶà×ö¼¼ÊõµÄ¸öÈ˵çÄÔÉÏÒ²°²×°SQLרҵ°æ£¬ÒòΪËüÓõĶ࣬µ«ÓõÄÈ˶¼ÖªµÀ£¬SQLÓиö³¬¼¶Óû§sa£¬´ËÓû§Ä¬ÈÏÇé¿öÏ£¬ËüÖ¸Åɸø¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin£¬²¢²»ÄܽøÐиü¸Ä¡£Ò»°ã¶®µã°²È«ÎÊÌâµÄ¼¼ÊõÈËÔ±¶¼»á°ÑÕâ¸öÃÜÂëÐ޸ĵô£¬µ«ÐÞ¸ÄÔÙ¸´ÔÓµÄÃÜÂë¶¼²»ÊǾø¶Ô°²È«µÄ£¬Ò»Ð©±©Á¦ÆÆ½âÈí¼þ£¬²ËÄñ¶¼»áÓá£
ÄÇ ......