>Hi, > >In SQL Server, is it possible to define the default of a field to be the return value of a stored procedure? For example how can I say that the default value of field CustomerPK is SP_MyNewId(). > >TIA, > >Alex
If you use a GUID as your PK's you can use the NewID() function as the default value. Make sure your data type is Uniqueidentifier. This is the best key type to use with distributed data.
Yes, Mike is correct, you can use a User Defined Function as a default value in SQL 2000.