![]() ![]() Write SQL statements in this stored procedure to update the appropriate records based on these inputs. Potential solution: Create a stored procedure that accepts employee ID, verification status and employee notes. Update employee notes table for these employee with the values in the third column of the Excel file. Update employee’s verification records using the ID’s listed in the Excel file with the values found in the second column of the same Excel file. While the above write-up is for a straightforward bulk insert scenario, you are not limited to just that. But now that you know how to use Excel formulas, you can also add the INSERT part of the SQL statement into your formula if you have more than 1000 records to be inserted. Tip: You may be limited to a maximum of 1000 rows per insert statement as documented here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |