specified table

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

New Oracle10g SQL optimizer hints

With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an article about speeding up SQL execution in Oracle, I discussed some common SQL tuning hints and, in another article, I warned about performance issues when using SQL hints...

Tags: PRODUCTIVITY, Databases, Donald Burleson, specified table

Technical articles 2004-04-26

Additional Resources

How to continuously append live table to table?

I have a situation here:every month there will be a table (with 3200+- entries) that should be appended to a Year-to-Date table.I appended the second month's live table to the accumulative table, but don't know how to do it for the third month, other than deleting the live table temporarily...

Tags: shichen1979@...

Discussion threads 2007-05-31

Copying a table using VB

What is the easiest way to copy data and structure from 1 table to another table within the same database? it doesn't matter if table b is overwritten, I need a way to copy table A to table B

Tags: Microsoft development tools, Programming languages, andrew.s.fitchett@..., Microsoft Visual Basic

Discussion threads 2007-08-27

Transfer data from one table to another in Access

I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check it in the new table and if present...

Tags: o.kulahcioglu@..., Microsoft Access

Discussion threads 2007-07-17

MIL - Read Table (zip)

MIL - Read Table is a powerful automation tool that can read table from SAP. Using this application, you can instantly view and search table and data from SAP. MIL - Read Table is designed for high flexibility, numerous options enable you to read SAP table that best suits your...

Tags: SAP AG, Microsoft Windows, .Net, Productivity, Operating Systems, Software, Software Development, Software/Web Development

Software downloads 2008-02-05

Compare Sheets (zip)

Compare two tables created with MS Excel and create result table according to given criteria. Depending on compare function result table may include: lines from first table that have match in second table, lines from first table that haven't match in second table, lines from both tables that haven't match...

Tags: Table, Ventsislav Alexandriyski, Microsoft Excel, Microsoft Office, Office Suites, Software

Software downloads 2005-11-28

Populate Info from table to access form

I have a form that has SSN / Name / DOB / Servicing office employees table. Then I have the input table with SSN and other fields input table. On the form I have the SSN fields linked and then I call the SSN field on the form...

Tags: SSN

Q&A 2005-09-12

Can we clone a table structure to temp table in SQL server

Can we clone a table structure to temp-table in SQL server stored procedure?If yes, how should we declare the temp table and the command the clone the table structure?or can provide us a sample codes on the above solution.ThanksAnnoyingly simpleselect * into #temptable from Tableif you only want the structureSelect...

Tags: ysgoh3@..., Microsoft SQL Server, server

Discussion threads 2007-05-09

Compare records in 2 tables and move data from one table to the other

I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...

Tags: Microsoft Office, Table

Discussion threads 2005-08-11

Access Hacks: Create Access Tables From Outside Access

One has an Excel solution that needs to populate an Access table. The table will be a new table in the database. One might think the table needs to exist before one can populate it via ADO or some other means, so one manually creates the table and then goes...

Tags: Microsoft Access, Table, Microsoft Office, Microsoft Excel, Databases, Office Suites, Software, Enterprise Software, Data Management

Book chapters 2005-04-14

copy table from dataset

I need to copy table from a dataset then return saved copy into the original table.dim cpytbl as new datatablecpytbl = ds.table("name").copyentr processds.table.("name") = cpytbl this statement give an error "Property 'Item' is 'ReadOnly' "can you helpSeems to be a fundamental error hereWhy are you trying to do this?I can...

Tags: sahaah@...

Discussion threads 2007-02-25

Update data from one table to another table

Greetings:I have two sql 2000 databases, one on one server and one on another server. After bringing in the data from one table, I would like to update the other database table with the changed data.Quick and dirtyTruncate Table OutOfDateInsert OutOfDate Select * From UpToDate

Tags: Storage, Databases, greg_gordon@...

Discussion threads 2007-07-23

Inserting data from one table in access into another

I am creating an access db, and I've imported an excel spreadsheet into the db. I've created the table in access with the fields that I want to have in the table, but I am drawing a blank on how to update the table in access with the excel...

Tags: Microsoft Excel, daintysally

Discussion threads 2007-10-15

Periodic Table of the Elements (rar)

Free interactive periodic table program for MS-DOS. You can add new elements to the Mendeleev Table. Just edit file mendel.txt in Notepad Editor. For movement trough the table use cursor control keys.

Tags: Courseworking

Software downloads 2006-03-14

Copy an existing table structure into a new Access database

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table structure to a new table in another database. Have you been eyeing a...

Tags: Microsoft Access, Storage, Databases, Mary Ann Richardson, Microsoft Office, database, table structure, Microsoft Office Suite Access Tips Newsletter, Structure, Hardware, Enterprise Software, Software, Data Management

Technical articles 2005-07-26

Periodic Table (zip)

The periodic table--the cornerstone of chemistry--expresses in a compact form the relationships between all the elements in the universe. Synergy Creations' Periodic Table 4 is a versatile chemistry reference tool for your Windows XP computer that takes the periodic table beyond the simple paper periodic table found in so many...

Tags: Chemist, Synergy Creations, Productivity, Microsoft Windows, Microsoft Windows XP, Operating Systems, Software

Software downloads 2006-11-09

Table Control (rar)

Since the only way to view data in tabular format in most Microsoft .NET languages is via datagrid that is hardly a table control we decided to create a table control for the purpose of viewing and manipulating data in tabular format. Table Control allows you to view any textual...

Tags: Format, .Net, Application Servers, Middleware, Software Development, Software/Web Development, Enterprise Software, Software

Software downloads 2006-11-10

Word document into Excel

I am copying a word table into excel. Some cells in the word table contain text in bold format. When I copy the table into excel excel creates a new cell for the portion of the text in bold. The columns to the right of that column are then incorrectly...

Tags: Microsoft Excel, Microsoft Word, smh51156@..., software

Q&A 2005-09-08

Transfer data from one table to another in Access

I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check the name in the new table and if...

Tags: Databases, o.kulahcioglu@..., Microsoft Access

Discussion threads 2007-07-17

Table Tennis Screensaver (exe)

It has a Table tennis table background with table tennis balls bouncing over the screensaver. This version is the first release on CNET Download.com.

Tags: Background, Screensaver

Software downloads 2007-11-29