No, mira lo que dicen tus propios libros online
2005 In a DELETE, INSERT, or UPDATE trigger, SQL Server does not allow text, ntext, or image column references in the inserted and deleted tables if the compatibility level is set to 70. The text, ntext, and image values in the inserted and deleted tables cannot be accessed. To retrieve the new value in either an INSERT or UPDATE trigger, join the inserted table with the original update table. When the compatibility level is 65 or lower, null values are returned for inserted or deleted text, ntext, or image columns that allow null values; zero-length strings are returned if the columns are not nullable. If the compatibility level is 80 or higher, SQL Server allows for the update of text, ntext, or image columns through the INSTEAD OF trigger on tables or views. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/local/note.gifImportant: ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use <ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/81ee5637-ee31-4c4d-96d0 -56c26a742354.htm> nvarchar(max), <ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/282cd982-f4fb-4b22-b2df -9e8478f13f6a.htm> varchar(max), and <ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bcce65f9-10db-4b3e-bfaf -dfc06c6f820f.htm> varbinary(max) instead. Both AFTER and INSTEAD OF triggers support varchar(MAX), nvarchar(MAX), and varbinary(MAX) data in the inserted and deleted tables. 2000 * In a DELETE, INSERT, or UPDATE trigger, SQL Server does not allow text, ntext, or image column references in the inserted and deleted tables if the compatibility level is equal to 70. The text, ntext, and image values in the inserted and deleted tables cannot be accessed. To retrieve the new value in either an INSERT or UPDATE trigger, join the inserted table with the original update table. When the compatibility level is 65 or lower, null values are returned for inserted or deleted text, ntext, or image columns that allow null values; zero-length strings are returned if the columns are not nullable. If the compatibility level is 80 or higher, SQL Server allows the update of text, ntext, or image columns through the INSTEAD OF trigger on tables or views. ----------------------------------------------------------- Microsoft MVP en SQL Server Mentor asociado en SQLTotalConsulting Excelencia en servicios y consultoria SQLServer www.sqltotalconsulting.com ----------------------------------------------------------- De: dbms@mug.org.ar [mailto:[EMAIL PROTECTED] En nombre de Luis Enviado el: Tuesday, March 18, 2008 8:49 AM Para: Maxi Asunto: [dbms] Trigger's - Columnas de tipo Text Hola a todos, tengo el siguiente problema: Al crear un trigger's, no me permite manipular atributos tipo text. Hay alguna forma de poder manejarlos a nivel de triggers? Esto es, porque estoy haciendo un triggers, que cada vez que se inserta un Nota de Venta, algunos datos de esta se graban en otra tabla. Uno de esos datos es de tipo text, que el operador incluye algun comentario sobre dicha Nota de Venta,y es un dato importante para el preparado del pedido. Un abrazo a todos. Ibaseta, Luis. _____ Ingresá ya a MSN en Concierto y disfrutá los recitales en vivo de tus artistas favoritos. MSN en Concierto <http://msninconcert.msn.com/music/archive/es-la/archive.aspx>
<<image001.gif>>
