Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
on7june
Starting Member
41 Posts |
 Posted - 2007-10-22 : 00:20:17
|
| My previous post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90997I am working in uploading those flat files in to the SQL Server. I need to create a configuration table. How to do it? Configuration table holds the table which we are using in our database. The main reason to have this table is to avoid rework ie, when we generate the flat files again, the following changes might be occurred,1. New records may be added.2. One or more records may be updated.3. one or more records may be deleted.How to make these delta changes in the table. I am not interested in deleting or truncating the old table and then uploading these updated files in to it. I want only the records which is modified or deleted or newly added to be updated in my table.Thanks in Advance. Sarvan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-10-22 : 00:50:50
|
what do you mean by a configuration table ? what is it for ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Configuration Table