I'm using sql 2000 and Access 2003. I trying to query on a date field. I need
to display any records from the current date and greater then. What criteria
do I use to display these records?
Hi Paul,
For SQL Server:
SELECT Column1, Column2, ...
FROM YourTable
WHERE TheDate >= DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), 0)
For Access, I recommend posting to an Access group.
Re: Strange Recordset/Query Problem ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ... (microsoft.public.inetserver.asp.general)
Strange Recordset/Query Problem ... Access 2000 database to a SQL Server 2000 database. ...display in SQL Server. ... the IF statement executes the first condition as it should, ... (microsoft.public.inetserver.asp.general)
MSHFlexgrid not displaying data from ADO data control ... if I put it onto a clients machine none of the ...MSHflexgrids display any data. ... The MSHflexgrids data sources are ADO data controls which are ... The SQL Server uses windows network authentication to allow access and I ... (microsoft.public.vb.general.discussion)
Re: Text below an image ... > sql server db underneath the image. ... > So you have a picture and underneath its dimensions. ... load it from there into the image class.... >> Im gonna display a list of images in an aspx page from sql server Db.Each ... (microsoft.public.dotnet.framework.aspnet)
Re: FTS query performance on SQL 2005 ... Basically what i do is bank on the fact that it is rare for most people to ... believe this is because the full resultset is returned from the FTE back ...SQL Server, and then the count is taken on that. ... but I'd like to also display "Showing results ... (microsoft.public.sqlserver.fulltext)
