Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.
2009-01-16
4,334 reads
2008-11-06 (first published: 2008-09-12)
1,057 reads
SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.
2007-10-24
12,839 reads
2007-12-12 (first published: 2007-10-12)
3,566 reads
SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008 to the community for preview.
2007-09-25
7,293 reads
SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.
2009-02-13 (first published: 2007-09-12)
34,346 reads
SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. This article will highlight some of the new features and benefits found in SQL Server 2008.
2007-08-15
7,510 reads
2007-08-02
1,850 reads
Yesterday at it's Worldwide Partner Conference, Microsoft announced the launch date for SQL Server 2008 along with Windows 2008 and Visual Studio 2008.
2007-07-11
15,716 reads
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
2007-07-05
3,417 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers