codeId | codeName | codeType | code | note |
1 | CASE | SQL | select fname, lname ,
CASE senior
WHEN 1 THEN 'Granted Onsite Training'
WHEN 2 THEN 'Granted Online Training'
END AS senior
from student | you can write your own note |
2 | Insert code | SQL | insert code (code)
values (N'select fname, lname ,
CASE senior
WHEN 1 THEN ''Granted Onsite Training''
WHEN 2 THEN ''Granted Online Training''
END AS senior
from student') | How to save sql code in db |