delaring a null parameter

Question

Post reply

delaring a null parameter

marclas

Right there with Babe

Points: 779
More actions
May 8, 2012 at 4:21 am

#255610

HI
how can i set a null value when declaring a parameter
example
CREATE PROCEDURE dbo.GestionStatutDossier
-- Add the parameters for the stored procedure here
@StaId int NULL,
@DosID uniqueidentifier,
@staDate datetime,
@staBL nvarchar (50),
@staCRprod nvarchar (50)
AS
it always send back an error
thkx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

you need to set the variable = null

CREATE PROCEDURE dbo.GestionStatutDossier

-- Add the parameters for the stored procedure here

@StaId int = NULL,

@DosID uniqueidentifier,

@staDate datetime,

@staBL nvarchar (50),

@staCRprod nvarchar (50)

AS

marclas Right there with Babe Points: 779 More actions · Answer 2

marclas

Right there with Babe

Points: 779

May 8, 2012 at 4:56 am

#1484426

thanks!!

It OK

vinu512 SSCoach Points: 15729 More actions · Answer 3

marclas (5/8/2012)
HI
how can i set a null value when declaring a parameter
example
CREATE PROCEDURE dbo.GestionStatutDossier
-- Add the parameters for the stored procedure here
@StaId int NULL,
@DosID uniqueidentifier,
@staDate datetime,
@staBL nvarchar (50),
@staCRprod nvarchar (50)
AS
it always send back an error
thkx

+1

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉