17 lines
250 B
MySQL
17 lines
250 B
MySQL
|
DROP FUNCTION UczenSzkoly
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE FUNCTION UczenSzkoly
|
||
|
|
(
|
||
|
|
@zm VARCHAR(4)
|
||
|
|
)
|
||
|
|
RETURNS TABLE
|
||
|
|
AS
|
||
|
|
RETURN SELECT imie, nazwisko
|
||
|
|
FROM Uczniowie
|
||
|
|
WHERE klasa = @zm
|
||
|
|
GO
|
||
|
|
|
||
|
|
SELECT *
|
||
|
|
FROM UczenSzkoly('3GIM');
|