Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server (for this, use the sql-server tag), nor does it refer to specific dialects of SQL on its own.
0
votes
1answer
40 views
Implementing Bulk Update feature and its trade offs
The feature to implement is to allow a user to select items and apply data update in bulk. It is very similar to JIRA's ability to bulk update a list of selected issues. In my case:
I iterate over ...
4
votes
1answer
61 views
Good architecture for user information on separate databases?
I need to write an API to connect to an existing SQL database. The API will be written in ASP.Net MVC3.
The slight problem is that with existing users of the system, they may have a username on ...
4
votes
5answers
214 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)
...
-1
votes
0answers
70 views
How can i calculate the running balance for debit and credit on the same row in ms access 2007? [closed]
I am having a table which contains the debit and credit fields. I want to calculate the running balance on each row. Please help Me
4
votes
3answers
250 views
Rule of thumb for field sizes
What VARCHAR sizes should be used for first and last names, phone numbers (preferably international), email adresses, urls, dictionary words and file names?
Edit: Zapped the introductory phrase to ...
0
votes
0answers
21 views
SQL order by 2 date columns [migrated]
I have a table with orders. Each order has a delivery_date, and a collection_date.
I want to retrieve the orders as a schedule for a week which shows what the next thing is to do.
So I guess I want ...
3
votes
4answers
137 views
What's the utility of encouraging users to learn SQL and possibly the ability to execute it?
Facing a situation where I can't possibly get all the features that are requested into each version of the LOB I support, I've evolved a number SQL query templates that users have and send to me, ...
1
vote
6answers
114 views
Confusion about proper use of * wildcard in SQL [closed]
Suppose I was writing an address book application where the details of each contact were stored in an SQL database.
A user wants to know all the details for a person whose name is "Bob [Someone]".
...
-1
votes
1answer
100 views
what is the best way to implement a multiplayer match making system in ASP.net/C# [closed]
OK I am going to try to make this as simple as possible. This is what I have:
an asp.net/c# website
a MSSQL DB
a table on the DB with user information (user ID, username, arbitrary user rating)
Now ...
10
votes
8answers
789 views
How do I make complex SQL queries easier to write?
I'm finding it very difficult to write complex SQL queries involving joins across many (at least 3-4) tables and involving several nested conditions. The queries I'm being asked to write are easily ...
1
vote
2answers
166 views
Designing complex query builders in java/jpa/hibernate
I need to build complex sql queries programatically, based on large filter conditions.
For example, below are few sample/hypothitical filter conditions, based on which i need to fetch users
Country: ...
2
votes
2answers
118 views
Where should SQL/DB Queries be encapsulated in a software system?
I frequently write small applications (either web based or otherwise) that require heavy database usage. i've attempted various ways of handling where to put the actual sql queries (sort of ad-hoc ORM ...
-1
votes
1answer
185 views
Is there a way to SELECT all but one attributes of a relation in Oracle SQL? [closed]
I am a beginner learning DBMS (in general) and ORACLE SQL .
Recently I had to come across a situation where I wanted to SELECT all columns from a table except one . Is there a way to accomplish it ...
1
vote
2answers
82 views
SQL DB design to support user feeds (in application like facebook)
I have a social network server with a MySql DB. I want to show the users feeds like done in Facebook. Example - UserX now Friend with userY, userX did like on postX etc.
Currently I have table: C1 : ...
8
votes
6answers
396 views
Software solution from the 2000's, should I attempt to patch or remake the whole thing?
I was sent out to discuss a system that a certain company is currently using and what should be done with it.
The company manufactures various carton displays. This system was developed to keep track ...
