What is deferred name resolution in SQLs server?

763    Asked by KevinTaylor in SQL Server , Asked on Jan 14, 2020
Answered by Rachit Gupta

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.


Your Answer

Interviews

Parent Categories