SQL CE by design is prevented to run under ASP applications. You can imagine a single file database is not really a scalable solution. However, there are scenarios that you way want to do that. I know it is silly.
Using SQL Compact Edition Under ASP.NET | Zorched / One Line Fix
11/28/2008
10/31/2008
12/12/2007
11/20/2007
Deleting duplicate records
The other day I wanted to delete multiple records from a table so here is the script that seem to finally work for me:
delete from Record
where RecordID in
( select test_outer.RecordID
from Record as test_outer
where exists( select *
from Record as test_inner
where test_inner.RecordID = test_outer.RecordID
group by RecordID
having count(*) > 1
and min(test_inner.RecordID) <> test_outer.RecordID
)
);
delete from Record
where RecordID in
( select test_outer.RecordID
from Record as test_outer
where exists( select *
from Record as test_inner
where test_inner.RecordID = test_outer.RecordID
group by RecordID
having count(*) > 1
and min(test_inner.RecordID) <> test_outer.RecordID
)
);
8/01/2007
MSDN TV: A Brief Overview of Visual Studio 2005 on 64-Bit
Thinking about installing 64bit XP on my new desktop. Here is the link to a web cast talking about VS 2005 gotchas on XP x64.
MSDN TV: A Brief Overview of Visual Studio 2005 on 64-Bit
MSDN TV: A Brief Overview of Visual Studio 2005 on 64-Bit
Business support forums - Downgrade to XP on Pavilion m8120n
I just bought a nice Quad HP Pavilion which came with the Vista which I wanted to get rid of and downgrade (whcih is in reality an upgrade) to Windows XP. Here are some links after poking around on the Internet:
Downgrade to XP on Pavilion m8120n
Downgrade to XP on Pavilion m8120n
7/31/2007
6/26/2007
Windows Vista Team Blog : Accessible UAC Prompts
How to allow screenreader programs to access Vista's UAC dialog.
Windows Vista Team Blog : Accessible UAC Prompts
Windows Vista Team Blog : Accessible UAC Prompts
5/16/2007
4/12/2007
Exif file format
This site explains file Exif format used to store digicam information within JPEG files.
Exif file format
Exif file format
Subscribe to:
Posts (Atom)
Useful netsh commands
To see blocked ports on your system: netsh interface ipv4 show excludedportrange protocol=tcp For more info visit: https://ardalis.com/atte...