Tagged Questions
2
votes
2answers
166 views
Saving user profiles in SQL database
So, I got a table UserProfiles in my database, that, similar to C#'s Settings file, holds a property with the appropriate datatype and the specified setting in the profile.
Now each time I add a new ...
2
votes
4answers
190 views
How to genericize foreign key references in table?
I am trying to design a table to store references to multiple tables as a "target" of the item in each row.
An example should clarify what I am trying to do:
Imagine you have 4 tables (images, ...
0
votes
1answer
483 views
Best place to write SQL queries
I've been working on this project for my company. Currently I am embedding my SQL statements inside the program itself as and when they are needed. I do have two seperate classes -
QueryBuilder ...
93
votes
16answers
6k views
“Never do in code what you can get the SQL server to do well for you” - Is this a recipe for a bad design?
It's an idea I've heard repeatedly in a handful of places. Some more or less acknowledging that once trying to solve a problem purely in SQL, you exceed a certain level of complexity you should indeed ...
1
vote
1answer
368 views
How can I implement a database TableView like thing in C++?
How can I implement a TableView like thing in C++?
I want to emulating a tiny relation database like thing in C++. I have data tables, and I want to transform it somehow, so I need a TableView like ...
5
votes
5answers
1k views
Two database fields for date and time - should they be merged?
In the following question, field and table names have been changed to protect their identities.
If I have two database columns:
MONKEY_DATE DATETIME NULL (with data e.g. 2012-05-14 00:00:00.000)
...
4
votes
5answers
530 views
How can I improve upon this “pattern”?
I have a series of method calls that all share similar qualities. The basic layout is
public void CallDataBase()
{
Utility sqlHelper = new Utility();
StringBuilder query = new ...
