gistfile1.cfm

<cfquery name="test" datasource="#this.dsn#" result="testing">
	<!--- DECLARE temp table --->
	DECLARE @resultSet TABLE( no INT )
	
	<!--- INSERT last current identity value into temp table --->
	INSERT INTO @resultSet (no) VALUES (IDENT_CURRENT('contacts'));
	
	INSERT INTO contacts (
				firstname
				,lastname
	)
		SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="Marko">
				,<cfqueryparam cfsqltype="cf_sql_varchar" value="Simic">
	
		UNION ALL
	
		SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="Boris">
				, <cfqueryparam cfsqltype="cf_sql_varchar" value="Huskic"> ;
	
	<!--- INSERT last inserted identity value into temp table --->
	INSERT INTO @resultSet (no) VALUES (scope_identity());
	
	<!--- SELECT and return values from temp table --->
	SELECT * from @resultSet;
	
</cfquery>