By Sanda Borlea on November 12, 2009
As many other times, I came across this issue having to begin at the wrong end, i.e. having the result and in need of the problem. The samples and recommended procedures offer – as in most cases – only the simplest examples. The workaround is often tedious and in absence of feedback uncertain.
Posted in .NET | Tagged .net, c#, linq, sql
By Armand Niculescu on June 5, 2007
I wasted several hours not realizing that MS Access 2007 doesn’t display NULLs in a table.
It all started when we’ve been asked to patch up an old project whose authors have gone missing. The application was ASP.NET 1.1 with an Access db and no source code and no documentation. Oh, the joy!
Posted in .NET | Tagged access, sql
By Armand Niculescu on January 18, 2007
MS SQL has the ability to retrieve data as XML by using the “FOR XML [RAW | AUTO [ELEMENTS] | EXPLICIT]” parameters, which is very useful especially when used in a web service that communicates with a Flash / Flex client as the results don’t have to be converted, but just output to the client.
Your [...]
Posted in .NET | Tagged .net, c#, sql, xml
By Armand Niculescu on October 18, 2006
Here’s a neat thing to remember if you’re using MSSQL:
To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
Posted in .NET | Tagged mssql, sql, tutorial
By Armand Niculescu on April 7, 2006
I started to work on a pet project for tracking deleted/pending domains (myDomainTracker) and after starting development I was facing a big problem: How to do the data validation directly from MySQL ?
Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my application [...]
Posted in PHP/MySQL | Tagged mysql, php, sql, triggers
By Sanda Borlea on April 3, 2006
I just need to post this as all examples I found were explaining how to use transaction in a <cftry> and <cfcatch> block with only one query.
But if you have a query file to include in your Fusebox application, that does multiple queries and only one needed to be in a transaction block, then the [...]
Posted in ColdFusion | Tagged ColdFusion, sql, tutorial
By Sanda Borlea on December 23, 2005
This is not really a post, just a small note on an item that can make you lose precious time hunting for…
To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this:
select extract(year from sysdate)
from dual
This gets the current [...]
Posted in Oracle | Tagged Oracle, pl/sql, sql