Did you mean
insertion (13 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- How do I... Add music and narration to a PowerPoint presentation?
- The best presentations engage the audience using a number of creative tools. Sound effects, such as music and voice recordings can mean the difference between a good presentation and an outstanding presentation. You can energize your audience with a quick tempo, play your company's latest jingle, or add narration to...
- Blog posts 2008-03-04
- Delete rows during updates using Oracle 10g's MERGE statement
- In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works. The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both...
- Technical articles 2007-02-20
- SQL Question: When the Pivot data contains a Key Column (and character data at that!)
- I recently wrote about pivoting (or is it unpivoting?) some data. A new wrinkle has been added.Let's say that the data now looks like this:INSERT INTO X ( FIELD1 ) VALUES ( 'row1,1,2'); INSERT INTO X ( FIELD1 ) VALUES ( 'row2,2,3'); INSERT INTO X ( FIELD1 ) VALUES...
- Blog posts 2006-07-06
- Control data caching in .NET with the Caching API
- Decreasing page load time is imperative when dealing with Web site performance. Tony Patton explains how you can make this happen by using the .NET Caching API. Caching frequently accessed or expensive data in memory boosts application performance by reducing the number of database calls to retrieve...
- Technical articles 2006-06-30
- Found it in Word 2002
- Found it in Word 2002Record audible comments for your Word documentRecord audible comments No Good.The tip did not work.I have Word 2003. I could not find the Insert sound icon on the Reviewing Bar. This tip was no good.Try this...From Microsoft Help:On the Reviewing toolbar, click Insert Voice.If the...
- Discussion threads 2006-06-21
- Insert varchar value to number field
- Can i insert the values like thisINSERT INTO sara SELECT To_Numberagreementid from empHere sara table have agreementid as number(18,4)emp table have agreementid as varchar(255) but it contains only number in that field.While inserting i got ORA-01722 INVALID NUMBER error. I check there is not character in that field.Can anybody help...
- Discussion threads 2006-06-08
- Expose your development to more possibilities by using PHP with SQLite
- One of the innovations in PHP5.x is the inclusion of the SQLite database engine. SQLite is a fully self-contained, portable file-baseddatabase engine that can be used for most SQL operations without incurring theoverhead of client-server communication. This SQLiteAPI is activated by default in PHP 5.x, which means that you can...
- Technical articles 2006-04-28
- Customize database queries using views in PostgreSQL
- One of PostgreSQL's more usefulcapabilities is the ability to create custom "views". These views arenothing more than pre-defined SQL queries, which are stored in the database andcan be re-used as and when needed. Storing frequently-used SQL queries in thismanner is more efficient than typing them out each time and also...
- Technical articles 2006-01-27
- Build upon SQL's built-in statistical functions
- Median code not practicalThe code to compute the median is not very practical, as it employs a cross join. On one of my modest tables, the 60,000 rows will become 3.6 billion in the intermediate result set. I let it run for over 30 minutes before I terminated the query....
- Discussion threads 2006-01-24
- Trigger output
- I'd like to use a trigger to identify the GUID that was assigned to a record just inserted. Here is the TRIGGER statement:CREATE TRIGGER trigBoardsGUID ON [EngineeringUser].[Boards] FOR INSERTASBEGIN SET NOCOUNT ON SELECT Board_GID AS '@@GUID' FROM insertedENDHow do I access '@@GUID' from my stored procedure that inserts into Boards?I was using an...
- Discussion threads 2006-01-10
- Merge (AKA Upsert) - A Definition in Plain English
- The basic Data Manipulation Language DML commands that have been in use over the years are Update, Insert and Delete. They do exactly what you expect: Insert adds new records, Update modifies existing records and Delete removes records....This post originally appeared on an external website
- Blog posts 2005-08-16
- DBA's have feelings too...
- DBA's have feelings too...blog rootselect from whereOk, my first entry..and typical, just like school, not sure what i wanna write. I'll be short and sweet for now. Its friday, i'm gonna head home at 4 pm and paint my <insert swearing> kitchen. Then, my angel is coming to me for...
- Discussion threads 2005-07-01
- Insert page number in slides
- I want to know how to insert page numbers in the ppt slides.Insert>Slide NumberOr do you mean something else by "Page number"?Hello,...to add a slide number to the current slide, first position the insertion point in a text placeholder or textbox where you want it to go, then click->Insert->Slide Number....to...
- Q&A 2005-06-28
- Account for scope when writing stored procedures
- SQL Server provides the variable @@Identity to solve a particular problem that you may encounter when writing stored procedures. However, the @@Identity value has no concept of scope. Learn how you can work around this issue by using the new Scope_Identity function. A common problem in writing stored procedures...
- Technical articles 2005-06-20
- Sql-Sever 2000 DBA Help
- Their is a specific problem in my ms-sqlsever 2000database as i am having 3 Big tables A,B,C and each table contains around 1 million record and all 3 tables contains clustered index which is always incremented and apart of that their are unclustered index also on each tables. My system...
- Q&A 2005-03-02
- Visual Basic Search Text and Insert Row
- Hello,I need to write a Visual Basic program that will search the Excel sheet for a number and then insert a row where that number occurs. I can write the code to search. I can also write code to insert a row at a specific location. My...
- Q&A 2004-12-07
- Insert Object from file (Office 2003)
- I am able to insert an object in Word 2003, using create from file Excel file, but receive an error message when trying to manipulate the object, RE unable to start the application. Choice to repair the feature does not resolve the issue. Running XP SP2, and tried office updates/detect...
- Q&A 2004-11-03
- Head-ache
- I have been working on numerous individual documents all having individual formatting requirements. I attempted to use the combine subdocuments facility but that removed the formatting. I wish to combine these documents to produce a handout, so having one print request, is preferable to having 40+ print requests, and then...
- Discussion threads 2004-10-28
- Give your Word documents a professional look by adding symbols
- The smallest details often make a big difference in the appearance of your documents. See how the simple trick of adding a couple of special characters can improve your page design. by Mary Ann Richardson
- Blog posts 2008-09-02
- Generate a descending-order numbered list in Word
- Word can't automatically produce a numbered list that counts down instead of up. But with the help of a bookmark and some fields, you can work around that limitation. by Susan Harkins
- Blog posts 2008-09-25
- << Previous
- page 1 of 2
- Next >>
Content Types
Refining Tags
What it takes to stay on the edge of innovation
Going green and managing costs during tough economic times
Taking chances with the core brand
Transforming the company and developing new delivery platforms
