CREATE proc dbo.CheckForNull @i int
as
begin
if @i is null
raiserror('The value for @i should not be null', 15, 1) -- with log
end
GO
SOURCE:
http://stackoverflow.com/questions/330303/how-to-restrict-null-as-parameter-to-stored-procedure-sql-server
Posts
What the heck is a `\\.\nul` path and why is it breaking my Directory Files
Lookup?
-
[image: Null Device Banner]
In the last few months my Markdown Monster Application Insights log has
been inundated with a hard failure for lookups of a \...
1 month ago
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!