Parameter in SQL Server Stored Procedure
Posted on 2008-06-26
I have the following lines in a stored procedure:
CREATE PROCEDURE [dbo].[spBct_PhnxMrtgee_DeleteEndorsement]
(@PolicyNumber varchar(20), @EndorsementIdentifier varchar(3), @SequenceNumber smallint null, @PolicyDateTime datetime)
I have a database field that is defined as smallint NULL in the database called SEQUENCE_NUMBER.
When I am creating the parameter above, you can see may attempt to define this. I am getting errors. Does anyone know the correct syntax for this?