Hello, I am writing a sproc and am getting this error: Any ideas? Thanks!!
Msg 402, Level 16, State 1, Procedure InsertUserPreferences, Line 18
The data types text and text are incompatible in the equal to operator.
-
create procedure InsertUserPreferences
(
@.PublisherServer text
)as
begin
if exists(Select Preference_StringList from USER_Preference where Preference_StringList = @.PublisherServer)
begin
--UPDATE
exec dbo.uProc_USER_Preference
end
If you are using 2005, change to using varchar(max) and this will work. You cannot use a text value in a equality comparison
create table test
(
textValue text
)
go
select *
from test
where textValue = ''
go
You could use a cast to only get the first 8000 characters:
select *
from test
where cast(textValue as varchar(8000)) = ''
go
If that will work for you.
Is that your entire proc? How des the update work? If it exists, do you just update the modify date?
|||I will give it a shot and get back with you. Thank you for your help!!!|||Dude that worked!! Thanks man!!!!
No comments:
Post a Comment