CREATE FUNCTIONs
Create three functions to help solve the business case:
- Convert distance from miles to kilometers.
- Convert currency based on exchange rate parameter.
(These two functions should return a numeric value with precision of 18 and 2 decimal places.) - Identify the driver shift based on the hour parameter value passed.
Questo esercizio fa parte del corso
Writing Functions and Stored Procedures in SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create the function
___ ___ dbo.ConvertMileToKm (___ numeric(18,2))
-- Specify return data type
___ numeric(18,2)
AS
BEGIN
RETURN
-- Convert Miles to Kilometers
(___ ___ * 1.609)
END;