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.
Diese Übung ist Teil des Kurses
<Kurs>Writing Functions and Stored Procedures in SQL Server</Kurs>Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- 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;