¡¾×ªÔØ¡¿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
Ïà¹ØÎĵµ£º
SQL Select IntoÓï¾ä
The SELECT INTO Statement
SELECT INTO Óï¾ä
The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.
SELECT INTOÓï¾ä³£ÓÃÀ´¸øÊý¾Ý±í½¨Á¢±¸·Ý»òÊÇÀúÊ·µµ°¸¡£
Syntax
Óï·¨
SELECT column_name(s) INTO newtable [IN externaldatabase] ......
µ±Ê¹ÓÃMicrosoft SQL Server 2008 Management Studioʱ£¬ÓÐʱÔÚ±íÉè¼ÆÆ÷ÖжԱíËù×öµÄ¸ü¸ÄÎÞ·¨±£´æ£¬¾ßÌå±íÏÖΪ£ºµã»÷±£´æ°´Å¥ºóµ¯³ö±£´æ¶Ô»°¿òÌáʾ£º²»ÔÊÐí±£´æÐÞ¸Ä(Saving changes is not permitted)£¬µ¯³öµÄ¶Ô»°¿òÖ»ÓÐ2¸ö°´Å¥¿ÉÒÔµã»÷£¬Ò»¸öCancelÒ»¸öSave Text File£¬Ç°Ò»¸ö¾Í²»ÓÃ˵ÁË£¬ºóÒ»¸ö±£´æµÄÎļþ¸ù±¾Ã»ÒâÒ壨¿ÉÒ ......
ÓÐÖ´ÐÐ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 ......