Database

DECLARE @ProductID NVARCHAR(10)

SET @ProductID = null

IF @ProductID IS NOT NULL AND @ProductID <> ''
BEGIN
  PRINT 'Started 1st test'
END
ELSE
BEGIN
  PRINT 'Failed 1st test'
END
-- Will print Failed 1st test

SET @ProductID = ''
IF @ProductID IS NOT NULL AND @ProductID <> ''
BEGIN
  PRINT 'Started 2nd test'
END
ELSE
BEGIN
  PRINT 'Failed 2nd test'
END
-- Will print Failed 2nd test

SET @ProductID = 'Hi'
IF @ProductID IS NOT NULL AND @ProductID <> ''
BEGIN
  PRINT 'Started 3rd test'
END
ELSE
BEGIN
  PRINT 'Failed 3rd test'
END
-- Will print Started 3rd test

select u.UserID, <br />
[value] = case when i.ip = '204.15.0.0' then n.Name else i.ip end,<br />
[type] = case when i.ip = '204.15.0.0' then 1 else 2 end<br />
from Players u<br />
left join IPs i on u.userID = i.UserID<br />
right join n Names on u.UserID = n.UserID <br />
Where i.ip = '204.15.0.0' or (i.ip like '204.15.%' and n.Name = 'masterSin')