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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 844, Visits: 1,910
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
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1457883
Posted Tuesday, June 4, 2013 3:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 9, 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 7, 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: Monday, July 21, 2014 6:24 AM
Points: 3,537, Visits: 2,647
Though I didn't knew but guessed it correct.
Post #1460987
Posted Tuesday, July 9, 2013 3:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:24 AM
Points: 1,144, Visits: 299
a bit of luck was not really sure !
Post #1471491
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse