Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Filtering data with SQL Server
- In SQL Server, data analysis begins with the GROUP BY statement. This powerful SQL feature filters data to return the exact information you need.Relational data is typically stored in a normalized format, which means that you repeat as little data as possible; typically just keys that tie one table to...
- Tags: Databases, NorthWind database, Relational Data, Craig Utley, server, Microsoft SQL Server, Group-By, SELECT o.OrderID, OrderID, Order Details
- Technical articles 2002-07-30
Additional Resources
- Access 2000 Tutorial: Northwind Traders Sample Database (exe)
- You can use the Northwind Traders sample database as a tool to help you learn Access 2000. Experiment with the data stored in Northwind, and use the forms, reports, and other database objects as models for your own database. When you first open the Northwind database, all the objects in...
- Tags: Microsoft Access, Trader, Window, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2007-09-17
- ViaXML Northwind - Device Sample (exe)
- Mobile Data ViaXML Style. The ViaXML Northwind device component demonstrates how easy it is to create a mobile solution using ViaXML. It provides three distinct functions: viewing orders, entering orders, and capturing signatures. This version is the first release on CNET Download.com.
- Tags: Mobile, Advertising & Promotion, Marketing
- Software downloads 2007-09-14
- Visual Basic .NET Code Sample: Create a Database (exe)
- This application shows you how to execute SQL statements from code using ADO .NET. It creates a database, a table, a stored procedure, and a view. SQL statements are then executed that populate the table with data from the Northwind database. This table is then queried to fill a DataSet...
- Tags: Microsoft Visual Basic, SQL, Microsoft Visual Basic.Net, Table, Programming Languages, Databases, Storage, Microsoft Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware, Development Tools
- Software downloads 2007-08-30
- Access 2000 Visual Basic
- I have a form that shows all the fields for one record in a database. I currently use the Find button to find a particular record matching the key field, which is in the format of a single number.I would like to type the key field contents into a Text...
- Tags: BobTheBuilder, Combo Box, Microsoft Access, software
- Q&A 2004-12-04
- Auto-entry
- I have a table showing suburbs/towns with their associated zip/post code.In a data entry form how do I get the correct zip/post code to be automatically entered when the user enters the suburb/town?How is the table stored? File or Database? Do you use some technology like Java, ASP, PHP,...?What is...
- Tags: Storage, Databases, Scripting languages, Microsoft Office, database
- Q&A 2006-06-16
- Stock Control in MSAccess
- Using the northwind sample database as an example, how do you update the unitsinstock field in the products table based on units sold per order. An update query doesn't do it properly. Also if new stock is received, how do you update the unitsinstock field?ThanksJim
- Tags: Investment, jimpoland@..., stock
- Discussion threads 2007-06-18
- Generate summary report in Access
- I want to run a summary report based on a weeks worth of data I have in the Access database. Need some help figuring it out though. Just to give a brief example of what I'm looking to do, look at this:Monday, Jan 1st: Sold 2 apples, made $1.00Tuesday Jan...
- Tags: Microsoft Office, Databases, Jan, Northwind Sample Database
- Q&A 2006-02-06
- Access 2000
- I have created a few access databases for use in our company. I have set all the options so for users it goes straight into the menus and removes all non needed options for them, i still have the shift option to allow access into the database for work. Im...
- Tags: database, IM, Microsoft Access, password, software, Sprocket
- Q&A 2005-08-16
- MSDN Webcast: Guided Hands-On Lab: Building a Word Document Using Visual Basic and SQL Server Data (Level 200)
- The attendee of this webcast will learn how to take advantage of data in a more traditional data store using a Microsoft Office Word document. This webcast creates a Word document that uses bookmarks as locations for inserting text retrieved from the Microsoft SQL Server Northwind sample database.
- Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Visual Basic, Server, Microsoft Corp., Microsoft Word, Word Processors, Digital Media, Microsoft Office, Databases, Office Suites, Software, Consumer Electronics, Personal Technology, Enterprise Software, Data Management
- Webcasts
- Use the data access layer to simplify architecture
- Unless you are working with legacy code or systems, mostapplication development is done in a multiple tier or layered environment. Thismay include a database layer along with the business rules and presentationlayers. A key part of every n-tiered environment is the database tier. In thiscolumn, we examine how the database...
- Tags: data access, data access code, database, Tony Patton
- Technical articles 2006-05-30
- SQL Dumper (zip)
- SQL Server Dumper enables you to dump selected SQL Server database tables into SQL Insert statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file...
- Tags: Microsoft SQL Server, SQL, SQL Server Dumper, Programming Languages, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management
- Software downloads 2007-06-21
- Finding similar
- Hello, I have an Access database with a table that has 2 fields, 1 of the fields holds data in a alfa numerical format such AA12E3. The last figure goes from 0 to 9 then the second last figure escalates by 1 ie AA12E4 and so on. Some of these...
- Tags: AH45A5, donn.houldsworth@..., sequential number, software, Value at Risk
- Q&A 2005-02-25
- ActiveDB (txt)
- With ActiveDB you can access your SQL Server stored procedures from a .NET program with one line of code. It's like having IntelliSense on your database. Just point ActiveDB at your development database and let it generate all the stored procedure call stubs. Then give ActiveDB the actual connection string...
- Tags: Stored Procedure, mfByte, ActiveDB
- Software downloads 2008-06-23
- Three recovery models for backing up your SQL Server
- By Ed MartinWith SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy to meet your needs. Let's take a look at some of the basic backup strategies that...
- Tags: Backups, Storage, Databases, Guest Contributor, server, BULK_LOGGED recovery model, backup, database, recovery model, Microsoft SQL Server, disk
- Technical articles 2003-04-29
- m9P Database (exe)
- m9P Database is a professional database builder and manager for home and business. m9P Database helps to successfully manage database needs, such as updates and backups. It allows for multiple users. Each database is secured by a password and by users' privileges. It has built-in transactional support, allowing the user...
- Tags: m9P Database, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2005-07-28
- Use .NET to develop and implement a Web service solution from start to finish
- Web services have emerged from an intriguing concept to atechnology that has taken the industry by storm. It has slowly been adopted,but its momentum shows no sign of slowing down. Microsoft quickly recognizedthe power of the Web services concept and fully embraced the technology withits many products. This is the...
- Tags: SOA, Web, Web service, Tony Patton, Northwind personnel, Northwind
- Technical articles 2005-06-07
- Oracle Database Lite 10g: What's the Difference With Other Oracle Database Editions?
- Oracle Database Lite is another edition, however the Oracle Database Lite Edition functions as a feature for either Oracle Database Enterprise Edition or Oracle Database Standard Edition. Oracle Database Lite does not replace other database editions. Oracle Database Lite is designed to make your existing Oracle Database mobile. On occasion,...
- Tags: Oracle Corp., Oracle Database, Oracle Database Lite, Databases, Enterprise Software, Software, Data Management
- White papers 2004-04-01
- Committing imports in SQL Server a little at a time
- Learn how Arthur Fuller helped a colleague, who was working on an Informix database and needed to search TEXT columns using wildcards. Check out the simple solution to this seemingly perplexing problem. A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix...
- Tags: Microsoft SQL Server, Informix Software, Databases, Arthur Fuller, DTS, Commit Final Batch, text-file, server, SQL Server Newsletter, TechRepublic Inc., Option, TEXT, Enterprise Software, Software, Data Management
- Technical articles 2006-07-31
- TDBDemo (zip)
- TDBDemo is a simple database apllication, based on Tiny DataBase engine. You can create database files, add records to database, and remove records from database. The format of the database files is special and can't be read by known database applications.
- Tags: TDBDemo, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2005-12-11
- << Previous
- page 1 of 1
- Next >>
