Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SELECT INTO FILESTREAM Expand / Collapse
Author
Message
Posted Wednesday, May 29, 2013 11:33 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:33 AM
Points: 673, Visits: 1,554
Very Interesting, Steve. Thank you for posting.

I have read about filestream but never tried it practically. For testing this code, which came with good amount of learning and couple of hours of BOL exploring , finally I was able to create the tables with the FILESTREAM attribute which only can be achieved by script creation and not using with GUI for table design. Also I didn't know this needs a default filestream filegroup and then one file with the filestream type needs to be created before creating any columns with the filestream attribute.



ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1457883
Posted Tuesday, June 04, 2013 3:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 09, 2013 4:28 AM
Points: 20, Visits: 64
Good question ..though my answer was wrong .. nice to know about filestream attribute
Post #1459608
Posted Friday, June 07, 2013 1:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:04 AM
Points: 3,517, Visits: 2,606
Though I didn't knew but guessed it correct.
Post #1460987
Posted Tuesday, July 09, 2013 3:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:07 AM
Points: 1,144, Visits: 298
a bit of luck was not really sure !
Post #1471491
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse