Difference between revisions of "DD Class11"
esse quam videri
| Line 18: | Line 18: | ||
) | ) | ||
</sql> | </sql> | ||
| + | |||
| + | ==Uploader/Email==\ | ||
| + | |||
| + | ===Mappath=== | ||
| + | |||
| + | upload permissions | ||
| + | |||
| + | ==HomeWork== | ||
| + | |||
| + | Web Skeleton of your site | ||
| + | |||
| + | Demostate one feature | ||
Revision as of 04:09, 10 April 2007
Sub Query
Course adder example
http://iam.colum.edu/dd/classsource/class8/student.aspx
SQL Subquery
<sql>SELECT CourseID, CourseName, CourseNumber FROM Course WHERE (
CourseID not in
(
SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID
)
) </sql>
==Uploader/Email==\
Mappath
upload permissions
HomeWork
Web Skeleton of your site
Demostate one feature
