Dofactory.com
Dofactory.com
 Back to list
Views:   3.5K
Replies:  0
Archived

Custom Column Pattern - SQL Design Patterns

Hi

I am not sure if this works or i misunderstood.

For Custom Column Pattern In Meta Model,  following SQLs have been mentioned to retrieve and display s student record.

1) SELECT Id, FirstName, LastName, Email FROM Student WHERE Id = 29

2) SELECT C.Name, V.Value FROM [Column] C JOIN [Value] V ON C.Id = V.ColumnId WHERE C.WhatId = 29

 
WhatId is a foreign key that points to a record in Student table which is identity column.

If we added custom columns for Course table, Id column in Course table will have value 29 and second query will get result for both tables (Student and Course).

Please advise.

Manohar
Manohar Shaghanti, Nov 05, 2016
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.