Posted by bhavin.vyas@gmail.com on 10/11/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

• Next in forum: Help with phoneBook db design
• Prev in forum: Migrating to SQL 2003
• Thread view: Text datatype as local variables in Trigger

[Reply to this message]