Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. ...
  2. cmd.Parameters.Add(new SqlParameter("@aa", SqlDbType.Int));
  3. cmd.Parameters["@aa"].Value = aaValue;
  4. cmd.Parameters.Add(new SqlParameter("@bb", SqlDbType.Int));
  5. cmd.Parameters["@bb"].Value = bbValue?? (object)DBNull.Value;
  6. reader = cmd.ExecuteReader(); ...
  7.  
  8. SELECT ID
  9. FROM MyTable
  10. WHERE aa = @aa AND (bb IS NULL OR bb = @bb)
  11.  
  12. SELECT ID from MyTable where aa = @aa and (@bb is null OR bb = @bb)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement