IDENT_CURRENT

SELECT IDENT_CURRENT ('tblTaskRFP') AS Current_Identity;

http://msdn.microsoft.com/en-us/library/ms175098.aspx

Date conversion

SELECT @TodayAtNoon = CAST( CAST(Month(getDate()) as nvarchar(2)) + '/' + CAST(Day(getDate()) as nvarchar(2)) + '/' + CAST(Year(getDate()) as nvarchar(4)) + ' 12:00:00.000' as datetime)