In one of my training
class, a developer asked me “when he creates any Stored Procedure with table does not exist in database, the SP
will creates without any error, while executing it gives run time error.
However, if there is any valid table from database is referenced in SP with
incorrect column name it will not let user create SP and gives error” why?.
SQL Server allows for Transact-SQL stored procedures, triggers, and
batches to refer to tables that do not exist at compile time. This ability
is called deferred name resolution.
Follow the link for more detail: http://msdn.microsoft.com/en-us/library/ms190686(v=sql.110).aspx
No comments:
Post a Comment