Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page SQL Problems
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-23-2008, 02:38 AM
Caspersky12 Caspersky12 is offline
Newbie
  
Join Date: Feb 2008
Posts: 6
Rep Power: 0
Caspersky12 is on a distinguished road
Default SQL Problems
Please advice me what might be the possible solution to my command?

pls consider with this 2 Table as ex.:

Tbl_Subscriber
Acct_Num Name DueDate Month
123456 Mhel 18 January 2008
133445 Marlon 19 February 2008
111222 Test 01 March 2008

Tbl_Arrears
Acct_Num Name Month
123456 Mhel January 2008


Explanation: I want to Insert those records from Tbl_Subscriber into Tbl_Arrears, but if the Tbl_Arrears has an existing record similar to Tbl_Subscriber, the record should be going to update or replace... Please help...thanks a lot.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Tutorials Jordan Database & Database Programming 7 02-23-2008 03:20 AM
Make a script vulnerable to SQL injection? shibbythestoner PHP Forum 7 12-15-2007 08:56 PM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
Executing SQL Server 2k DTS Package via Visual Basic Joemama Visual Basic Programming 0 04-09-2007 06:21 PM
Oracle has more Flaws than MS SQL? Jordan Database & Database Programming 9 12-05-2006 09:39 AM


All times are GMT -5. The time now is 10:15 AM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

dargueta ........ 93.00000
John ........ 87.50000
Xav ........ 50.00000
MeTh0Dz ........ 20.00000
gaylo565 ........ 18.00000
Johnnyboy ........ 3.00000

Contest Rules

Sponsors

Linux Forums
Electronic Music

Ads