1.UPDATE Advised_Students (in SchoolScheduling DB) for YOUR StudLastName and change your StudentID to your birthdate in the format of MMDDYY. For example, if you were born Feb 2 1985 the value would be 020285. Since this field is an integer, the leading zero will not be included in the updated value.
Chance StudentID to Birthday format MMDDYY
in SQL
Posted
1. UPDATE Advised_Students (in SchoolScheduling DB) for YOUR StudLastName and change your StudentID to your birthdate in the format of MMDDYY. For example, if you were born Feb 2 1985 the value would be 020285. Since this field is an integer, the leading zero will not be included in the updated value.