sql query
Tue, 13 May 2008 02:43:02 -0700
I want to find missing data from a table. For example there are 1,2,5,7 in a
table. Here max is 7 and min is 1. Now missing data within max and min are
3,4,6. So how can find missing data. ...
|
insert statement using the function or procedure.
Mon, 12 May 2008 06:04:01 -0700
plz give a valable suggestion to the write query ...
|
SQL Compact Edition does not recognize parameter
Fri, 9 May 2008 05:36:23 -0700 (PDT)
Hi all
I use the following example for the description:
"UPDATE Table SET Column1=@Value1"
In code I create a parameter and add it to a list which is passed to
the execution:
_dbHelper.CreateParameter("@Value1", SqlDbType.NVarChar, 50, "some
text value")
Of course the original table query has more colum ...
|
getting many errors
Thu, 8 May 2008 19:01:14 +0530
Hello,
I may not be right by posting this post in this newsgroup so for that i
really appologize.
I can figure it out that this kind of errors have already been discussed
before so many times but lets solve this error one more time. I've done lots
of search on internet at many search engines but am not a ...
|
Regarding my network based application
Tue, 6 May 2008 05:44:03 -0700
Hi i made an application which is working on the network. But i want to make
run this application by making a shortcut of this application i don't want to
install again and again all all the pc can u please tell me how this possible.
Thanks
--
Atul ...
|
SQL CE 3.5 on ARM926T OMAP730 processor?
Tue, 6 May 2008 13:45:59 +1000
We've got a few no name PDAs which we're having problems with.
When I go to install the SQL CE 3.5, I get "Installation of <whatever the
name is>.cab was unsuccessful. The installation file is not intended for
this device."
I'd send you a screenshot, but the remote display program has the same error
whe ...
|
RDA Connecting issue in 2003 server
Mon, 5 May 2008 06:12:00 -0700
Mu OS is windows 2003 server with service pack 2 and database is SQL server
2000 with service pack 4. My issue is while pulling the data using RDA method
it is going to catch exception; but the error is not displaying(Blank message
box is coming)
any one can help me please ..?
...
|
|
|
ArgumentOutOfRangeException when using DataTable.WriteXML
Thu, 01 May 2008 15:18:42 -0500
Hi, All!
I'm having a strange issue with DataTable.WriteXML. I've created a database with
19 tables using an XML file that I read and process manually. Here is an excerpt
from the table in question:
<Loads PrimaryKey="OrderNumber,Segment">
<Field Name="OrderNumber" Type="nvarchar" Size="30" />
...
|
Master/Detail Navigator issues
Thu, 1 May 2008 11:47:06 -0700
I have spent many hours on this and have not found a way to have a
Master/Detail or Parent/Child table work with the child having the correct
identity value passed. I built two tests projects one with SQLCE and the
other with SQL Express 2005. The SQL Express 2005 worked without a flaw.
The same code did ...
|
3.1 to 3.5 Upgrade
Wed, 30 Apr 2008 13:36:06 -0700
Is it possible to upgrade a SQL CE 3.1 database to 3.5 in Windows CE 5.0? I
see that SqlCeEngine has a method called Upgrade, but every time I call it it
throws an exception with this error message:
The specified module could not be found
I was thinking this would be because it can't find some file(s), bu ...
|