What is deferred name resolution in SQLs server?
While creating the procedure SQL server only checks the syntax of the statements not the existence of the object. I.e. a procedure can be created using a table name in between which doesn't exist. The object existence is checked while executing the procedure, in case if the object is not present then it will give an error of invalid object. This functionality is used in case you want to deploy the procedure and table will be deployed afterwards. Functions in SQL server do not support this feature.