Friday, 24 June 2016

Deferred name resolution in sql server

When a Stored procedure is created it is syntactically checked and if there is no error then SP is created. Sp is stored on the SYS.SQL_Module.
  
See in the current database Emp table is not there. But still the SP is created successfully.
  
See the Stored Procedure

When we executing this Sp we will get the error
  
Getting Error like “Invalid Object Name”
This is the run time error.

This Scenario is known as Deferred Name Resolution.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts