I want to do something like this

Select @MyText = LongDescription
From MyTable
Where id = inserted.[ID]

I get an error message telling me that nText is invalid for a local variable
how can I do this?

You need to post more info about what you're trying to do in your trigger.

Why do you need to use a local variable? If nothing else, that will
cause problems when the trigger is fired on a set of more than 1 row
(because SQL Server will object to putting LongDescription from multiple
rows into a single variable - it's just not possible to encompass a set
of data within a single scalar variable). Set based operations are
usually far more efficient than this row-by-row way of processing data.

Can you post your whole trigger (or at least pseudo-code of what you're
trying to do in your trigger)? What about the tables affected/touched
by the trigger? Schema? Data? Expected results?

--
*mike hodgson*
http://sqlnerd.blogspot.com



[quoted text, click to view]