sql-server-ce

相关标签：javascript jquery android 多少钱 iPhone

SQL Server CE query having no effect?

I\'m attempting to insert rows into a SQL Server CE database, and it\'s returning that 1 row is affected, there\'s no exception, and no syntax error in the query as far as I can see - but it\'s having[详细]

2023-03-31 14:10 分类：问答
SQL Server CE joining two tables

I have 2 tables, tb1 is users and tb2 is stats. I have multiple stats for each user marked with a timestamp[详细]

2023-03-31 12:24 分类：问答
Connecting to Sql Server CE via ODBC Connection

I have an app tha开发者_如何转开发t uses the OdbcConnection classes to connect to Oracle and Sql Server. Works great.But I\'m writng some tests and want to connect to Sql Serve CE, which is built into[详细]

2023-03-31 06:43 分类：问答
Incorrect Duplicate insert problem with SQL Server CE 3.5

I am not able to insert data into my table anymore! Here\'s my table design. 开发者_JAVA技巧 intId is the Primary Key, there\'s no explicit unique constraint defined on it, has identity increment set[详细]

2023-03-31 03:20 分类：问答
Embedding SQL Server CE database into a C# application

I\'m developing a program which uses SQL Server Compact Edition for processing data. We all know that this creates a .sdf file in output (SQL Server CE database File).[详细]

2023-03-31 00:45 分类：问答
SQLCE: How to join tables from different SQLCE databases programmatically in C#?

I keep tables on different .sdf files because it\'s easy to manage them, ie; back up only changed db file, etc, plus in future db size might bigger and there is -4GB limit-[详细]

2023-03-30 13:55 分类：问答
How to synchronise two Sql Compact edition databases via WCF (n-tier)

I have a situation that requires two SQL Compact edition databases to synchronise with each other using Microsoft Sync Framework in a C# 4 Winforms app, but I am struggling to find a way to get this t[详细]

2023-03-30 08:23 分类：问答
Validate database file schema before open

I have an application that saves and opens data (which is saved as SQL CE database file). Every time the project gets saved, a new .sdf file is generated with table structure defined by my code and I[详细]

2023-03-29 23:43 分类：问答
MSSQLCE: Subquery returns parsing error

I\'ve added an ID column (personID) into a table (personList) instead of another field: personPin Now I need to fill empty foreign key field (seenPersonID) of another table (personAttendances)[详细]

2023-03-29 21:39 分类：问答
Building a cache table, database helpers

I have a few tables of possible combinations for item names, like base name, prefixes and suffixes - however it isnt very good to search directly in these tables as I have to generate the combinations[详细]

2023-03-29 01:54 分类：问答