Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 create default

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-06 : 17:27:27
Shaik writes "Hi,
Is there anyway we can vary the value in the CREATE DEFAULT statement? I see the syntax as
create default abc as 'PROC' and then this default object will be bind to a column using the sp_binddefault stored procedure.My problem is the value PROC will not be the same all the time.It will vary (it is a char(12) field. For example, for the first time, the value would be 240000000001 the next time it would be 240000000002 and so on).
Help would be greatly appreciated."
   

- Advertisement -