Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION palindrom(@ime VARCHAR(30))
- RETURNS VARCHAR(80)
- BEGIN
- DECLARE @izlaz VARCHAR(80);
- IF(@ime > 30)
- SET @izlaz = 'Ulazna riječ je predugačka, maksimalan broj znakova je 30';
- ELSE IF(@ime == REVERSE(@ime))
- SET @izlaz = 'Palindrom';
- ELSE
- SET @izlaz = REVERSE(@ime);
- RETURN @izlaz;
- END
- SELECT dbo.palindrom('neko_ime') AS Palindrom;
- CREATE PROCEDURE palindrom
- @ime VARCHAR(30)
- AS
- DECLARE @izlaz VARCHAR(80);
- IF(@ime > 30)
- SET @izlaz = 'Ulazna riječ je predugačka, maksimalan broj znakova je 30';
- ELSE IF(@ime == REVERSE(@ime))
- SET @izlaz = 'Palindrom';
- ELSE
- SET @izlaz = REVERSE(@ime);
- PRINT @izlaz;
- EXEC palindrom @ime = 'neko_ime';
- CREATE TRIGGER palindrom
- ON racuni<mbr>
- FOR INSERT
- AS
- DECLARE @broj INT;
- DECLARE @kupac CHAR(100);
- SELECT @broj = broj, @kupac = kupac
- FROM inserted;
- UPDATE racuni<mbr> SET kupac = REVERSE(kupac);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement