USE [eoaDB]
GO
/****** Object: StoredProcedure [dbo].[ProcGetTodayAttendance] Script Date: 09/25/2012 18:03:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[ProcGetTodayAttendance]
@childID int
AS
SELECT u_attendance.fDate AS 当前日期, d_DictionaryItem.ItemCHName AS 考勤类型
FROM u_attendance INNER JOIN
d_DictionaryItem ON u_attendance.type = d_DictionaryItem.ID
WHERE (u_attendance.userId = @childID)

select a.number,b.courseName,c.courseContent,c.fDate, c.status from c_restTime as a inner join d_Course as b on (a.Id=b.Id) inner join c_Homework as c on (c.Id=b.Id)