A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE FUNCTION myDateCompare(@startDate DateTime, @EndDate DateTime) RETURNS @resultDate AS BEGIN WITH datesFunc(date1, date2) AS ( SELECT CAST(date1 AS DATETIME), CAST(date2 AS DATETIME) ) SELECT CASE WHEN CAST(@startDate AS DATE) <= CAST(@EndDate AS DATE) THEN 'Start Date Cannot Start Before End Date' ELSE SELECT CASE WHEN CAST(@startDate AS DATE) <= CAST(getDate AS DATE) THEN 'Start date cannot be less than current date' ELSE 'Y' END FROM datesFunc RETURN; END;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Logical Operator should return Integer value in SSIS||9||37|
|SQL Server Express automatically execute SQL or SP||8||34|
|8 hour Continual coverage based on Time in and Time Out||9||20|
|Cannot connect to SQL express 2008 R2 installed on Server 2016||5||19|