Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

ASP.NET ÖÐÈçºÎ·À·¶SQL×¢Èëʽ¹¥»÷

Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷?
¡¡¡¡ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ­·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±í
µ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥
»÷¹ý³ÌÀàÈ磺 ......

DBMS_SQL°üʵÏÖ¶¯Ì¬SQL

.ÔÚ²éѯÖлáÓöµ½ UNION ALL,ËüµÄÓ÷¨ºÍunionÒ»Ñù,Ö»²»¹ýunionº¬ÓÐdistinctµÄ¹¦ÄÜ,Ëü»á°ÑÁ½ÕűíÁËÖØ¸´µÄ¼Ç¼ȥµô,¶øunion all²»»á,ËùÒÔ´ÓЧÂÊÉÏ,union all »á¸ßÒ»µã.
2.union all Êǰ´Ô­ÏÈ˳ÐòÅÅÁеģ¬union °ÑÁ½ÕűíÖеÄÖØ¸´Êý¾ÝÈ¥µôºó»¹½øÐÐÁËÖØÐÂÅÅÐò
ÉùÃ÷£º´ËÎÄÀ´Ô´ÓÚÍøÂ·£¡
ÄÚÈÝÕªÒª£ºÔÚPL/SQL¿ª·¢¹ý³ÌÖУ¬Ê¹ÓÃSQL£¬ ......

sql ²éѯ³öÀ´Ò»¸ö±íÔÚ²åÈëµ½ÁíÒ»¸ö±íÀï

ALTER  FUNCTION  [dbo].[fun_tongji]()
RETURNS  @t1 table (
  yue int ,
  money int
 )
AS
begin
 Declare @i int
 set @i=1
-- declare @t1 table (
--  yue int ,
--  money int
-- )
 while (@i<=12)&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ