Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Ease database management and automate functions with triggers in MySQL
- In SQL terms, a triggeris "procedural code that is automatically executed in response to certainevents on a particular table in a database" Wikipedia. More simply, it is a stub of code that isautomatically activated when a particular database event, such as an INSERT or DELETE,occurs. Triggers are handy for logging,...
- Technical articles 2006-08-23
Additional Resources
- How to write a simple access query
- I'd be grateful if anyone could help me with the following:What I'm trying to do is write a simple access query to change the format of the logon name from Username_Initial to firstname.surname. I have 3 separate fields one holding the Firstname, one holding the surname and the other holding...
- Discussion threads 2008-09-08
- Tech Tip: Indent Word paragraphs/Excel page breaks/Search with Access parameter query
- Word: Quickly indent paragraphs and lists Although you can use the Paragraph dialog boxor the Ruler, using the Formatting toolbar's Increase Indent orDecrease Indent buttons may be the quickest method to indentparagraphs or lists. Clicking the Increase Indent or Decrease Indentbuttons increases or decreases the indent from...
- Technical articles 2003-12-08
- An introduction to foreign keys and referential integrity in MySQL
- Referential integrity is an important concept in databasedesign. The term refers to a state when all the references in a database arevalid and no invalid links exist between the various tables that make up thesystem. When referential integrity exists, any attempt to link to a recordwhich does not already exist...
- Technical articles 2006-02-06
- Eliminate duplicate records with this built-in Access query
- Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily.When maintaining an Access database, it's a good idea to regularly remove duplicate records. Duplicate records can pop up even with proficient data entry processes. For example, the...
- Technical articles 2002-01-29
- SQL Query
- I work for a Theatre and I need to write a query to see if a patron has visited us more than once in a week. I have a table, let's say [Visits] that has the [DateVisited],[TicketNum] and the [PatronID]. Who would I create a query to see if any...
- Q&A 2005-06-17
- Three easy ways to optimize your MySQL queries
- This article is also available as a TechRepublic download, which includes the code listings in a more manageable text file format.Any database programmer will tell you that in high-trafficdatabase-driven applications, a single badly-designed SQL query can significantly impact the overall performanceof your application. Not only does such a query consume...
- Technical articles 2006-11-20
- Use Excel's MS Query Wizard to query Access databases
- Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program. There's data in your company's Access database that you need to analyze, but the PC you work with does...
- Technical articles 2006-09-19
- Tech Tip: Print multiple Word docs/Simplify Excel dates/Preload a table into a new Access query
- Print multiple documents from the folderlist Printing a number of Word documents can easilybecome cumbersome. Rather than opening each file and printingindividually, use the folder list to print them all at once. Follow these steps: Open the folder that contains the...
- Technical articles 2004-08-02
- Protect sensitive Web site data by encrypting information with MySQL
- If you're running a Web application using MySQL, chances aregood that it has passwords or other sensitive data stored somewhere within it.Securing this data from hackers or snoopers is a critical concern, both toavoid unauthorized use or damage to your application and to retain yourcompetitive advantage. Fortunately, MySQL comes with...
- Technical articles 2006-10-09
- Use the Perl DBI for connecting to a MySQL database
- One of Perl'scoolest modules is the Perl database interface DBI. This module offers a unified interface to differentdatabases, providing a series of generic functions that are internallytranslated into native function calls. This makes it extremely easy to takeadvantage of a database and create dynamic Web pages using Perl.A commonly-used database...
- Technical articles 2005-11-09
- Put the GUI on Windows XP Pro's Driver Query command-line tool
- Multiple driver queries are made easy with Greg Shultz's HTML Application, which puts a GUI front end on XP Pro's Driver Query command-line tool. Get the low-down on when you'll use this tool and a run-through of his program.When you're troubleshooting a problem that you suspect is related to a...
- Technical articles 2002-08-05
- Access query: inserts dynamically reflected on input?
- Hi,I have an Access 2002 query that inserts rows into a table.As an input FROM for the query there is another query based upon the same table that receives the inserts.Is there a way of having the main query read the rows just inserted? IOW, can these inserts immediately reflect...
- Discussion threads 2008-11-22
- How do I... Stress test MySQL with mysqlslap?
- One of the interesting new tools in MySQL 5.1.4 is mysqlslap, a load emulator that lets you see how well a particular query set or table engine performs under high-load conditions. A query that consumes too many database resources may be the result of designing tables incorrectly,...
- Blog posts 2007-09-17
- Access Query for next record
- Ok, here's what I got.I have a form used for Data Entry to add records to an Access DB. The table I am adding to has 2 primary keys, taskNumber and taskYear. Both are manually entered. What I am trying to do is when the user presses the Add button,...
- Q&A 2005-06-16
- Narrow a saved search with Vista's Query Composition feature
- While writing about scripting Windows Sidebar gadgets for the last two editions of the Windows Vista Report, I spent a lot of time searching with the Windows Vista Search tool. I performed several wide-ranging searches using wildcard characters; for example, to find all of my VBScript scripts, I searched for...
- Blog posts 2007-12-12
- Tech Tip: Create a Word text box/Exclude zero values in Excel/Use the Access crosstab query
- Create a text box from existing text People often use text boxes to highlight aspecific part of their document. But when you want to use a textbox, there's no need to retype the text. Follow these steps: Copy the text you...
- Technical articles 2004-08-03
- How do I... Query foreign data using SQL Server’s linked servers?
- If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of us aren't that lucky. Sometimes, the data we need is a non-database format or resides on a different server. SQL Server...
- Blog posts 2007-07-02
- Access 2000 Simple Query
- I have a Flat file with Employee Name, Class1 Date, Class2 Date & Class3 Date.What I am trying to do is get a Spreadsheet looking report with Dates across the top and using a query for a date Range.For Example: Show ALL Classes >= 05-01-2006 and = #05-01-2006# and
- Q&A 2006-05-23
- Tech Tip: Save to the right Word folder/Calculate a person's age in Excel/Delete fields from an Access query
- Make sure users save to the right folder By default, Word automatically saves all filesto the My Documents folder. But if you prefer users to save allfiles to another folder, such as one located on the company server,they don't need to navigate to that folder each time...
- Technical articles 2004-08-03
- << Previous
- page 1 of 1
- Next >>
