SQL Server 2008 FileStream
FileStream:ÎļþÁ÷,ΪÁ˽â¾ö´ó¶ÔÏóBLOB(Binary Large Objects)µÄ´æ´¢ÎÊÌâ.¶ÔÓÚ´ó¶ÔÏó´æ´¢,²¢ÇÒ²»ÊÜ2GBµÄÏÞÖÆ.
ÒÔÍùÓÐÁ½ÖÖ·½Ê½:
(1)´æ´¢ÔÚÊý¾Ý¿âÀïÃæ,ÕâÖÖ·½Ê½Ò»°ãʹÓÃimage×Ö¶Î,»òÕßvarbinary(max)À´×ö,ºÃ´¦ÊÇ¿ÉÒÔͳһ±¸·Ý,µ«Êµ¼ÊЧÂʽϵÍ;
(2)´æ´¢ÔÚÎļþϵͳ,¶øÊý¾Ý¿âÖд洢Îļþ·¾¶,ÕâÖÖ·½Ê½Êý¾Ý¿âѹÁ¦¼õÇáÁË,µ«È´²»·½±ãͳһ±¸·ÝºÍ¹ÜÀí.
SQL SERVER 2008ÐÂÒýÈëµÄÎļþÁ÷¾ÍÊÇÁ½ÕßµÄͳһ.Îļþ»¹ÊÇ·ÅÔÚÎļþϵͳ,µ«ÓÉÊý¾Ý¿â½øÐйÜÀí,¿ÉÒÔͳһ±¸·ÝºÍ»¹Ô.
ÈçºÎʹÓÃFileStream?
Ò».ÆôÓÃFileStream
(1)ÔÚSQL ServerÅäÖùÜÀíÆ÷Öдò¿ªSQL ServerÊý¾Ý¿âÒýÇæµÄÊôÐÔ´°¿Ú.
(2)Çл»µ½FILESTREAMÑ¡Ï,Ñ¡ÖÐ"Õë¶ÔTransact-SQL·ÃÎÊÆôÓÃFILESTREAM",ÆäËûÑ¡ÏîÊÇÕë¶Ôwindows½øÐжÁдµÄ,¶¼¿ÉÒÔÑ¡ÖÐ.
(3)´ò¿ªSSMSÁ¬½Óµ½Êý¾Ý¿âʵÀý(ÊÇʵÀý,²»ÊǾßÌåµÄÊý¾Ý¿â),ÓÒ»÷Êý¾Ý¿âʵÀý,Ñ¡Ôñ"ÊôÐÔ"Ñ¡Ïî,Çл»µ½"¸ß¼¶"Ñ¡ÏîÒ³,ÔÚÎļþÁ÷·ÃÎʼ¶±ðÏÂÀÁбí¿òÖÐÑ¡Ôñ"ÒÑÆôÓÃÍêÈ«·ÃÎÊ"
¶þ.³õʼ»¯»·¾³
(1)Ìí¼ÓÎļþ×é
ALTER DATABASE [DBName] ADD FILEGROUP [FileGrp1] CONTAINS FILESTREAM
(2)Ìí¼Ó´æ·ÅÎļþµÄ·¾¶
ALTER DATABASE [DBName] ADD FILE(Name=N'filestream',FILENAME=N'C:\FileStream') TO FILEGROUP [FileGrp1]
ϵͳ½«×Ô¶¯´´½¨C:\FileStreamÎļþ¼Ð²¢ÔÚÆäÖÐдÈëfilestream.hdrÎļþ£¬¸ÃÎļþÊÇ FILESTREAMÈÝÆ÷µÄÍ·Îļþ²»ÄÜɾ³ý£¬Ò»¶¨ÒªÈ·±£ÔÚÔËÐиÃÓï¾ä֮ǰC:\FileStream²¢²»´æÔÚ¡£
×¢Òâ:Îļþ×鱨Ð붨ÒåÔÚNTFS¸ñʽ·ÖÇøÏµĴÅÅÌ,²¢ÇÒÐèÒªÖ¸Ïò±¾µØÎļþϵͳλÖÃÉÏ,²»ÔÊÐíÖ¸ÏòÍøÂçµØÖ·network addressable storage (NAS),³ý·Çͨ¹ý iSCSI½«NASÉ豸ÉèÖÃΪ±¾µØNFS¾í
ÔÎÄ(the DBA must define a database filegroup that ties an NTFS file system location to a SQL Server database. Note that the filegroup needs to point to a local file system location; filestreams can't live on a remote server or a network addressable storage (NAS) devices unless the NAS device is presented as a local NFS volume via iSCSI)
ÈçÊý¾Ý¿â֮ǰ´Óδ±¸·Ý¹ý,ÔÚÖ´ÐÐÒÔÉÏÓï¾äʱ»áÌáʾÐëÏȱ¸·ÝLOG
Èý.Ä£Äâ²âÊÔ
(1)½¨±í
CREATE TABLE FileStreamTest
(
ID uniqueidentifier ROWGUID NOT NULL UNIQUE DEFAULT NewID(),
FilesName varbinary(max) FILESTREAM NULL
)
FILESTREAM_ON [FileGrp1] --ָʾ´æ´¢µ½ÄÄÒ»¸öÎļþÁ÷
*Èç¹ûÒ»¸ö±íҪʹÓÃÎļþÁ÷,Ôò±ØÐëÓÐÒ»
Ïà¹ØÎĵµ£º
»ùÓÚmsdn ÏêϸѧϰT-SQL (http://msdn.microsoft.com/zh-cn/library/bb510741.aspx)
Aggregate function--Sum() Two Sample from msdn
USE AdventureWorks;
GO
SELECT Color, SUM(ListPrice), SUM(StandardCost)
from Production.Product
WHERE Color IS NOT NULL
AND ListPrice != 0.00 ......
Five basic search conditions are summarized here:
1) Comparison test
2) Range test
3) Set membership test
4) Pattern matching test (Like)
The pattern matching test checks to see whether the data value in a column matches a specified pattern
% mathes any se ......
´´½¨Íâ¼üÔ¼Êø
CREATE TABLE order_sample
(
orderid int PRIMARY KEY,
cust_id int FOREIGN KEY REFERENCES cuts_sample(cust_id) ON DELETE NO CASCADE
)
ON DELETE--ÓÃÓÚ¿ØÖƳ¢ÊÔɾ³ýÍâ¼üÏà¹ØÁªµÄÖ÷±íÖ¸ÏòÐÐʱ²ÉÈ¡µÄ²Ù×÷
-NO ACTION
ɾ³ýÍâ¼üÏà¹ØÁªµÄÖ÷±íÖ¸ÏòÐÐʱ£¬±¨´í
-CASCADE
ɾ³ýÍâ¼üÏà¹ØÁªµÄÖ÷±íÖ¸ÏòÐÐʱ ......
±ÜÃâSQL×¢ÈëµÄ·½·¨ÓÐÁ½ÖÖ£ºÒ»ÊÇËùÓеÄSQLÓï¾ä¶¼´æ·ÅÔÚ´æ´¢¹ý³ÌÖУ¬ÕâÑù²»µ«¿ÉÒÔ±ÜÃâSQL×¢È룬»¹ÄÜÌá¸ßһЩÐÔÄÜ£¬²¢ÇÒ´æ´¢¹ý³Ì¿ÉÒÔÓÉרÃŵÄÊý¾Ý¿â¹ÜÀíÔ±(DBA)±àдºÍ¼¯ÖйÜÀí£¨ÕâÖÖ×ö·¨ÎÒÔÚһЩ¹«Ë¾¼û¹ý£©£¬²»¹ýÕâÖÖ×ö·¨ÓÐʱºòÕë¶ÔÏàͬµÄ¼¸¸ö±íÓв»Í¬Ìõ¼þµÄ²éѯ£¬SQLÓï¾ä¿ÉÄܲ»Í¬£¬ÕâÑù¾Í»á±àд´óÁ¿µÄ´æ´¢¹ý³Ì£¬ËùÒÔÓÐÈËÌá³ ......
¿´µ½±ðÈËÔÚÂÛ̳µÄÌáÎÊ£º
Ò»¸ö±íµÄЧÂÊÎÊÌâ
½ñÌìÅöµ½2Õűí
1ÕÅ ÓÐ×Ö¶Î
±íAÓÐ
jtbh(¼ÒÍ¥±àºÅ) hzxm(»§Ö÷ÐÕÃû) hnbh(»§ÄÚ×î´ó±àºÅ)
1000 ÕÅÈý 03
1001 ÕÔÁù..........................
±í ......