Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Stored proc passing parameter value null or 0

Author  Topic 

reddymade
Posting Yak Master

165 Posts

Posted - 2008-07-25 : 14:29:22
How can i validate if parameter has 0 or null value both:
******************************
if @ProgID is not null or 0
******************************

Thank you for the info.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-25 : 14:32:14
if nullif(@ProgID,0) is null
Go to Top of Page
   

- Advertisement -