Hi I'm trying to insert the value into the SQL database and i got the error of: Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the nvarchar value 'Y' to a column of data type int. Actually, (the column of data type int that mention in above error) the column in my database field name is nvarchar. But why i can't insert this value into it. I tried this SQL statement "insert into #*$! select * from xxx" . Then i got the error. But when i tried to insert in sql query analyzer like this "insert into xxx(col1,col2) values ('Y' , 'nnn') and it works.If anybody has an idea, please let me know. Thank you.