Funkcije

CREATE FUNCTION fName(@Parametar1 tip1,@Parametar2 tip2,...)
RETURNS returnValType
AS
BEGIN
Statements
RETURN returnVal
END

CREATE FUNCTION fName(@Parametar1 tip1, @Parametar2 tip2,...)
RETURNS TABLE
AS RETURN StatementThatReturnTable

SELECT * FROM dbo.fName(par1, par2...)

CREATE FUNCTION fName(@Pol VARCHAR(1))
RETURNS @TABLE TABLE(Ime VARCHAR(20),Plata INT,Pol VARCHAR(1))
AS
BEGIN
INSERT INTO @TABLE
SELECT Ime,Plata,Pol
FROM Zaposleni
WHERE Pol = @Pol
RETURN
END