Default value from stored procedure

[anonim1]

I have a stored procedure named GenerateRandomString, which takes an output parameter and returns a random string of set length.

I have a table in my database where I would like to automatically insert the string returned by the stored procedure as a default value for one of the columns of the table. Unfortunately, I cannot figure out what the syntax is to call this stored procedure for a default value.

Any ideas?

 

[mrdenny]

You can't call a procedure for a default value. Convert the procedure to a function. You can use functions as a default value. Then in order to keep the procedure working, have the procedure call the function.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Luzian]

You can't have default values for stored procedure parameters?

 

[anonim1]

mrdenny,

Thanks for the quick response! Can you help me convert it to a function? I am not familiar with the syntax. Here is my stored procedure:

CREATE PROCEDURE [dbo].[GetRandomGuid] AS
DECLARE @guid varchar(30)
EXEC dbo.GenerateRandomString 1,1,1,null,30,@guid OUT
PRINT @guid

Thanks for your help!

 

[mrdenny]

You'll need to convert GenerateRamdonString into a function. Functions can't call procedures.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com