create trigger tr_history_betcd_for_insert
on betcd
for insert, update
as
begin
	declare @id_tbl_links as int
	declare @id_fair as int
	declare @data as varchar( 8000 )
	DECLARE @lName sysname
	DECLARE @Query nvarchar( 1024 )
	DECLARE @result int

	declare cr_select_links scroll cursor for
	select id_tbl_links, return_field from tbl_links
	where has_history =  1  and relation_type =  0  AND ref_table_name = 'betcd'

	OPEN cr_select_links
	FETCH FIRST FROM cr_select_links INTO @id_tbl_links, @lName

	WHILE @@FETCH_STATUS =  0 
	begin
		SET @Query='SELECT @result=Count(*)
		FROM inserted 
		FULL OUTER JOIN deleted 
		ON inserted.['+@lName+'] = deleted.['+@lName+'] 
		WHERE inserted.['+@lName+'] IS NULL OR deleted.['+@lName+'] IS NULL' 

		execute sp_executesql @Query,N'@result int OUTPUT', @result OUTPUT

		if @result >  0 
		begin
			set @Query='select @data=cast('+@lName+' as varchar(8000)) from inserted'
			execute sp_executesql @Query,N'@data varchar(8000) OUTPUT', @data OUTPUT

			insert into history_data (id_tbl_links, id_fair, history_data)
			values (@id_tbl_links, NULL, @data)
		end

		FETCH NEXT FROM cr_select_links INTO @id_tbl_links, @lName
	end
	CLOSE cr_select_links
	DEALLOCATE cr_select_links
end
GO