SQL Server image datatype and inserts
This is my first time using image datatypes. I am trying to send from VB a
byte array and insert it into a image column using ADO and a sp. I am
getting an error saying that the datatype is incorrect. Here is my sp:
create procedure dp_pt_report_definition
@report_id int output
insert into dbo.pt_report_definition (report_definition)
set @report_id = scope_identity()
Is there anything wrong with the sp? I already tried changing
@report_definition to image and I still get the same error.
I just want to rule out if it is the sp or not.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL