Skip to content

Instantly share code, notes, and snippets.

@ZhenDeng

ZhenDeng/Check row exists

Created September 17, 2020 06:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ZhenDeng/9532c99d6fae9dc18a7858697b98d08f to your computer and use it in GitHub Desktop.
Save ZhenDeng/9532c99d6fae9dc18a7858697b98d08f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Check row exists
IF NOT EXISTS(SELECT * FROM Isp.DocumentType WHERE Name = 'Withdrawal Travel Ticket')
BEGIN
insert into Isp.DocumentType(Name, SubType, Code, Description, IndexInSubtype) values ('Withdrawal Travel Ticket', 'Withdrawal', 'Withdrawal Travel Ticket', 'Withdrawal Travel Ticket', 0)
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment