-- SELECT * FROM [dbo].[fn_GetData](1) CREATE FUNCTION [dbo].[fn_GetData]( @parameter1 INT ) RETURNS TABLE AS RETURN SELECT Column1, Column2 FROM table_name WHERE Column_Name = @parameter1