Resolution
When you create a stored procedure, SQL Server first parses the code to check for syntax errors. If the code passes the parsing stage, successfully, SQL Server attempts to resolve the names it contains. The resolution process verifies the existence of object and column names, among other things. If the referenced objects exist, the resolution process will take place fully–that is, it will also check for the existence of the referenced column names.
If an object name exists but a column within it doesn’t, the resolution process will produce an error and the stored procedure will not be created. However, if the object doesn’t exist at all, SQL Server will create the stored procedure and defer the resolution process to run time, when the ...
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
