RichNetApps
Internet Applications - Flash, Flex, Silverlight, JavaFX
  • Home
  • About
  • Contact
  • All Downloads
  • Free Tools
    • Mini FLV Player
    • Mini MP3 Player
    • Flash Slideshow
    • Flash Pie Chart
  • Design and Photography
  • Services
  • Games
  • .NET
  • ColdFusion
  • CSS/Ajax
  • Flash
  • News
  • Oracle
  • PHP/MySQL
  • Reviews
  • Subscribe
Browse: Home / sql

sql

LINQ Demystified : Using LINQ on Existing Data Model

LINQ Demystified : Using LINQ on Existing Data Model

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 | Leave a response

Access 2007 and NULLs

Access 2007 and NULLs

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 | 1 Response

Converting rootless XmlReader to XmlDocument in .NET

Converting rootless XmlReader to XmlDocument in .NET

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. [...]

Posted in .NET | Tagged .net, c#, sql, xml | 7 Responses

Forgot or lost SQL Server “sa” password

Forgot or lost SQL Server “sa” password

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 | 4 Responses

A very fast introduction on Mysql triggers

A very fast introduction on Mysql triggers

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 [...]

Posted in PHP/MySQL | Tagged mysql, php, sql, triggers | 3 Responses

Multiple queries and one transaction

Multiple queries and one transaction

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 [...]

Posted in ColdFusion | Tagged ColdFusion, sql, tutorial

Get the Current Date for PL/SQL

Get the Current Date for PL/SQL

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 [...]

Posted in Oracle | Tagged Oracle, pl/sql, sql | 3 Responses

Latest Articles

  • Should your CMS be allowed to do that?
  • A Simple Twitter Search Parser with PHP
  • I love Tagul
  • Adobe CS5 just around the corner
  • The (sad) state of web fonts embedding
  • WCF-LINQ Exception : Cycled Object Reference
  • flashCHESS III in Google Chrome OS
  • LINQ Demystified : Using LINQ on Existing Data Model
  • Add Custom VS Snippets
  • VirtueMart quick tip: show brand/manufacturer logo in product details

Facebook

Twitter

Follow us on TwitterFollow us on Twitter

Tag Cloud

.net actionscript adobe ajax c# chess code ColdFusion component css download effects filters flash flex flv free fusebox gallery google html iis issues javascript lightroom linq microsoft motion mssql mysql Oracle performance php piechart pl/sql raw reporting services smtp source sql store triggers tutorial wordpress xml

Copyright ©2010 Media Division