fix variable or placeholder
I want to do something like that and I wonder if this works:
I want to set a variable like
SET $MyStartDate$ = 2002-01-01
SET $MyEndDate$ = 2002-03-27
and then the sql server should know that when a query like that comes:
WHERE Date between $MyStartDate$ and $MyEndDate$
I use a java application that connects to a MS Access database (through jdbc/odbc)
where all queries are already defined. But these queries should contain those
Do you have an idea if this is possible?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL