How to execute function for every row?

Transact-SQL
2

One way would be to create a UDF

CREATE function dbo.mygetdate() RETURNS datetime AS
BEGIN 
 RETURN GETDATE();
END 
GO

SELECT dbo.mygetdate() FROM sys.all_columns