Hi,I have this CAML Query for the calendar date. Initially it uses as query value.
But after I browse through the forums I use SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Today) to make sure the system pass the correct date andtime value which is not based on UTC time. 2012-01-30T00:00:00ZBut after I made that changes the system returning all the values even if it does not overlap with the given date.I am wondering do I need to make any changes toeventsQuery.CalendarDate = queryDate;Which the queryDate is in 12:00:00 AM format. When I look through the SQL Profiler the Date was quite off for this.
The date becomes@L4DTP='2013-01-29 16:00:00',@L5DTP='2011-01-29 16:00:01' which is 3 years apart.
Converting Access Database Objects (AccessToSQL). 3 minutes to read.In this articleAfter you have added Access databases and connected to SQL Server or SQL Azure, SSMA displays metadata for Access and SQL Server or SQL Azure database objects. You can now select Access database objects, and then convert the schemas into SQL Server or SQL Azure schemas. The Conversion ProcessConverting database objects takes the object definitions from the Access metadata, converts them into equivalent Transact-SQL syntax, and then loads this information into the project. You can then view the SQL Server or SQL Azure objects and their properties by using SQL Server or SQL Azure Metadata Explorer. ImportantConverting objects does not create the objects in SQL Server or SQL Azure.
It only converts the object definitions and stores the information in the SSMA project.During the conversion, SSMA prints status to the Output pane, and error, warning, and informational messages to the Error List pane. Use this information to determine whether you need to modify your Access databases or your conversion process to obtain the desired conversion results. You can also use the information in the topic to determine what will and will not be converted. Setting Conversion OptionsBefore converting objects, review the project conversion options in the Project Settings dialog box. By using this dialog box, you can set how SSMA converts indexed memo columns, primary keys, foreign key constraints, timestamps, and tables without indexes.
Caml Query Sharepoint Example
For more information, see Conversion ResultsThe following table shows which Access objects are converted, and the resulting SQL Server or SQL Azure objects: Access ObjectResulting SQL Server Objecttabletablecolumncolumnindexindexforeign keyforeign keyqueryviewMost SELECT queries are converted to views. Other queries, such as UPDATE queries, are not migrated.SELECT queries that take parameters are not converted, nor are cross-tab queries.reportnot convertedformnot convertedmacronot convertedmodulenot converteddefault valuedefault valueallow zero length column propertycheck constraintcolumn validation rulecheck constrainttable validation rulecheck constraintprimary keyprimary keyConverting Access ObjectsTo convert Access database objects, you first must select the objects you want to convert, and then have SSMA do the conversion.