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 - 2007-02-14 : 08:35:42
|
| Jan writes "Is there an example available that describes how a trigger would be assembled to replicate the value in one column to another within the same table. Whenever column A is either created or changed, columm B mimics it. I have a situation where a particular report writer will not recognize the "BIT" data type, and the application will not allow me to change the original data type in the DB, so I need to replicate the data into a "tinyint" data type and then use it in to develop my report. Any thoughts?" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-02-14 : 08:47:38
|
| Have you considered a computed column? That would be much easier. Or a view?===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-02-14 : 09:28:00
|
| (Locked as a duplicate)===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
Triggers Updating Column B from Column A