How to distinguishing variable uppercase characters?

Asked Nov 05 '15 at 08:55

Active Nov 05 '15 at 08:58

Viewed 20 times

I have query:

DECLARE @P_Param nvarchar(100) = 'HELLO WORLD'
select @p_param

When @P_Param <> @p_param but it had return result?

I don't want it.

I want it have notice error!

I using sql server 2014.

Plase help me!

edited Nov 05 '15 at 08:58

jarlh

asked Nov 05 '15 at 08:55

mr.BaoNC

1

You mean you want case sensitive variable names? – jarlh Nov 05 '15 at 08:59
why you want it have notice error? – Pedram Nov 05 '15 at 09:01
*The SQL Keywords are case-insensitive ( SELECT , FROM , WHERE , etc), but are often written in all caps. However in some setups table and column names are case-sensitive.* – Pedram Nov 05 '15 at 09:04
2

http://stackoverflow.com/questions/6559254/case-sensitive-variables-in-sql-server – iman kazemi Nov 05 '15 at 09:07

0 Answers0