Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --FUNKCJE
- --SKALARNA
- CREATE FUNCTION ufn_raty
- (
- @placa MONEY
- )
- RETURNS MONEY
- AS
- BEGIN
- RETURN @placa / 12;
- END;
- GO
- --wykonanie
- select dbo.ufn_raty(3200)
- --TABLICOWA
- CREATE FUNCTION ufn_generacja
- (
- @x varchar(30)
- )
- RETURNS TABLE
- AS
- RETURN select *
- from Model
- where nazwa like '%'+@x+'%'
- GO
- --WYKONANIE
- SELECT *
- FROM ufn_generacja('Golf');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement