does it have to do with the message error
UPDATE dbo.tLongTxt
SET dbo.tLongTxt.tLongTxt = '<EntityDescription>' + dbo.tLongTxt.tLongTxt
+ '</EntityDescription>'
FROM dbo.rTable INNER JOIN dbo.tLongTxt
ON dbo.rTable.K = dbo.tLongTxt.tSpecK
WHERE (dbo.rTable.zStatus = 1) AND (dbo.rTable.zTransNo = 0) AND
(dbo.tLongTxt.tSpecConc = 22500) AND
(dbo.tLongTxt.zStatus = 1 OR dbo.tLongTxt.zStatus IS NULL) AND
(dbo.tLongTxt.zTransNo = 0 OR dbo.tLongTxt.zTransNo IS NULL)
AND (
dbo.tLongTxt.tLongTxt not like '%<%' AND dbo.tLongTxt.tLongTxt not like
'%>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityBusinessPurpose>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityBusinessPurpose>%' AND
dbo.tLongTxt.tLongTxt not like '%<DataArchitectureFrameworkParent>%' AND
dbo.tLongTxt.tLongTxt not like '%</DataArchitectureFrameworkParent>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityAliasName>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityAliasName>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityTransformationNotes>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityTransformationNotes>%' AND
dbo.tLongTxt.tLongTxt not like '%<EDWLayerName>%' AND dbo.tLongTxt.tLongTxt
not like '%</EDWLayerName>%' AND
dbo.tLongTxt.tLongTxt not like '%<MappingSource>%' AND dbo.tLongTxt.tLongTxt
not like '%</MappingSource>%' AND
dbo.tLongTxt.tLongTxt not like '%<Entity''s Subject Area Based On IBF
(Req)>%' AND dbo.tLongTxt.tLongTxt not like '%</Entity''s Subject Area Based
On IBF (Req)>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityStandardAbbreviatedName>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityStandardAbbreviatedName>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityDefinitionReuseIndicator>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityDefinitionReuseIndicator>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityRecordofOrigin>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityRecordofOrigin>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityRecordofReference>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityRecordofReference>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateName>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateName>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%<EntityBusinessRuleDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%</EntityBusinessRuleDescription>%' AND
dbo.tLongTxt.tLongTxt not like '%<SelectionCriteria>%' AND
dbo.tLongTxt.tLongTxt not like '%</SelectionCriteria>%')
this is the error message I receive
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals add, type equals text.This is a multi-part message in MIME format.
--=_NextPart_000_000D_01C69555.CA449990
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
From Books-on-Line (BOL), which by the way is a great resource to have =for reference (note the highlighted in Red section.)
-- Arnie Rowland, YACE* "To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
+ (String Concatenation)
An operator in a string expression that concatenates two or more =character or binary strings, columns, or a combination of strings and =column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any valid Microsoft=AE SQL ServerT expression of any of the data =types in the character and binary data type category, except the image, =ntext, or text data types.
"Fernand St-Georges" <Fernand St-Georges@.videotron.ca> wrote in message =news:3ejmg.27141$1f2.433450@.weber.videotron.net...
> dbo.tLongTxt.tLongTxt is a Ntext 16
> > does it have to do with the message error
> > > > UPDATE dbo.tLongTxt
> SET dbo.tLongTxt.tLongTxt =3D '<EntityDescription>' + =dbo.tLongTxt.tLongTxt > + '</EntityDescription>'
> FROM dbo.rTable INNER JOIN dbo.tLongTxt
> ON dbo.rTable.K =3D dbo.tLongTxt.tSpecK
> > WHERE (dbo.rTable.zStatus =3D 1) AND (dbo.rTable.zTransNo =3D 0) =AND > (dbo.tLongTxt.tSpecConc =3D 22500) AND
> (dbo.tLongTxt.zStatus =3D 1 OR dbo.tLongTxt.zStatus IS NULL) =AND
> (dbo.tLongTxt.zTransNo =3D 0 OR dbo.tLongTxt.zTransNo IS =NULL)
> AND (
> dbo.tLongTxt.tLongTxt not like '%<%' AND dbo.tLongTxt.tLongTxt not =like > '%>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityDescription>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessPurpose>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityBusinessPurpose>%' AND
> dbo.tLongTxt.tLongTxt not like '%<DataArchitectureFrameworkParent>%' =AND > dbo.tLongTxt.tLongTxt not like '%</DataArchitectureFrameworkParent>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityAliasName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityAliasName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityTransformationNotes>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityTransformationNotes>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EDWLayerName>%' AND =dbo.tLongTxt.tLongTxt > not like '%</EDWLayerName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<MappingSource>%' AND =dbo.tLongTxt.tLongTxt > not like '%</MappingSource>%' AND
> dbo.tLongTxt.tLongTxt not like '%<Entity''s Subject Area Based On IBF > (Req)>%' AND dbo.tLongTxt.tLongTxt not like '%</Entity''s Subject Area =Based > On IBF (Req)>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityStandardAbbreviatedName>%' AND =
> dbo.tLongTxt.tLongTxt not like '%</EntityStandardAbbreviatedName>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityDefinitionReuseIndicator>%' =AND > dbo.tLongTxt.tLongTxt not like '%</EntityDefinitionReuseIndicator>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofOrigin>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofOrigin>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofReference>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofReference>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateDescription>%' =AND > dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateDescription>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessRuleDescription>%' AND =
> dbo.tLongTxt.tLongTxt not like '%</EntityBusinessRuleDescription>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<SelectionCriteria>%' AND > dbo.tLongTxt.tLongTxt not like '%</SelectionCriteria>%')
> > this is the error message I receive
> > Server: Msg 403, Level 16, State 1, Line 1
> Invalid operator for data type. Operator equals add, type equals text.
> > >
--=_NextPart_000_000D_01C69555.CA449990
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
From Books-on-Line (BOL), which by the =way is a great resource to have for reference (note the highlighted in =Red section.)
-- Arnie Rowland, YACE* "To be =successful, your heart must accompany your knowledge."
*Yet Another Certification =Exam
+ (String =Concatenation)
An operator in a string expression that =concatenates two or more character or binary strings, columns, or a combination of =strings and column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any =valid Microsoft=AE SQL Server=99 expression of any of the data types in the character and =binary data type category, except the image, ntext, or text data types. ="Fernand St-Georges"
--=_NextPart_000_000D_01C69555.CA449990--|||This is a multi-part message in MIME format.
--=_NextPart_000_0016_01C69581.AB5DAA40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Well thanks very much. This is absolutely true. I had'nt found it. =Great. But it does not solve my problem, except if I change the data =type of that column.
"Arnie Rowland" <arnie@.1568.com> a =E9crit dans le message de news: =e8vx3BZlGHA.3460@.TK2MSFTNGP02.phx.gbl...
From Books-on-Line (BOL), which by the way is a great resource to have =for reference (note the highlighted in Red section.)
-- Arnie Rowland, YACE* "To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
+ (String Concatenation)
An operator in a string expression that concatenates two or more =character or binary strings, columns, or a combination of strings and =column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any valid Microsoft=AE SQL ServerT expression of any of the data =types in the character and binary data type category, except the image, =ntext, or text data types.
"Fernand St-Georges" <Fernand St-Georges@.videotron.ca> wrote in =message news:3ejmg.27141$1f2.433450@.weber.videotron.net...
> dbo.tLongTxt.tLongTxt is a Ntext 16
> > does it have to do with the message error
> > > > UPDATE dbo.tLongTxt
> SET dbo.tLongTxt.tLongTxt =3D '<EntityDescription>' + =dbo.tLongTxt.tLongTxt > + '</EntityDescription>'
> FROM dbo.rTable INNER JOIN dbo.tLongTxt
> ON dbo.rTable.K =3D dbo.tLongTxt.tSpecK
> > WHERE (dbo.rTable.zStatus =3D 1) AND (dbo.rTable.zTransNo =3D 0) =AND > (dbo.tLongTxt.tSpecConc =3D 22500) AND
> (dbo.tLongTxt.zStatus =3D 1 OR dbo.tLongTxt.zStatus IS =NULL) AND
> (dbo.tLongTxt.zTransNo =3D 0 OR dbo.tLongTxt.zTransNo IS =NULL)
> AND (
> dbo.tLongTxt.tLongTxt not like '%<%' AND dbo.tLongTxt.tLongTxt not =like > '%>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityDescription>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessPurpose>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityBusinessPurpose>%' AND
> dbo.tLongTxt.tLongTxt not like '%<DataArchitectureFrameworkParent>%' =AND > dbo.tLongTxt.tLongTxt not like ='%</DataArchitectureFrameworkParent>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityAliasName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityAliasName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityTransformationNotes>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityTransformationNotes>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EDWLayerName>%' AND =dbo.tLongTxt.tLongTxt > not like '%</EDWLayerName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<MappingSource>%' AND =dbo.tLongTxt.tLongTxt > not like '%</MappingSource>%' AND
> dbo.tLongTxt.tLongTxt not like '%<Entity''s Subject Area Based On =IBF > (Req)>%' AND dbo.tLongTxt.tLongTxt not like '%</Entity''s Subject =Area Based > On IBF (Req)>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityStandardAbbreviatedName>%' =AND > dbo.tLongTxt.tLongTxt not like '%</EntityStandardAbbreviatedName>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityDefinitionReuseIndicator>%' =AND > dbo.tLongTxt.tLongTxt not like '%</EntityDefinitionReuseIndicator>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofOrigin>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofOrigin>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofReference>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofReference>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateDescription>%' =AND > dbo.tLongTxt.tLongTxt not like ='%</EntityLifecycleStateDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessRuleDescription>%' =AND > dbo.tLongTxt.tLongTxt not like '%</EntityBusinessRuleDescription>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<SelectionCriteria>%' AND > dbo.tLongTxt.tLongTxt not like '%</SelectionCriteria>%')
> > this is the error message I receive
> > Server: Msg 403, Level 16, State 1, Line 1
> Invalid operator for data type. Operator equals add, type equals =text.
> > >
--=_NextPart_000_0016_01C69581.AB5DAA40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Well thanks very much. This is =absolutely true. I had'nt found it. Great. But it does not solve =my problem, except if I change the data type of that column.
"Arnie Rowland" a =E9crit dans =le message de news: e8vx3BZlGHA.3460@.TK=2MSFTNGP02.phx.gbl...
From Books-on-Line (BOL), which by =the way is a great resource to have for reference (note the highlighted =in Red section.)
-- Arnie Rowland, YACE* "To =be successful, your heart must accompany your knowledge."
*Yet Another Certification =Exam
+ (String Concatenation)
An operator in a string expression that = concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any =valid Microsoft=AE SQL Server=99 expression of any of the data types in the character and =binary data type category, except the image, ntext, or text data types.
"Fernand St-Georges"
--=_NextPart_000_0016_01C69581.AB5DAA40--|||This is a multi-part message in MIME format.
--=_NextPart_000_00AE_01C69580.E018EC00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Perzackly!
And the varchar() datatype is limited to approximately 8000 bytes =(characters). If that works for you, then that is your choice.
Of course, if you were working with SQL 2005, there is the xml =datatype...
-- Arnie Rowland, YACE* "To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Fernand St-Georges" <Fernand St-Georges@.videotron.ca> wrote in =message news:Zcnmg.34751$1f2.530324@.weber.videotron.net...
Well thanks very much. This is absolutely true. I had'nt found it. =Great. But it does not solve my problem, except if I change the data =type of that column.
"Arnie Rowland" <arnie@.1568.com> a =E9crit dans le message de news: =e8vx3BZlGHA.3460@.TK2MSFTNGP02.phx.gbl...
From Books-on-Line (BOL), which by the way is a great resource to =have for reference (note the highlighted in Red section.)
-- Arnie Rowland, YACE* "To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
+ (String Concatenation)
An operator in a string expression that concatenates two or more =character or binary strings, columns, or a combination of strings and =column names into one expression (a string operator).
Syntax
expression + expression
Arguments
expression
Is any valid Microsoft=AE SQL ServerT expression of any of the data =types in the character and binary data type category, except the image, =ntext, or text data types.
"Fernand St-Georges" <Fernand St-Georges@.videotron.ca> wrote in =message news:3ejmg.27141$1f2.433450@.weber.videotron.net...
> dbo.tLongTxt.tLongTxt is a Ntext 16
> > does it have to do with the message error
> > > > UPDATE dbo.tLongTxt
> SET dbo.tLongTxt.tLongTxt =3D '<EntityDescription>' + =dbo.tLongTxt.tLongTxt > + '</EntityDescription>'
> FROM dbo.rTable INNER JOIN dbo.tLongTxt
> ON dbo.rTable.K =3D dbo.tLongTxt.tSpecK
> > WHERE (dbo.rTable.zStatus =3D 1) AND (dbo.rTable.zTransNo =3D =0) AND > (dbo.tLongTxt.tSpecConc =3D 22500) AND
> (dbo.tLongTxt.zStatus =3D 1 OR dbo.tLongTxt.zStatus IS =NULL) AND
> (dbo.tLongTxt.zTransNo =3D 0 OR dbo.tLongTxt.zTransNo IS =NULL)
> AND (
> dbo.tLongTxt.tLongTxt not like '%<%' AND dbo.tLongTxt.tLongTxt not =like > '%>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityDescription>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessPurpose>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityBusinessPurpose>%' AND
> dbo.tLongTxt.tLongTxt not like ='%<DataArchitectureFrameworkParent>%' AND > dbo.tLongTxt.tLongTxt not like ='%</DataArchitectureFrameworkParent>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityAliasName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityAliasName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityTransformationNotes>%' AND =
> dbo.tLongTxt.tLongTxt not like '%</EntityTransformationNotes>%' =AND
> dbo.tLongTxt.tLongTxt not like '%<EDWLayerName>%' AND =dbo.tLongTxt.tLongTxt > not like '%</EDWLayerName>%' AND
> dbo.tLongTxt.tLongTxt not like '%<MappingSource>%' AND =dbo.tLongTxt.tLongTxt > not like '%</MappingSource>%' AND
> dbo.tLongTxt.tLongTxt not like '%<Entity''s Subject Area Based On =IBF > (Req)>%' AND dbo.tLongTxt.tLongTxt not like '%</Entity''s Subject =Area Based > On IBF (Req)>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityStandardAbbreviatedName>%' =AND > dbo.tLongTxt.tLongTxt not like ='%</EntityStandardAbbreviatedName>%' AND
> dbo.tLongTxt.tLongTxt not like ='%<EntityDefinitionReuseIndicator>%' AND > dbo.tLongTxt.tLongTxt not like ='%</EntityDefinitionReuseIndicator>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofOrigin>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofOrigin>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityRecordofReference>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityRecordofReference>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityLifecycleStateName>%' AND > dbo.tLongTxt.tLongTxt not like '%</EntityLifecycleStateName>%' AND
> dbo.tLongTxt.tLongTxt not like ='%<EntityLifecycleStateDescription>%' AND > dbo.tLongTxt.tLongTxt not like ='%</EntityLifecycleStateDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<EntityBusinessRuleDescription>%' =AND > dbo.tLongTxt.tLongTxt not like ='%</EntityBusinessRuleDescription>%' AND
> dbo.tLongTxt.tLongTxt not like '%<SelectionCriteria>%' AND > dbo.tLongTxt.tLongTxt not like '%</SelectionCriteria>%')
> > this is the error message I receive
> > Server: Msg 403, Level 16, State 1, Line 1
> Invalid operator for data type. Operator equals add, type equals =text.
> > >
--=_NextPart_000_00AE_01C69580.E018EC00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Perzackly!
And the varchar() datatype is limited =to approximately 8000 bytes (characters). If that works for you, then that =is your choice.
Of course, if you were working with SQL =2005, there is the xml datatype...
-- Arnie Rowland, YACE* "To be successful, your heart =must accompany your knowledge."
*Yet Another Certification Exam
"Fernand St-Georges"
Well thanks very much. This is =absolutely true. I had'nt found it. Great. But it does not =solve my problem, except if I change the data type of that column.
"Arnie Rowland" a =E9crit dans =le message de news: e8vx3BZlGHA.3460@.TK=2MSFTNGP02.phx.gbl...
From Books-on-Line (BOL), which by =the way is a great resource to have for reference (note the highlighted =in Red section.)
-- Arnie Rowland, YACE* "To =be successful, your heart must accompany your knowledge."
*Yet Another Certification =Exam
+ (String Concatenation)
An operator in a string expression =that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression (a =string operator).
Syntax
expression + expression
Arguments
expression
Is any =valid Microsoft=AE SQL Server=99 expression of any of the data types in =the character and binary data type category, except the image, ntext, or text data =types.
"Fernand St-Georges" =
--=_NextPart_000_00AE_01C69580.E018EC00--
No comments:
Post a Comment