OD jutros u 5 sam poceo da se igram proverio sam sve i problem je da rade zajedno
Ovo radi OK
Code:
SELECT ID, Title, keyword, jobtype, DateCreated, location
FROM Test
WHERE (@Title IS NULL) OR
(Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
(keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
(jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
(location LIKE '%' + @location + '%')
Ovo radi OK
Code:
SELECT ID, Title, keyword, jobtype, DateCreated, location
FROM Test
WHERE (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')
Ovo ne radi OK, vraca sve
Code:
SELECT ID, Title, keyword, jobtype, DateCreated, location
FROM Test
WHERE (@Title IS NULL) OR
(Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR
(keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR
(jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR
(location LIKE '%' + @location + '%') AND (DateCreated BETWEEN '1/10/2013' AND '1/12/2013')
To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa
https://youtu.be/DLe358DPGXU