replaced http://codereview.stackexchange.com/ with https://codereview.stackexchange.com/
Based on my question here here, I have updated my query to take user input so it can be a generic query:
DECLARE @location AS nvarchar(max) = ##location:string##;
SELECT u.Id [User Link], u.Reputation, u.Location
FROM Users u
WHERE lower(u.Location) LIKE lower('%' + @location + '%')
ORDER BY 'Reputation' DESC
Is there something I should be doing differently, or is this good?
Based on my question here, I have updated my query to take user input so it can be a generic query:
DECLARE @location AS nvarchar(max) = ##location:string##;
SELECT u.Id [User Link], u.Reputation, u.Location
FROM Users u
WHERE lower(u.Location) LIKE lower('%' + @location + '%')
ORDER BY 'Reputation' DESC
Is there something I should be doing differently, or is this good?
Based on my question here, I have updated my query to take user input so it can be a generic query:
DECLARE @location AS nvarchar(max) = ##location:string##;
SELECT u.Id [User Link], u.Reputation, u.Location
FROM Users u
WHERE lower(u.Location) LIKE lower('%' + @location + '%')
ORDER BY 'Reputation' DESC
Is there something I should be doing differently, or is this good?
Query to find users from where?
Based on my question here, I have updated my query to take user input so it can be a generic query:
DECLARE @location AS nvarchar(max) = ##location:string##;
SELECT u.Id [User Link], u.Reputation, u.Location
FROM Users u
WHERE lower(u.Location) LIKE lower('%' + @location + '%')
ORDER BY 'Reputation' DESC
Is there something I should be doing differently, or is this good?
lang-sql