9/4/2023 0 Comments Sql server create tableSELECT 4, 'DEWANE PAUL', 'PROGRAMMER', 'IT', GETDATE() SELECT 3, 'GREEN FIELD', 'ACCOUNTANT', 'ACCOUNTS', GETDATE() SELECT 2, 'MIKE PEARL', 'SENIOR ACCOUNTANT', 'ACCOUNTS', GETDATE() SELECT 1, 'CHIN YEN', 'LAB ASSISTANT', 'LAB', GETDATE() INSERT INTO Employee (EmpID, EmpName, Designation, Department, JoiningDate) (6, 'PLANK OTO', 'ACCOUNTANT', 'ACCOUNTS', GETDATE()) (4, 'DEWANE PAUL', 'PROGRAMMER', 'IT', GETDATE()), (3, 'GREEN FIELD', 'ACCOUNTANT', 'ACCOUNTS', GETDATE()), (2, 'MIKE PEARL', 'SENIOR ACCOUNTANT', 'ACCOUNTS', GETDATE()), (1, 'CHIN YEN', 'LAB ASSISTANT', 'LAB', GETDATE()), (EmpID, EmpName, Designation, Department, JoiningDate)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |