Difference between IsNumeric and Bit in Sql Server?

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 1406 | Points: 40
Answer:

Isnumeric is Sql Server Function whereas Bit is a DataType in sql Server.Both returns 0 or 1 value.But Bit datatype has additional value called Null.

For IsNumeric 1 means supplied value is integer value and 0 means value is not a numeric value.
For Bit 1 means True and 0 means False.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response