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) ¸ö×Ö½Ú¡£
Ïà¹ØÎĵµ£º
The aspnet_Profile table contains the following fields: UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, and LastUpdatedDate. The PropertyNames field contains a string delimited with colons (:) that identify which profile fields are stored, what their datatype is and their of ......
Ò»¡¢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²¢Ðвéѯ
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --Ð޸ĻỰ²¢ÐÐDML select /*+parallel(a,4)*/ * from table_name a select /*+parallel(a,8)*/ * from table_name a ......
ÎÊÌâµÄÌá³ö£º
ÏÖÓбíA£¬ÄÚÈÝÈçÏ£º
±àÂë ²Ö¿â ÊýÁ¿
01 A 6
01 B 7
02 A & ......
ÖÚËùÖÜÖª£¬SQL ServerÖ´ÐÐSQLÓï¾äµÄÐÔÄÜÅж¨±ê×¼Ö÷ÒªÊÇIO¶ÁÈ¡Êý´óС¡£±¾ÎÄÔÚ²»Î¥·´ÕâÒ»ÔÔòÇé¿öÏ£¬Í¬Ê±À´·ÖÎöһϲ¿·ÖSQLÓï¾äÖ´ÐÐʱ£¬SQL ServerÄÚ´æµÄ±ä»¯Çé¿ö¡£
Ê×ÏȼòÊöÒ»ÏÂSQL ServerÄÚ´æÕ¼ÓõÄÌØµã¡£SQL ServerËùÕ¼ÓõÄÄÚ´æ³ý³ÌÐò£¨¼´SQL
ServerÒýÇæ£©Í⣬Ö÷Òª°üÀ¨»º´æµÄÊý¾Ý£¨Buffer£©ºÍÖ´Ðмƻ®£¨Cache£©¡£SQL ......