Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hello every bodyI use sqlce 3.5 i want convert integer column in select statementcode
SELECT id, type_task,date_year ,cast(date_month AS nchar(3)) , date_day, state, noteFROM task_tb AS task_tb_1WHERE (id =1)
errorData conversion failed. [ OLE DB status value (if known) = 2 ]please help me.............http://aman-services.netfor office???? ???? ???????
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts
Posted - 2013-03-05 : 11:45:28
do you mean you're using SQL server compact edition? If so provide sample data for the projecting columns id, type_task,date_year ,date_month, date_day, state, noteAnd what is the datatype for Date_Month field in your table?CheersMIK