首页新闻找找看学习计划

这两者之间有什么区别!

0
悬赏园豆:5 [待解决问题]

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)

水嫩小白菜的主页 水嫩小白菜 | 初学一级 | 园豆:3
提问于:2012-09-26 18:33
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册