Advertisement
Guest User

Untitled

a guest
Jul 18th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.50 KB | None | 0 0
  1. INSERT INTO [Column] ([TableID], [SystemName], [DisplayName], [DisplayOrder])
  2.  
  3.        SELECT [TableID], 'First Name', 'V004', 1 FROM [Table] WHERE TableName = 'Staff'
  4.  
  5. INSERT INTO [Column] ([TableID], [SystemName], [DisplayName], [DisplayOrder])
  6.  
  7.        SELECT [TableID], 'Last Name', 'V005', 2 FROM [Table] WHERE TableName = 'Staff'
  8.  
  9.        
  10. INSERT INTO [Column] ([TableID], [SystemName], [DisplayName], [DisplayOrder])
  11.  
  12.        SELECT [TableID], 'Email', 'V006', 3 FROM [Table] WHERE TableName = 'Staff'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement