Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.50 KB | None | 0 0
  1. CREATE FUNCTION zad44(@id int)
  2. returns varchar(50)
  3. as
  4. begin
  5.     declare
  6.     @ilo varchar(50),
  7.     @imie varchar(50),
  8.     @result varchar(MAX)
  9.     set @ilo =(select count(*) from Wypozyczenia where IdKlienta=@id)
  10.     set @imie =(select Imie from Klienci where IdKlienta=@id)
  11.     set @result = CASE @ilo
  12.         when 0 then 'Klient '+@imie+' nie wypozyczał jeszcze ksiazek'
  13.         when 1 then 'Klient '+@imie+' Wypozyczal raz'
  14.         else 'klient '+@imie+' wypozyczal juz '+@ilo+' razy'
  15.         end
  16.         return @result
  17.  END;
  18.  
  19. print dbo.zad44(2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement