Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing NULL to a Stored Procedure
Message
From
28/08/2003 14:55:55
Sergey Berezniker
New York, United States
 
 
To
28/08/2003 14:48:37
Margaret Gillon
Chromalloy
Anaheim, California, United States
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: Passing NULL to a Stored Procedure
Miscellaneous
Thread ID:
00824318
Message ID:
00824319
Views:
22
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform