Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. DECLARE @imie varchar(50)
  2. SELECT @imie='Damian'
  3. IF NOT EXISTS (select ename from emp where ename=@imie)
  4. BEGIN
  5. INSERT INTO emp (empno, ename, sal) VALUES (6666, @imie, 1000)
  6. PRINT 'Wstawiono '+@imie+'a'
  7. END
  8. ELSE
  9. PRINT +@imie+' juz istnieje'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement