Help : Disallowed implicit conversion from data type ntext to data type varchar,.

Hi all, 

       i have feedback table with column comments1(varchar) & comments(ntext) ..i tried to copy the content from column Comments to another comments1 column,It shows the follwing error..

My Query is ,

                 "   update feedback set comments1=comments    "

Error :

Disallowed implicit conversion from data type ntext to data type varchar, table 'Test.dbo.feedback', column 'comments1'.

Use the CONVERT function to run this query.

0
suresh
8/29/2008 4:17:13 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

2 Replies
1824 Views

Similar Articles

[PageSpeed] 16

update feedback set comments1=cast(varchar(yourLength of the varchar),comments)
Don't forget to click "Mark as Answer" on the post that helped you.
0
tompy_nation
8/29/2008 9:07:37 AM

Yeah..Its working now..Thanks for ur kind help...

0
suresh
8/30/2008 6:51:04 AM
Reply:

Web resources about - Help : Disallowed implicit conversion from data type ntext to data type varchar,. - asp.net.sql-datasource


Disallowed try costs Sharks dearly in loss to Lions
Disallowed try costs Sharks dearly in loss to Lions

Porto hold Basel amid controversy over disallowed goal
... to hold FC Basel to a 1-1 draw in the Champions League on Wednesday amid controversy over a goal for the Portuguese visitors which was disallowed ...

Video: Sydney FC striker Mark Janko has spectacular goal disallowed against Newcastle
MARK Janko can already lay claim to one goal of the season candidate.


Right wing party threatens to sue Town of Vincent over disallowed BBQ
The leader of a controversial right-wing political group is planning to sue Vincent council after it refused to allow them to hold a BBQ in the ...

Paul Roos bemused by disallowed goal
Melbourne coach Paul Roos was left perplexed after a Bernie Vince goal was disallowed during the third quarter of the Demons' loss to Collingwood ...

Disallowed tries hurt Force in rugby loss
The Western Force lose a sixth straight Super Rugby match, having two tries disallowed in a 15-9 loss to the Sharks in Durban.

Greens push for code of conduct for asylum seekers to be disallowed
The Greens are fighting to remove a special behaviour code that asylum seekers who live in the community must abide by, saying it is degrading ...

Harvick, Vickers' times disallowed
DAYTONA BEACH, Fla. (AP) NASCAR has disallowed Daytona 500 qualifying runs by Stewart-Haas Racing teammates Kevin Harvick and Brian Vickers. ...

Resources last updated: 3/30/2016 7:18:51 PM