Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Êý¾Ý¿â×Ö¶ÎÀàÐÍ SQL Server

—×Ö·ûÀàÐÍ
Char: ¶¨³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Varchar:±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Text(varchar(max)):±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ2G
Nchar:¶¨³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Nvarchar:±ä³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Ntext(nvarchar(max)):±ä³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ2G
—ÊýÖµÀàÐÍ
Bit£º0»ò1µÄÕûÐÍÊý×Ö
Tinyint£º ´Ó0µ½255µÄÕûÐÍÊý×Ö
Smallint:£º´Ó-2^15(-32,768)µ½2^15(32,767)µÄÕûÐÍÊý×Ö
Int£º´Ó-2^31(-2,147,483,648)µ½2^31(2,147,483,647)µÄÕûÐÍÊý×Ö
Bigint£º´Ó-2^63µ½2^63-1µÄÕûÐÍÊý×Ö£¨2000ºÃÏñÊÇûÓеģ©
Smallmoney£º  ´Ó-2^31µ½2^31µÄ»õ±ÒÊý¾Ý£¬×îС»õ±Òµ¥Î»Ç§·Ö֮ʮ
Money£º  ´Ó-2^63µ½2^63-1µÄ»õ±ÒÊý¾Ý£¬×îС»õ±Òµ¥Î»Ç§·Ö֮ʮ
Decimal£º´Ó-10^38µ½10^38-1µÄ¶¨¾«¶ÈÓëÓÐЧλÊýµÄÊý×Ö
Numeric£º decimalµÄͬÒå´Ê
Float£º  ´Ó-1.79E+308µ½1.79E+308¿É±ä¾«¶ÈµÄÊý×Ö
Real£º´Ó-3.04E+38µ½3.04E+38¿É±ä¾«¶ÈµÄÊý×Ö
—ÈÕÆÚºÍʱ¼äÀàÐÍ
Datetime£º ´Ó1753Äê1ÔÂ1ÈÕµ½9999Äê12ÈÕ31µÄÈÕÆÚºÍʱ¼äÊý¾Ý£¬×îСʱ¼äµ¥Î»Îª°Ù·ÖÖ®ÈýÃë»ò3.33ºÁÃë¡£³¤¶ÈΪ8¸ö×Ö½Ú£¬µÚÒ»¸ö4×Ö½Ú´æ´¢base date £¨¼´ 1900 Äê 1 Ô 1 ÈÕ£©Ö®Ç°»òÖ®ºóµÄÌìÊý£¬Èç¹ûÊÇ1900 Äê 1 Ô 1 ÈÕÔò´æ´¢0£¬ÁíÍâÒ»¸ö 4 ×Ö½Ú´æ´¢ÒÔÎçÒ¹ºóÿÌìµÄʱ¼ä
Smalldatetime£º´Ó1900Äê1ÔÂ1ÈÕµ½2079Äê6ÔÂ6ÈÕµÄÈÕÆÚºÍʱ¼äÊý¾Ý£¬×îСʱ¼äµ¥Î»Îª·ÖÖÓ. ´æ´¢ÈÕÆÚºÍÿÌìµÄʱ¼ä£¬µ«¾«È·¶ÈµÍÓÚ datetime ¡£³¤¶ÈΪ4¸ö×Ö½Ú£¬µÚÒ»¸ö2×Ö½Ú´æ´¢1900 Äê 1 Ô 1 ÈÕºóµÄÌìÊý£¬µÚ¶þ¸ö2×Ö½Ú´æ´¢ÎçÒ¹ºóµÄ·ÖÖÓÊý¡£
¿ÉÒÔ½«ÕâÁ½ÖÖÀàÐÍת»»³Éfloat ¸¡µãÊý, ÆäÖÐÕûÊý²¿·Ö¾ÍÊǶÔÓ¦µÄÈÕÆÚ×Ö½Ú, ¶øÐ¡Êý²¿·ÖÊÇʱ¼äÏàÓ¦µÄ±ÈÀý
—2008ÐÂÔöµÄÈÕÆÚʱ¼äÀàÐÍ
Date£º½ö´æ´¢ÈÕÆÚ£¬·¶Î§ÊÇ´Ó 1000 Äê 1 Ô 1 ÈÕµ½ 9999 Äê 12 Ô 31 ÈÕ£¬3 ×Ö½Ú³¤¶È£¬ÇÒ¾«¶ÈΪ 10 λ¡£Date ÀàÐ͵Ä׼ȷÐÔ½öÏÞÓÚµ¥Ìì¡£
Time£º½ö´æ´¢Ò»ÌìÖеÄʱ¼ä£¬Ö§³ÖµÄ·¶Î§ÊÇ 00:00:00.0000000 µ½ 23:59:59.9999999£¨Ð¡Ê±¡¢·ÖÖÓ¡¢ÃëºÍСÊýÃ룩¡£¿ÉÔÚ´´½¨Êý¾ÝÀàÐÍʱָ¶¨Ð¡ÊýÃëµÄ¾«¶È¡£Ä¬ÈϾ«¶ÈÊÇ 7 λ£¬×¼È·¶ÈÊÇ 100 ºÁ΢Ãë¡£¾«¶ÈÓ°Ïì×ÅËùÐèµÄ´æ´¢¿Õ¼ä´óС£¬·¶Î§°üÀ¨×î¶à 2 λµÄ 3 ¸ö×Ö½Ú¡¢3 »ò 4 λµÄ 4 ¸ö×Ö½ÚÒÔ¼° 5 µ½ 7 λµÄ 5 ¸ö×Ö½Ú¡£
Datetime2£ºdatetime ÀàÐ͵ÄÀ©Õ¹,ÈÕÆÚ·¶Î§ÊÇ 0001 Äê 1 Ô 1 ÈÕµ½ 9999 Äê 12 Ô 31 ÈÕ,Óë tim


Ïà¹ØÎĵµ£º

SQL SERVER 2005Êý¾Ý¿â¾µÏñ

ͨ¹ýµÚÆßÆÚºÍµÚ°ËÆÚµÄÎÄÕ£¬ÎÒÃÇÁ˽âÁËSQL SERVER 2005Êý¾Ý¿âµÄÔ­Àí¡¢ÊµÏÖ·½Ê½ÒÔ¼°SQL SERVER 2005Ôڸ߿ÉÓᢸßÐÔÄܺ͸߱£»¤Ä£Ê½Ï»áÓв»Í¬µÄÊý¾Ý¿â¾µÏñ״̬£¬¶øÇÒÁ˽âÁËSQL SERVER 2005ÔÚ²»Í¬Ó¦ÓÃģʽϹÊÕÏ×ªÒÆµÄ·½Ê½¡£½ÓÏÂÀ´£¬ÎÒÃǽ«¸ù¾ÝÒÔÏÂÁ½Ààʼþ¶ÔÊý¾Ý¿â¾µÏñÔ¤ÆÚµÄ¿ÉÓÃÐÔ½øÐзÖÎö£º
Ò»¸ö»ò¶à¸ö·þÎñÆ÷»òÕßÊý¾Ý¿âʧ° ......

SQL 2005 xml ´¦ÀíµÄһЩsample

USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......

oracle SQL·ÖÀà

ORACLE ÖÐSQL Óï¾ä´óÖ¿ÉÒÔ·ÖΪ4´óÀà
1.DQL£¨data quary language Êý¾Ý²éѯÓïÑÔ£©
Êý¾Ý²éѯÓïÑÔDQL»ù±¾½á¹¹ÊÇÓÉSELECT×Ӿ䣬from×Ӿ䣬WHERE×Ó¾ä×é³É
2.DDL£¨data definition language Êý¾Ý¶¨ÒåÓïÑÔ£©
CREATE
ALTER
DROP
RENAME
TRUNCATE
3.DML£¨data manipulation language Êý¾Ý²Ù×ÝÓïÑÔ£©
INSERT
UPDATE ......

SQL Server Out Put Excel File

SQL Server Out Put Excel File
ÔÚ SQL ServerÖÐ, µ¼³öEXCEL Îļþ, Óõ½ bcp.exe
 
 bcp  µ¼³öµÄ±¾ÖÊÊÇ´¿Îı¾Îĵµ,
ÈôÊý¾Ýº¬ÓÐÖÐÎÄ,Çëµ¼³öµ½ÖÐÎİæEXCEL,»òTXTÎĵµµÈ, ·ñÔòÂÒÂë....
ÓÃTXT ´ò¿ªÓ¢ÎİæEXCEL,Ò²¿ÉÒÔ,
 
µ¼³ö Êý¾Ýµ½C:\authors.xls, ÈôÎļþ´æÔÚÔòÖØÐ´Îļþ, ²»´æÔÚÔò´´½¨Îļþ
  ......

sql±¸·ÝÊý¾Ý¿âÓï¾ä:SQL±¸·ÝÓï¾ä

--ÍêÕû±¸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Full_20070908.bak'
--²îÒ챸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Df_20070908.bak'
With Dferential
--ÈÕÖ¾±¸·ÝĬÈϽضÏÈÕÖ¾
Backup Log NorthwindCS
To disk='G:\Backup\NorthwindCS_Log_20070908. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ