|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
|
|
Executed query on SSMS and got result NULL. HUUUHHH.
Didn't read select all that apply and just selected NULL and lost a point.
Don't know how many points I lost by not reading -- select all that apply. May be 30 - 40 points.
My bad. Always repented on answer in hurry.
SQL DBA.
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
|
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Thursday, September 22, 2011 5:50 AM
Points: 684,
Visits: 28
|
|
I tried this with
1. Taking a valid domain and role and got 1 as output
2. Taking a Invalid domain and role and got NULL as output
3. But, when i tried a Valid domain and invalid role, still i'm getting NULL as output.
Anybody help me with a sample scenario, to see 0 as output
|
|
|
|