Rukayat Balogunrukayat-balogun.hashnode.dev·Aug 8, 2022Functions for Manipulating Data in SQL ServerImplicit conversion When SQL wants to compare values, it checks if they are the same data type. In cases where they are not, it tried to convert from one type to another(IMPLICIT) and if this fails , you need to do an EXPLICIT (when the developer exp...SQL
Rukayat Balogunrukayat-balogun.hashnode.dev·Jul 29, 2022DATEs in SQLDATEADD(): Add or subtract datetime values and the result is a date DATEADD(DATEPART, number, date] DATEPART: Unit of measurement (DD,MM etc) number: An integer value to add or subtract date: A datetime value -- Return the DeliveryDate as 5 days aft...SQL
