Mavengers

Developer's Blog

Showing posts with label ISNULL. Show all posts
Showing posts with label ISNULL. Show all posts

Monday, July 13, 2015

SQL check null in where condition

 where (ISNULL(NULLIF(@tptCode,''),N'') =N'' OR msl.tpt_cd= @tptCode)     
Posted by Unknown at 5:23 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: ISNULL, NULLIF, sql
Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ▼  2016 (12)
    • ▼  October (3)
      • Angular Token Authentication Part 2
      • Angular Token Authentication Part 1
      • AngularJS Cheat Sheet
    • ►  March (4)
    • ►  February (5)
  • ►  2015 (309)
    • ►  December (1)
    • ►  November (7)
    • ►  October (1)
    • ►  September (16)
    • ►  August (8)
    • ►  July (10)
    • ►  June (20)
    • ►  May (82)
    • ►  April (91)
    • ►  March (10)
    • ►  February (62)
    • ►  January (1)
  • ►  2014 (267)
    • ►  December (4)
    • ►  November (20)
    • ►  October (3)
    • ►  August (25)
    • ►  July (62)
    • ►  June (34)
    • ►  May (79)
    • ►  April (36)
    • ►  March (4)

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.