Posted
by Steve Jackson
on Stack Overflow
See other posts from Stack Overflow
or by Steve Jackson
Published on 2010-04-15T10:29:53Z
Indexed on
2010/04/15
10:33 UTC
Read the original article
Hit count: 656
Does anyone know if I can use SQL Server Compact Edition 3.5 on mono?
I'm hoping they are written as managed assemblies and will work ok..does anyone have any experience?
Thanks.
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a table in excel format (2007 but I can save as anything below that, naturally), and I have an SQL Compact Edition 3.5 SP1 Database table with corresponding columns. I simply want to populate the SQLCE table with the data from the excel file. The data consists of strings and integers only.
I…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am creating a simple email client program. I am using MS SqlCe as a storage of emails. The database schema for storing the message is as follows:
StorageId int IDENTITY NOT NULL PRIMARY KEY,
FolderName nvarchar(255) NOT NULL,
MessageId nvarchar(3999) NOT NULL,
MessageDate datetime NOT NULL,
StorageData…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have problem with copying sdf file to WM emulator.
My solution structure
MyApp.DataLayer - there is sdf file
MyApp.WMUI - this is windows mobile winform app
sdf file has set
build action: content
copy to output directory: copy always
But if I deploy app to emulator, that sdf file doesn't…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is there a way to determine the number of connections say a windows application has open with SqlCe?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How do I check if sqlCE is installed on Windows CE (in C#)?
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error:
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure.
How can I do this with detection code written in SQL?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is the query:
INSERT INTO @TempTable
SELECT UserID,
Name,
Address1 =
(SELECT TOP 1 [Address] FROM
(SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID
ORDER BY uo.AddressOrder ASC) q
ORDER BY AddressOrder…
>>> More
