I have an Access ADP file created in Access 2000. It contains a report that has a stored procedure as its Record Source, with the appropriate Input Parameters specified in Properties. Basic stuff, and it works fine...
Recently, I removed one of the parameters in the stored procedure and also...
I need to convert some dates to yyyy-mm-dd format for XML. I know the following:
convert(varchar,GetDate(),126) --> 2004-06-02T16:13:49.293
My question is, how do I get just the yyyy-mm-dd component without the time?
Thanks for any suggestions!
Can anyone recommend a good one? I just want to be able to compare stored procedures, UDFs, tables, etc. across two databases and get a report of differences.
Thanks...
I use Access 2000 (ADP) as a front end to a SQL Server 2000 database. I read about the FMS Total Access Memo product for adding rich text formatting to memo fields (or text fields in my case), and I immediately got excited about being able to offer this functionality to my users. I purchased the...
I use Access 2000 (ADP) as a front end to a SQL Server 2000 database. I read about the FMS Total Access Memo product for adding rich text formatting to memo fields (or text fields in my case), and I immediately got excited about being able to offer this functionality to my users. I purchased the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.