¡¾×ªÔØ¡¿SQL ServerÊý¾ÝÀàÐÍÏê½â
Êý¾ÝÀàÐÍÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬ÊÇÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖÓïÑÔ¶¼ÓÐËü×Ô¼ºËù¹ÌÓеÄÊý¾ÝÀàÐÍ£¬SQL ServerÌṩһÏÂ25ÖÖ¹ÌÓеÄÊý¾ÝÀàÐÍ¡£
SQL ServerÊý¾ÝÀàÐÍÒ»ÀÀ±í
¡¡¡¡·Binary [(n)]
·Varbinary [(n)]
·Char [(n)]
·Varchar[(n)]
·Nchar[(n)]
·Nvarchar[(n)]
·Datetime
·Smalldatetime
·Decimal[(p[,s])]
·Numeric[(p[,s])]
·Float[(n)]
·Real
·Int
·Smallint
·Tinyint
·Money
·Smallmoney
·Bit
·Cursor
·Sysname
·Timestamp
·Uniqueidentifier
·Text
·Image
·Ntext
1¡¢¶þ½øÖÆÊý¾ÝÀàÐÍ£º
¶þ½øÖÆÊý¾ÝÓÉÊ®Áù½øÖÆÊý±íʾ£¬¿ÉÒÔʹÓà binary¡¢varbinary ºÍ image Êý¾ÝÀàÐÍ´æ´¢¡£
·binary ¹Ì¶¨³¤¶È£¨×î¶àΪ8K£©µÄ¶þ½øÖÆÊý¾ÝÀàÐÍ¡£
¡¡¡¡binary [ ( n ) ]
¹Ì¶¨³¤¶ÈµÄ n ¸ö×Ö½Ú¶þ½øÖÆÊý¾Ý¡£N ±ØÐë´Ó 1 µ½ 8,000¡£´æ´¢¿Õ¼ä´óСΪ n+4 ×Ö½Ú¡£
·varbinary ¿É±ä³¤¶È£¨×î¶àΪ8K£©µÄ¶þ½øÖÆÊý¾ÝÀàÐÍ¡£
¡¡¡¡varbinary [ ( n ) ]
n ¸ö×ֽڱ䳤¶þ½øÖÆÊý¾Ý¡£n ±ØÐë´Ó 1 µ½ 8,000¡£´æ´¢¿Õ¼ä´óСΪʵ¼ÊÊäÈëÊý¾Ý³¤¶È +4
¸ö×Ö½Ú£¬¶ø²»ÊÇ n ¸ö×Ö½Ú¡£ÊäÈëµÄÊý¾Ý³¤¶È¿ÉÄÜΪ 0 ×Ö½Ú¡£ÔÚ SQL-92 ÖÐ varbinary µÄ
ͬÒå´ÊΪ binary varying¡£
·image ÓÃÀ´´æ´¢³¤¶È³¬¹ý 8 KB µÄ¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£
³ý·ÇÊý¾Ý³¤¶È³¬¹ý 8KB£¬·ñÔòÒ»°ãÒËÓà varbinary ÀàÐÍÀ´´æ´¢¶þ½øÖÆÊý¾Ý¡£Ò»°ãÓÃÀ´´æ·Å Microsoft Word Îĵµ¡¢Microsoft Excel µç×Ó±í¸ñ¡¢°üº¬Î»Í¼µÄͼÏñ¡¢Í¼Ðν»»»¸ñʽ (GIF) ÎļþºÍÁªºÏͼÏñר¼Ò×é (JPEG) Îļþ¡£
ÔÚ Image Êý¾ÝÀàÐÍÖд洢µÄÊý¾ÝÊÇÒÔλ×Ö·û´®´æ´¢µÄ£¬²»ÊÇÓÉ SQL Server ½âÊ͵ģ¬±ØÐëÓÉÓ¦ÓóÌÐòÀ´½âÊÍ¡£ÀýÈ磬ӦÓóÌÐò¿ÉÒÔʹÓÃBMP¡¢TIEF¡¢GIF ºÍ JPEG ¸ñʽ°ÑÊý¾Ý´æ´¢ÔÚ Image Êý¾ÝÀàÐÍÖС£
2¡¢×Ö·ûÊý¾ÝÀàÐÍ
×Ö·ûÊý¾ÝÓÉ×Öĸ¡¢·ûºÅºÍÊý×Ö×é³É¡£Ê¹Óà char¡¢varchar ºÍ text Êý¾ÝÀàÐÍ´æ´¢¡£
·char ¹Ì¶¨³¤¶È£¨²»³¬¹ý 8 KB£©µÄ×Ö·ûÊý¾ÝÀàÐÍ¡£
&n
Ïà¹ØÎĵµ£º
1.Çó1..10żÊýÖ®ºÍ
select sum(level) from dual
where mod(level,2)=0
connect by level
2.½«update¸Ä»»³ÉÓÃrowidÀ´ÊµÏÖ¡£
£¨1£©ÐµÄд·¨£º
merge into SNAPSHOT120_2010_572 t1
using (select a.rowid rid, b.vip_level, b.manager_name
from xyf_vip_info_new b, snapsho ......
Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
µÚÒ»ÖÖ£º
SELECT
CASE
WHEN
price IS NULL THEN
'Not yet priced'
WHEN
price < 10 THEN
'Very Reasonable Title'
WHEN
price >= 10 AND
price < 20 THEN
'Coffee Table Title'
EL ......
ÓÐÖ´ÐÐsqlÌõ¼þÓï¾äwhere id in(@²ÎÊý)µÄʱºò£¬Èç¹û´¦Àí²»µ±£¬¾Í»á³öÏÖÎÊÌ⣺
ÈçÏÂÃæÕâ¸ö´æ´¢¹ý³Ì£º
alter proc Web_gettwtwgoldgameserverGoldSell
@ID int
as
declare @twgoldsellID nvarchar(1000)
select @twgoldsellID=twgoldsellID from twgoldgameserver where ID=@ID
set @twgoldsellID=replace(@twgoldsell ......