|
-
May 29th, 2008, 03:37 AM
#1
Thread Starter
Fanatic Member
Insert failed
Hi
I have SQL Server 2000 table "FilePerson" that contains a field of type varbinary.I want to insert into that field a value like "C:\xx.xls" but the insert failed.
the following message appeared:
Insert into FilePerson(_ID,_Path) VALUES('4','c:\xxx.xls')
Disallowed implicit conversion from data type varchar to data type varbinary, table 'FilePerson', column '_Path'. Use the CONVERT function to run this query.
Any help
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|