declare @temp1 varchar(max)='naveen'
declare @temp2 varchar(max)='NaveeN'
if(@temp1=@temp2 COLLATE Latin1_General_CS_AS)
print 'Same'
else
print 'different'
--=======================================
IF EXISTS(select UserName from tbl_Users where UserName='naeven' COLLATE Latin1_General_CS_AS)
print 'Exists'
else
print 'Not Exists'
Thursday, May 24, 2018
Case Sensitive String Comparison Sqlserver
Subscribe to:
Post Comments (Atom)
javascript Filter/index off
var family = [{"name":"Jack", "age": 26}, {"name":"Jill", "age"...
-
A3+C3 VLOOKUP(G3,$A$3:$B$10,2) sum Product Quantity Count Result 1 Mobile 2 1 Mobile 3 Keyboard 3 2 Mobile 6 TV 1 3 ...
-
EF CORE CLI > dotnet ef database update MyFirstMigration. Scaffold-DbContext Command Use Scaffold-DbContext to create a model based ...
No comments:
Post a Comment