Parameter in SQL Server Stored Procedure

I have the following lines in a stored procedure:


GO
CREATE PROCEDURE [dbo].[spBct_PhnxMrtgee_DeleteEndorsement]
(@PolicyNumber varchar(20), @EndorsementIdentifier varchar(3), @SequenceNumber smallint  null, @PolicyDateTime datetime)
AS

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?

THanks,

JD

jamesdean666Asked:
Who is Participating?
 
chapmandewCommented:
try this:

CREATE PROCEDURE [dbo].[spBct_PhnxMrtgee_DeleteEndorsement]
(@PolicyNumber varchar(20), @EndorsementIdentifier varchar(3), @SequenceNumber smallint  = null, @PolicyDateTime datetime)
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
CREATE PROCEDURE [dbo].[spBct_PhnxMrtgee_DeleteEndorsement]
(@PolicyNumber varchar(20), @EndorsementIdentifier varchar(3), @SequenceNumber smallint =  null, @PolicyDateTime datetime)
0
 
jamesdean666Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.