|
| About Databases
Databases
Microsoft SQL Server 2008 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.
Read the full tutorial: Installing SQL Server 2008 R2 Express EditionInstalling SQL Server 2008 R2 Express Edition originally appeared on About.com Databases on Thursday, February 9th, 2012 at 04:15:30. Permalink | Comment | Email this
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it's certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you'll have the tremendous power of the flexible MySQL relational database available to you for free. It's an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here's a step-by-step walkthrough of the process.
Read the full tutorial: Installing MySQL on Windows 7Installing MySQL on Windows 7 originally appeared on About.com Databases on Tuesday, February 7th, 2012 at 04:42:41. Permalink | Comment | Email this
One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Read the full story: Printing Mailing Labels in Access 2010Mailing Labels in Microsoft Access 2010 originally appeared on About.com Databases on Thursday, February 2nd, 2012 at 04:12:15. Permalink | Comment | Email this
In a recent forum message, MRTK2012 wrote:
"Could anyone please let me know how to append a wildcard in bcp file to insert
data into database?
In the below example I want to use the wildcard after "inventory", so that I can run all bcp files in a single click:
bcp inventory.dbo.fruits in "C:\fruit\inventory0.txt" -c -T
bcp inventory.dbo.fruits in "C:\fruit\inventory1.txt" -c -T
bcp inventory.dbo.fruits in "C:\fruit\inventory2.txt" -c -T
Thanks in advance."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
BCP and Wildcards originally appeared on About.com Databases on Tuesday, January 31st, 2012 at 04:24:13. Permalink | Comment | Email this
With the release of SQL Server 2008, Microsoft included Change Data Capture (CDC) functionality for the first time. This highly anticipated feature provides administrators with the ability to perform detailed auditing of database changes.
Read the full story: Change Data Capture in Microsoft SQL ServerChange Data Capture (CDC) in SQL Server originally appeared on About.com Databases on Thursday, January 26th, 2012 at 04:03:22. Permalink | Comment | Email this
In a recent forum message, Kulashnikov24 wrote:
"I am creating a database for my contacts in which I intend to store their visiting details with date and time and also want include an option in the form to check the history for their previous visits.
Is this possible?"
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
Visitor Contact Database originally appeared on About.com Databases on Tuesday, January 24th, 2012 at 04:23:00. Permalink | Comment | Email this
Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure that the referential integrity of the database is preserved when information is added, removed or modified.
Read the full story: Foreign Keys in SQL ServerMicrosoft SQL Server Foreign Keys originally appeared on About.com Databases on Thursday, January 19th, 2012 at 04:57:11. Permalink | Comment | Email this
In a recent forum message, Maru314 wrote:
"I recently had to normalize the attached table for my final exam of my database course. I got really turned around because all of our other examples, we had composite primary keys that would be used to uniquely identify everything that was on the normalized form. Yet with this example, I really only need to use PropertyID, Listing Agent or the Office Phone to uniquely select anything on this table. So how do I go about getting this to the third normal form?"
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
Normalizing a Table originally appeared on About.com Databases on Tuesday, January 17th, 2012 at 04:21:44. Permalink | Comment | Email this
In a recent forum message, RogD1 wrote:
"Hello, I'm new to this list so bear with me. Here is the gist... I have a soil pedon (a hole in the ground) identified by the field "userpedonid". There are several horizons in each pedon all with the same userpedonid and also further identified by a field called "masterhorz". There is also a field called "bottomdepth" and a field called "topdepth" for each horizon. Some horizons have data in a field called "reskind" the rest are blank. If there is an "O" populated in the masterhorz field then I want the new calculated field to be the depth of the reskind minus the "O" horz depth. If I were to write this expression it would look like this...
IF the userpedonid is the same for each horizon, AND the masterhorz = "O" AND reskind isnotnull THEN subtract the bottomdepth of the "O" horz from the topdepth of the horizon where reskind isnotnull.
To further complicate things, sometimes I have two "O" horizons, so I would want to use the one in the expression above where the bottom depth is a higher value.
Thanks for the help."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!Complex SQL Query originally appeared on About.com Databases on Thursday, January 12th, 2012 at 04:18:03. Permalink | Comment | Email this
In a recent forum message, Etrek42 wrote:
"I wrote a query:
CREATE DATABASE MyDataBase
USE MyDataBase
But I get an error saying the database doesn't exist."
Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!
Creating and Immediately Using a Database originally appeared on About.com Databases on Tuesday, January 10th, 2012 at 04:20:15. Permalink | Comment | Email this
Newsfeed display by CaRP |