Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators

table. For each administrator:

Create a login ID that consists of the administrator$$s first and last name with no space between.

Set a password of $$TempPa$$$1$ for the new login ID$.$

Set the default database for the new login ID to MyGuitarShop.

Create a user for the login ID with the same name as the login ID$.$

Assign the user to the OrderEntry role you created in exercise $1.$

$($Hint: Begin the script by declaring two variables, @DynamicSQL and @LoginName.$)$