Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a trigger fails
Message
 
 
À
23/11/2021 08:10:42
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01682776
Message ID:
01682794
Vues:
27
>>https://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-to-refresh-the-local-intellisense-ca/
>
>Thanks, I have seen a related situation where the first command creates a field but SSMS won't run it because it already detects that the second command makes relation to a field which does not already exist. When that happens, I have to split the command into two windows. I then execute the first one so the field is created. Then, I can execute the second one successfully.

Yes, this is called deferred name resolution. Read this blog recently on this exact topic

https://www.littlekendra.com/2021/10/18/deferred-name-resolution-in-sql-server-stored-procedures-views-functions/
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform