<div>
You are trying to insert a varchar value into an integer column 
</div>


<div>
<br />
no i am trying to put an integer value in a column which has type int
</div>


<div>
Can u try it again, make sure that you selects the exact integer column, and try to insert an integer value, I dont think otherwise SQL Thows such an errro 
</div>


<div>
<br />
no i am sure i am inserting the values in the right column.by the way has it got to do with my table collation which is SQL_Latin1_General_CP1_CI_<wbr />AI
</div>


<div>
are you trying to insert multiple integers with something delimited like a SPACE or a LIST type of things...if yes then it will not get updated...can you give us the value taht you are trying to insert ?
</div>


<div>
<br />
there is a column with type int and i am trying to insert 955 in it.
</div>


<div>
sorry for haressing you with questions...are you typing 995 ? or copy &nbsp;Pasting it ?
</div>


<div>
<br />
thanks for your comment<br />
i am typing.it is very funny that i am facing this problem.
</div>


<div>
Can you provide the screenshot of your error screen.
</div>


<div>
<br />
how can i display a sceenshot in EE
</div>


<div>
you can follow either of ther two things, <br />
you can upload those picture in webshots and paste the link here <br />
Another option is, if your organisation permits, <br />
install the LogMeIn Free &nbsp;tool form LogmeIn.Com , thru that you can remotly share your desktop . 
</div>


<div>
<br />
CHECK THIS URL I CREATED IN WEBSHOT.<br />
<br />
<a href="http://community.webshots.com/album/560895778mKSbTD" rel="ugc">http://community.webshots.com/album/560895778mKSbTD</a>
</div>


<div>
I didi't find the error you describe above, all i can see is an optimistic concurrency control error. <br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hello there,<br />
<br />
I am using sql server 2005 and when i try to edit the data in the table i get error<br />
saying conversion failed when converting the varchar value 'List' &nbsp;to data type 'int'. but when i write query to UPDATE it works.but not directly in the studio.<br />
what is the reason.<br />
please help<br />
<br />
cheers<br />
zolf
</div>
</div>


Hello there,

I am using sql server 2005 and when i try to edit the data in the table i get error
saying conversion failed when converting the varchar value 'List'  to data type 'int'. but when i write query to UPDATE it works.but not directly in the studio.
what is the reason.
please help

cheers
zolf

You are trying to insert a varchar value into an integer column 


no i am trying to put an integer value in a column which has type int

Can u try it again, make sure that you selects the exact integer column, and try to insert an integer value, I dont think otherwise SQL Thows such an errro 


no i am sure i am inserting the values in the right column.by the way has it got to do with my table collation which is SQL_Latin1_General_CP1_CI_AI

are you trying to insert multiple integers with something delimited like a SPACE or a LIST type of things...if yes then it will not get updated...can you give us the value taht you are trying to insert ?


there is a column with type int and i am trying to insert 955 in it.

sorry for haressing you with questions...are you typing 995 ? or copy  Pasting it ?


thanks for your comment
i am typing.it is very funny that i am facing this problem.

Can you provide the screenshot of your error screen.

you can follow either of ther two things, 
you can upload those picture in webshots and paste the link here 
Another option is, if your organisation permits, 
install the LogMeIn Free  tool form LogmeIn.Com , thru that you can remotly share your desktop . 


CHECK THIS URL I CREATED IN WEBSHOT.

http://community.webshots.com/album/560895778mKSbTD

I didi&#39;t find the error you describe above, all i can see is an optimistic concurrency control error. 



Cannot edit data directly in table

Hello there,

I am using sql server 2005 and when i try to edit the data in the table i get error
saying conversion failed when converting the varchar value &#39;List&#39;  to data type &#39;int&#39;. but when i write query to UPDATE it works.but not directly in the studio.
what is the reason.
please help

cheers
zolf

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.