Updated Columns List

This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2014-02-10 (first published: 2012-06-06)

1,580 reads

Blogs

Both SQL Server and PostgreSQL are moving fast into AI territory — and if...

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

WhatsApp Cs,0817844112 Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112

WhatsApp Cs,0817844112 Jl. Raja Ali H. No.18, Sei Jodoh, Kec. Batu Ampar, Kota Batam,...

WhatsApp Cs,0817844112 Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau...

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;