EXEC updateManufacturer @Username = 'test12', --insert username set for manufacturer @Password = 'pass1', --insert password set for manufacturer @NewManufacturerName = 'Hill and Bikes', -- Manufacturer Name @NewCountryCode = '+44', -- Country Code to be updated (2 or 3 digits) @NewContactNumber = '1234567890', -- Number to be update (10 digits) @NewAddress = '12 Testing Street, London, UK'; --New address (TEXT) follwed by a city