DECLARE @datecurrent datetime2 set @datecurrent = CAST(getdate() AS smalldatetime)
DECLARE { @LOCAL_VARIABLE[AS] data_type [ = value ] }
DECLARE @COURSE_ID AS INT, @COURSE_NAME VARCHAR (10);