HI,
I have a simple Stored Proc that has a single parameter passed. If the parameter is Null the SP should return all records else it should return the record for the passed parameter. BUT it fails on passing Null. I have used the exact same
format for other SP's which work fine, but never passing a Null.
Anyone got suggestions?
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Phillip J Seaman>
-- Create date: <05/17/2011>
-- Description: <Gets ALL Vessel names OR single By ID value>
-- ======================== ...
Go to the complete details ...