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 - 2006-07-25 : 09:01:35
|
| An Le writes "Hi,I created a trigger to get data of field. But data type of field is ntext so trigger got error. Can you give me an advice?Thanks." |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-25 : 09:06:16
|
| You can't use TEXT in a trigger; however, you can use TEXT in an INSTEAD OF trigger - but they are a bit more of an effort to create and maintain (you have to dot he actual database table update yourself, whereas with an AFTER trigger its already been done)Kristen |
 |
|
|
|
|
|
ntext in trigger