0

In the procedure we are just returning the value of the parameter. How ever the results are different for the following queries. Why does this hapen?

   exec GetItemQtyOnHand @itemCode=N'​173YU25HNBRMSB'

   exec GetItemQtyOnHand @itemCode='​173YU25HNBRMSB'

enter image description here

Thom A
  • 88,727
  • 11
  • 45
  • 75
Sin
  • 1,836
  • 2
  • 17
  • 24
  • Does this answer your question? [What is the meaning of the prefix N in T-SQL statements and when should I use it?](https://stackoverflow.com/questions/10025032/what-is-the-meaning-of-the-prefix-n-in-t-sql-statements-and-when-should-i-use-it) – Thom A Sep 18 '20 at 08:06
  • 3
    Side note, the first character you have is a [Unicode Character 'ZERO WIDTH SPACE' (U+200B)](http://www.fileformat.info/info/unicode/char/200b/index.htm). – Thom A Sep 18 '20 at 08:17
  • Adding to @Larnu 's comment, characters in non-Unicode literals that do not exist in the collation code page are mapped to a fallback character or `?` when no similar character exists in the code page. – Dan Guzman Sep 18 '20 at 08:59
  • sp body please. – Shahbaz Sep 19 '20 at 06:38
  • its just returning the param value – Sin Sep 22 '20 at 01:26

0 Answers0