Stored Procedures

Snippets

21

Within a stored procedure use an IF STATEMENT to check a parameter for a NULL VALUE

if( @CustomFieldID is null)
begin
   print 'NULL VALUE - SKIP IT'
end
else
begin
 print 'PARAMETER HAS VALUE'

end

Posted in: Stored Procedures

Post Rating

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.