SQL Server deprecated Functions effect
Deprecated functions / features work fine in your current SQL Server Version. It is just a hint for you that in future versions of the SQL Server these functions will be dissmissed or replaced by others.
It doesn't mean that these functions are removed in the very next version, but it is planned in long term to remove them.

A list of deprecated features is available here: Microsoft SQL Server 2016 Deprecated features