CREATE PROCEDURE UpdateRecord

@MessageID varchar(254) = DEFAULT,
@FilerCode varchar(3) = DEFAULT,
@EntryNo varchar(9) = DEFAULT

AS

UPDATE table SET
		MessageID = @MessageID,
		EntryNo = @EntryNo,
		FilerCode = @FilerCode

WHERE FilerCode = @FilerCode and EntryNo = @EntryNo
GO

quote:

---

Originally posted by Munchausen

I'm working on a database and I'm not too familiar with using the default keyword.

Here's a partial example of a stored procedure that resides in the database.

CREATE PROCEDURE UpdateRecord

@MessageID varchar(254) = DEFAULT,
@FilerCode varchar(3) = DEFAULT,
@EntryNo varchar(9) = DEFAULT

AS

UPDATE table SET
		MessageID = @MessageID,
		EntryNo = @EntryNo,
		FilerCode = @FilerCode

WHERE FilerCode = @FilerCode and EntryNo = @EntryNo
GO

As it was explained to me, the parameters are set to DEFAULT so that if the update tries to update a field with NULL instead of data, it will instead preserve the original data and not update the field.

Is it as simple as that? Or is DEFAULT defined somehow in the database?

Thanks in advance!

---

quote:

---

Originally posted by Munchausen

I kind of thought I might be.

So in the case of the example I provided, all of the parameters would be set to whatever the default value for the column is, as established during table creation?

---

@MessageID varchar(254) = DEFAULT,
@FilerCode varchar(3) = DEFAULT,
@EntryNo varchar(9) = DEFAULT

@MessageID varchar(254),
@FilerCode varchar(3),
@EntryNo varchar(9)

quote:

---

Originally posted by Munchausen

Hmmm... I'm just not getting it, yet. I guess the question I have to ask is:

How does

@MessageID varchar(254) = DEFAULT,
@FilerCode varchar(3) = DEFAULT,
@EntryNo varchar(9) = DEFAULT

differ from

@MessageID varchar(254),
@FilerCode varchar(3),
@EntryNo varchar(9)

I'm sorry if this seems like a stupid question. I'm sure once I understand it I'll slap my forehead.

---