Generate Identity Column through Query..

Declare @ProductID int
set nocount on
insert into T_Table_Test(Product_Name,Today_Date) values('Testing',getdate())
SET @ProductId = IDENT_Current('T_Table_Test')
print @ProductId