Case Sensitive String Match (Compare) in SQL Server

1. Both fields Case Senstive match

SELECT * FROM Users 
WHERE Username = 'mudassar' COLLATE SQL_Latin1_General_CP1_CS_AS 
AND Password = '12345' COLLATE SQL_Latin1_General_CP1_CS_AS

2. Only Password Case Sensitive Match

SELECT * FROM Users 
WHERE Username = 'mudassar'
AND Password = '12345' COLLATE SQL_Latin1_General_CP1_CS_AS