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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-12 : 07:46:09
|
| Banu writes "I have two tables. One is temporary . I make bulk insert to the permanent one from that temp one. In the temp one there is a column which has the value -1. When I insert the rows from temp to permanet table, I want this -1 value to set null value. You may ask why dont I put the null value first to temp table, it is a long story but I have to do it this way." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-12 : 12:37:41
|
| Just run an UPDATE statement after the data is transferred to the permanent table.Tara |
 |
|
|
|
|
|
Update the inserted row to a null value in trigger