SQL Updating a counter

| No Comments | No TrackBacks
Say you have a nvarchar field that stores course numbers and you need to auto increment it

DECLARE @counter int
SET        @counter = 100
                   UPDATE Courses
                   SET        Number = CONVERT(INT, @counter + 1), @counter = @counter + 1


| No Comments | No TrackBacks
Keynote by David Wiley was very interesting. Are we keeping up at Penn State?  His talk centered on how content is not exclusively the purview of  higher ed but can be gathered from many sources. Students shouldn't have to wait for us to have class but content should be available any time any place.

What are the implications for the Testing Center? Should we be offering drop in testing? How can we change assessment practices so instructors are not as concerned about academic integrity issues.

Tag Cloud

Find recent content on the main index or look in the archives to find all content.