operand type clash. Text is incompatible with int when attempting to archive table

Question

operand type clash. Text is incompatible with int when attempting to archive table

Welsh Corgi

SSC Guru

Points: 116520
More actions
August 7, 2015 at 1:55 pm

#320317

I'm getting an operand type clash. Text is incompatible with int when attempting to archive table.
I tried finding a solution but I have not found one.
The table has several columns defined as Text.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

Welsh Corgi (8/7/2015)
I'm getting an operand type clash. Text is incompatible with int when attempting to archive table.
I tried finding a solution but I have not found one.
The table has several columns defined as Text.

Do you have something that reproduces this issue? Perhaps following the first link in your signature might help us.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

I'd have to agree, we need a bit more information. Maybe something that helps repro your exact issue.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I will look into it further.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

WayneS SSC Guru Points: 95461 More actions · Answer 4

Without information of exactly what you're attempting, I'm guessing that you're selecting data from one table to insert into a second table (the archive table). Based upon the message "Text is incompatible with int", it sounds like the columns are not matched up properly and a column with a text data type is being inserted into an integer column.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Sean Lange SSC Guru Points: 286609 More actions · Answer 5

For what it is worth, the text datatype has been deprecated since sql server 2005 in favor of varchar(max). If at all possible you should update your tables and stop using text. It is a serious pain to deal with since you have to constantly cast/convert it to another datatype just to use it in a join or where predicate.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 6

Sean Lange (8/7/2015)
For what it is worth, the text datatype has been deprecated since sql server 2005 in favor of varchar(max). If at all possible you should update your tables and stop using text. It is a serious pain to deal with since you have to constantly cast/convert it to another datatype just to use it in a join or where predicate.

Too bad MS keeps pushing it with their databases (dynamix)