API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 4th, 2015
172
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
raw download clone embed print report
  1. DECLARE @Source UNIQUEIDENTIFIER
  2. DECLARE @Dest UNIQUEIDENTIFIER
  3.  
  4. SET @Source = 'd9aef4d6-4d92-4da0-8920-1ae790c7b21e'
  5. SET @Dest = '767cbc04-0e94-449a-9bcd-1623356bdeec'
  6.  
  7. INSERT INTO BDEntityFormFields (
  8. ID
  9. ,EntityFormID
  10. ,FieldType
  11. ,FieldName
  12. ,SortOrder
  13. ,Instructions
  14. ,Label
  15. ,MaxLength
  16. ,Required
  17. ,Item_No
  18. ,LastUpdate
  19. ,LastUpdated_By
  20. ,RecordRevLevel
  21. ,Created
  22. ,Created_By
  23. ,TEXT
  24. ,ListValues
  25. ,ContainerFormFieldID
  26. ,ColumnLength
  27. )
  28. SELECT NEWID()
  29. ,@Dest
  30. ,--EntityFormID,
  31. FieldType
  32. ,FieldName
  33. ,SortOrder
  34. ,Instructions
  35. ,Label
  36. ,MaxLength
  37. ,Required
  38. ,Item_No
  39. ,LastUpdate
  40. ,LastUpdated_By
  41. ,RecordRevLevel
  42. ,Created
  43. ,Created_By
  44. ,TEXT
  45. ,ListValues
  46. ,ContainerFormFieldID
  47. ,ColumnLength
  48. FROM BDEntityFormFields
  49. WHERE EntityFormID = @Source
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!