Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing NULL to a Stored Procedure
Message
 
 
À
28/08/2003 14:48:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00824318
Message ID:
00824319
Vues:
21
This message has been marked as the solution to the initial question of the thread.
Hi Margaret,

The NULL literal represents null value in SQL Server.
EXEC myspoc 'String', 12345, Null, ...
>I am writing an app in Visual FoxPro. To update my SQL tables I use stored procedures. When sending the parameters into the SP how do I pass a NULL? I can't find documentation on this and I need NULLs in many different tables. Also I can't send in a NULL from the Query Analyzer when I try to execute the SP there. I am on SQLServer2000.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform