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.
Latihan ini merupakan bagian dari kursus
Writing Functions and Stored Procedures in SQL Server
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- 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;