Advertisement
nostradamos

insert username with letters only (using triggers) sql

Feb 2nd, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.55 KB | None | 0 0
  1. CREATE DATABASE sqlprofiles
  2.  
  3. USE sqlprofiles
  4.  
  5. CREATE TABLE users(
  6.     id INT  PRIMARY KEY ,
  7.     username VARCHAR(20)
  8.  
  9. )
  10.  
  11.  
  12. CREATE TRIGGER addusers
  13. ON users
  14. instead OF INSERT,UPDATE
  15. AS
  16. BEGIN
  17.     DECLARE @username VARCHAR(20)
  18.     SET @username=(SELECT username FROM inserted)
  19.     IF PATINDEX('%[0-9]%', @username) =0
  20.         INSERT INTO users (id,username) SELECT id,username FROM inserted
  21.     ELSE
  22.         print 'num detected'
  23.    
  24. END
  25.  
  26.  
  27.  
  28.  
  29. INSERT INTO users (id,username) VALUES(1,'blaba')
  30. INSERT INTO users (id,username) VALUES(2,'blab0da')
  31.  
  32.  
  33. SELECT * FROM users
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement