Ars Technica

TSQL: IF EXIST statement as conditional check

Ok, I'm thinking there must be a better way to do this. I want to see if today's date exists in a table, if it does NOT then I want to do "stuff". Code: IF NOT EXISTS (SELECT COUNT(ExecutionDate) FROM ...
Ars Technica

TSQL: Dealing with NULL parameter passing for WHERE statement

SELECT * FROM tbl_Students WHERE FirstName LIKE '%' + @FirstNameString + '% AND LastName LIKE '%' + @LastNameString + '% Anyway, I want the option for the user to specify one or both. So they can ...