Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. ALTER taable Client
  2. ADD CONSTRAINT FirstName_Check CHECK (DATALENGTH(FirstName) > 0)
  3. GO
  4.  
  5. ALTER TABLE Client
  6. ADD CONSTRAINT LastNamealter taable Client
  7. ADD CONSTRAINT FirstName_Check CHECK (DATALENGTH(FirstName) > 0)
  8. GO
  9.  
  10. ALTER TABLE Client
  11. ADD CONSTRAINT LastName_Check CHECK (DATALENGTH(LastName) > 0 AND LastName NOT IN ('Martyniuk', 'Pudzianowski'))
  12. go_Check CHECK (DATALENGTH(LastName) > 0 AND LastName NOT IN ('Martyniuk', 'Pudzianowski'))
  13. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement