Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. centers machines
  2. ------- --------
  3. center1 machine1
  4. center2 machine2
  5. center2 machine3
  6.  
  7. operation center1 center2 center3 ...
  8. --------- ------- ------- ------- ...
  9. oper1 ok ok
  10. oper2 ok ok
  11. oper3 ok
  12.  
  13. SELECT operation from dbo.operations where "center" != null
  14.  
  15. cmd.CommandText = string.Format("SELECT operation FROM dbo.Operations WHERE {0} IS NOT NULL", center);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement