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 - 2000-10-22 : 23:41:46
|
John writes "I have two tables in an SQL Server 7 Database:
Table1 contains three fields, ID Title & Description
Table2 contains four fields, ID Title Description & DateUpdated
I want to place a trigger on Table1 for all updates, where the data contained in the record being updated is inserted into a new record in Table2...
Easy enough unless the Description field is an SQL "Text" data type.
Any suggestions on methods of doing this would be gratefully received!" |
|
|
|
|
|
Copying records containing text fields between tables