Category "sql-server-ce"

Why does Application close after executing a SQL Server CE update command?

My application closes after I execute an update command via oledb connection I also use DataAdapter but it closes without any error too, I can execute insert, d

Insert into one column by selecting another column in other table but how fill the second column

i have a table which has two columns i'd fill one of the columns by selecting other table column data but how can i fill the next column cause i can't use VALUE

Removing leading zeros from a string in SQL Server 2008 R2

I have a string representing a batch number of goods, for example "0000AZA001B". I only need the "AZA001B" part. How can I achieve that in SQL Compact?