code_junkie

Bind a column default value to a function in SQL 2005

Nov 13th, 2011
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. DOC_ID DOC_Order DOC_Name
  2. 1 1 aaa
  3. 2 3 bbb
  4. 3 2 ccc
  5.  
  6. CREATE FUNCTION [dbo].[NEWDOC_Order]
  7. (
  8. )
  9. RETURNS int
  10. AS
  11. BEGIN
  12.  
  13. RETURN (SELECT MAX(DOC_ORDER) + 1 FROM DOC_Documents)
  14.  
  15. END
  16.  
  17. alter table DOC_Order
  18. add constraint
  19. df_DOC_Order
  20. default([dbo].[NEWDOC_Order]())
  21. for DOC_Order
  22.  
  23. Create FUNCTION [dbo].[NEWDOC_Order]
  24. (
  25. )
  26. RETURNS int
  27. AS
  28. BEGIN
  29.  
  30. RETURN (SELECT ISNULL(MAX(DOC_ORDER),0) + 1 FROM DOC_Documents)
  31.  
  32. END
  33.  
  34. [dbo].[NEWDOC_Order]()
Add Comment
Please, Sign In to add comment