<--- --------------------------------------------------------------------------------------- ---- Blog Entry: ColdFusion CFQueryParam Binding vs. SQL Execution Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1092.view Date Posted: Dec 18, 2007 at 8:29 AM ---- --------------------------------------------------------------------------------------- ---> DECLARE @contact TABLE ( id INT, first_name VARCHAR( 30 ), last_name VARCHAR( 30 ), age INT ); DECLARE @id INT ; INSERT INTO @contact ( id, first_name )( SELECT 4, 'Anna' ); SET @id = ISNULL( ( SELECT id FROM @contact WHERE id = ), 0 ); IF (@id = 0) BEGIN INSERT INTO @contact ( id, first_name, last_name, age ) VALUES ( , , , ); SET @id = @@Identity; END ELSE BEGIN UPDATE @contact SET first_name = , last_name = , age = , id = @id WHERE id = @id ; END ;