To save a file in a SQL 2005
-
Can anyone help me to save a file in SQL Server 2005. :confused: My application will be used by the user to attach the approval mails (Either html or word or any files). How can i save and retrive from SQL Server 2005? :omg: Anticipating for your replies... Regards, Saranya Balasubramanian
-
Can anyone help me to save a file in SQL Server 2005. :confused: My application will be used by the user to attach the approval mails (Either html or word or any files). How can i save and retrive from SQL Server 2005? :omg: Anticipating for your replies... Regards, Saranya Balasubramanian
Use a
varbinary(max)column type. Use that type in parameters when you add data to the database. When you select it the result will by a byte array in your .NET application.
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
Use a
varbinary(max)column type. Use that type in parameters when you add data to the database. When you select it the result will by a byte array in your .NET application.
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
This will help you: http://support.microsoft.com/kb/309158[^]