Code
#region cross-site query
//SPSiteDataQuery q = new SPSiteDataQuery();
////q.Lists = "<Lists BaseType='0'/>";
//q.Lists = "<Lists BaseType='0'><List ID='09a12e10-015b-4326-833d-7e6c8783f7e2' /><List ID='2905c91a-3620-4e4d-94a1-97670128ebac'/></Lists>";
//q.Query = "<Where><And><Gt><FieldRef Name='ExpiryDate' /><Value Type='DateTime'>" + startDate.ToString("yyyy-MM-dd") + "T00:00:00Z</Value></Gt><Leq><FieldRef Name='ExpiryDate' /><Value Type='DateTime'>" + endDate.ToString("yyyy-MM-dd") + "T00:00:00Z</Value></Leq></And></Where><OrderBy><FieldRef Name='ExpiryDate' /></OrderBy>";
//q.Webs = "<Webs Scope='SiteCollection' />";
//q.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='ID' /><FieldRef Name='URL' /><FieldRef Name='Location' /><FieldRef Name='Position' /><FieldRef Name='ExpiryDate' />";
//q.RowLimit = 1000;
//DataTable dt = web.GetSiteData(q);
//foreach (DataRow row in dt.Rows)
//{
// url = row["URL"].ToString();
//}
#endregion
#region cross-site query
//SPSiteDataQuery q = new SPSiteDataQuery();
////q.Lists = "<Lists BaseType='0'/>";
//q.Lists = "<Lists BaseType='0'><List ID='09a12e10-015b-4326-833d-7e6c8783f7e2' /><List ID='2905c91a-3620-4e4d-94a1-97670128ebac'/></Lists>";
//q.Query = "<Where><And><Gt><FieldRef Name='ExpiryDate' /><Value Type='DateTime'>" + startDate.ToString("yyyy-MM-dd") + "T00:00:00Z</Value></Gt><Leq><FieldRef Name='ExpiryDate' /><Value Type='DateTime'>" + endDate.ToString("yyyy-MM-dd") + "T00:00:00Z</Value></Leq></And></Where><OrderBy><FieldRef Name='ExpiryDate' /></OrderBy>";
//q.Webs = "<Webs Scope='SiteCollection' />";
//q.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='ID' /><FieldRef Name='URL' /><FieldRef Name='Location' /><FieldRef Name='Position' /><FieldRef Name='ExpiryDate' />";
//q.RowLimit = 1000;
//DataTable dt = web.GetSiteData(q);
//foreach (DataRow row in dt.Rows)
//{
// url = row["URL"].ToString();
//}
#endregion
附:
在线sql转query
http://www.spsprofessional.com/sqlcaml.aspx
CAML Query Builder V2(query生成调试工具)
http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1315