Advertisement
hecrus

Tree checkboxes Dict

Nov 3rd, 2020
940
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.25 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[fm_tst-form-treeview_f1_dict]
  2.    @username nvarchar(256),
  3.    @itemID nvarchar(128)
  4. AS
  5. BEGIN  
  6.     select c.id Value,     -- id
  7.         c.name as Text,    
  8.         isnull(c.parentID, 0) Value2  -- parentID
  9.     from tst_categories c  
  10. END
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement