Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Problem

Author

Topic

sabra
Starting Member

25 Posts

Posted - 2010-06-06 : 18:47:29

How I get or put picutres in MS Server SQL 2005

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-06-06 : 23:10:38

It's not good practice to store images in any database.
You should store images in folder and the path of it in a table.

Still for some reasons you want to store images in sql server then have a look at below link. This will be of some help to you.

http://www.sqlteam.com/article/images-and-sql-server
http://www.codeproject.com/KB/database/Store_images_in_SQL_Serve.aspx

Regards,
Bohra

I am here to learn from Masters and help new bees in learning.

sabra
Starting Member

25 Posts

Posted - 2010-06-07 : 02:13:43

Dear Bohra
It's great that youhelp me.
Best regards
Branko

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-06-07 : 02:56:50

Glad to help

sabra
Starting Member

25 Posts

Posted - 2010-06-18 : 09:49:52

Hi My friends Bohra!
Now I have new problm:
New error!
I add one line in:
CREATE TABLE BLOBTest
(
BLOBID int IDENTITY NOT NULL,
BLOBData varbinary(max) NOT NULL
BLOBI int NULL
)
IT's necessary to INSERT numer INTO BLOBI and have new row.

INSERT INTO BLOBTest
VALUES (,,’3’)
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'BLOBTest' in the database.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ','.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources