Stored Procedure Syntax

[jw2000]

Inside my stored procedure, I would like to store the pilotActiveSinceTimestamp into the variable @myActiveSinceTS. If @myActiveSinceTS is null, I would like to update the pilotActiveSinceTimestamp to date(). What is the syntax to do this?

@myActiveSinceTS = select pilotActiveSinceTimestamp from pilot where pilotId = @pilotId ??

 

[viper1777]

Hi,
This code will select the time stamp from the database and if it is null assign it to the current date/time.

If I remeber rightly there are cleaner ways to do this, but this is the easiest.

DECLARE @myActiveSinceTS TIMESTAMP

select @myActiveSinceTS=pilotActiveSinceTimestamp from pilot where pilotId = @pilotId

IF @myActiveSinceTS IS NULL 
BEGIN
 SET @myActiveSinceTS = CONVERT(TIMESTAMP,GETDATE())
END

--Display the Variable
--SELECT @myActiveSinceTS

Thanx!

Dave Shaw
History admires the wise, but elevates the brave. - Edmund Morris

 

[jw2000]

Got it. Thank you!