Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Supporter
Impact
0 people reached

  • 0 posts edited
  • 1 helpful flag
  • 4 votes cast
Nov
9
comment Should i separate ContactInfo (sub-entity) from MyTable (main-entity) or Not?
Why the hell would you separate those ? If all properties belong to the same entity, it goes to 1 table. You could justify 1 to 1 either when you have different entities, or -evntually - when a field group is rarely used.
Sep
14
answered How to create a view that refresh automatically
Sep
8
comment Moving data from MS Access to MS SQL Server
Even without coding, you could easily set a validation rule on the Access backend tables date fields. Something like Between date()-365 And Date()+365 (which would limit entry to dates within +- 1 year of current date)
Feb
26
awarded  Supporter
Nov
14
awarded  Autobiographer
Aug
17
answered Which of these table designs is better for performance?