5/26/2023 0 Comments Turn off spell check sql severYou could get around this in a few ways, including: There is no setting like SET DEFERRED_NAME_RESOLUTION OFF though it has been asked for:Īnd there is no setting like IGNORE ALL_RESOLUTION. (And how he'd like the polar opposite of what you're after - you want to allow anything to compile regardless of existence, and he wants every single column or table to be checked.) See Erland's ideas for SET STRICT_CHECKS ON to get some ideas of the places this works and the places it breaks: This is the double-edged sword of deferred name resolution - SQL Server gives you the benefit of the doubt in some cases, but not all. You cannot create stored procedures that reference columns that don't exist yet in objects that do already exist. You can create stored procedures that reference objects that don't exist yet (e.g.
0 Comments
Leave a Reply. |