Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT CASE WHEN EXISTS(SELECT 1 FROM Configuration WHERE Name = 'NameOfConfiguration')
  2. THEN (SELECT Data FROM Configuration WHERE Name = 'NameOfConfiguration') ELSE
  3. 'Default Value' END
  4.  
  5. SELECT CASE WHEN COUNT(1) > 0 THEN MIN(Data) ELSE 'Default Value' END FROM
  6. Configuration WHERE Name = 'NameOfConfiguration'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement