troubleshooting Question

Operand type clash: text is incompatible with int - SQL Express 2005

Avatar of dmonzon
dmonzon asked on
Microsoft SQL Server
4 Comments1 Solution9262 ViewsLast Modified:
I got this error message when try to create a stored procedure in sql express 2005:

Operand type clash: text is incompatible with int

here is the code:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE UpdSurvey

@ID bigint,
@coID int,
@Ccreated datetime,
@Ordered datetime,
@Completed datetime,
@Needed datetime,
@Shipped datetime,
@Text text,
@Amount money,
@County text,
@Cert money,
@Crew money,
@Drafter money,
@Deposit money,
@Lots money,
@Block text,
@Book int,
@Page int

AS
BEGIN

      SET NOCOUNT ON;

            Update Surveys
            set coID=@coID,Ccreated=@Ccreated,Ordered=@Ordered,Completed=@Completed,
                  Needed=@Needed,Shipped=@Shipped,Text=@Text,Amount=@Amount,
                  County=@County,Cert=@Cert,Crew=@Crew,Drafter=@Drafter,
                  Deposit=@Deposit,Lots=@Lots,Block=@Block,Book=@Book,Page=@Page
            where (ID=@ID)

END
GO

Thanks for any advice.
ASKER CERTIFIED SOLUTION
Aneesh
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros