1
I have a specific table in the database, in it I keep information of classes that are created, swimming classes, futsal classes, weight training classes and so on, it is already in use and with several classes already registered, but now I need the following functionality in the system, I needed to add a new column , that will keep the time of tolerance of the student in the lobby of the club, for example if a swimming class is created, will be registered in it a tolerance time in minutes, for example 10 minutes, it means that the student can only arrive up to 10 minutes before class, if he arrives 20 minutes before, access is blocked. well the problem is, as the classes that already exist have not yet made this setting, by default I will leave to be classes this column with the value of 15 (in case 15 minutes), the question is, how do I make a script that instead of leaving the information in the classes that already exist as "null" leave filled 15 for example ?
am using sqlserver2017
Thanks Angelo
– João Ávila