How To Insert Into A Table With A Function?

I want to add a record into a table, using a function.
This function needs to give back the number of records of a given table.


Function ImportResults


@NumberOfRecords int
@TableName varchar(60)
@ImportDate datetime
@Result bit

@Result = 1
@ImportDate =getdate()

--Open Table with tablenames

select TableName from Tbl_ImportTables
For each record in Tbl_ImportTables

@TableName = Tbl_ImportTables.TableName
@NumberOfRecords = select count(*) from @TableName
-- add to Import Results
Insert into Tbl_Import_Results


(ImportDate
,TableName
,NumberOfRecords
)
VALUES
(
@ImportDate
, @TableName
, @NumberOfRecords
)
-- Check 0 records (I only want to know if there is a table with 0 records)
IF @NumberOfRecords=0 then @Result=0
Next record



RETURN @Result

End function


Can somebody help me with the right syntax (I am new to functions and sp's)?
Is this a scalar valued function?

Thanks,
Frans