A correlation name must be specified for the bulk

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)

A correlation name must be specified for the bulk

Author

Topic

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2010-05-10 : 16:04:13

From the link below, I ran it but got an error. How to fix it?

A correlation name must be specified for the bulk rowset in the from clause.

-------

http://weblogs.sqlteam.com/peterl/archive/2007/09/26/Insert-binary-data-like-images-into-SQL-Server-without-front-end.aspx

CREATE TABLE myTable(Document varbinary(max))
INSERT INTO myTable(Document)
SELECT * FROM
OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB)

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2010-05-10 : 16:35:39

Once I add alias "rs" at end of last line, it works

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources