Posted by bhavin.vyas@gmail.com on 10/30/70 11:34

Friends,

I would just like to know that why SQL Server doen't allow us to define
a text data type local variable while creating trigger?

I tried creating a text variable in a trigger as a local variable and
it raises error.

"Implicit conversion from data type text to nvarchar is not allowed.
Use the CONVERT function to run this query".

For this i have to use convert function in MS SQL Server.

-Thanks
Bhavin Vyas

[Back to original message]