News

How to Transfer Data in Web Form to a Database. Moving information from an HTML form into a database is a two-step design process. First, create an entry HTML form capable of passing information ...
Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL.
Want to create a Windows application that lets your user edit and view structured data locally without connecting to a remote database? XML is the answer.
Storing the data independent of the SaaS database provides greater flexibility to transform, join, cleanse, cube, or aggregate data as required by downstream users and applications.
Following this move to a data-driven model, adding, deleting, or changing the specifications for any field in any of the applications I developed entailed nothing more than a change to the database.
Warnings When you import a spreadsheet into an OpenOffice.org database, you lose any text styling, number formatting, macro scripts or charts that you previously used to enhance the data.
Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.