a1ex07

less info
meta site favicon meta user | stack exchange network profile network profile
2,645 reputation
29
bio website
location Vancouver, Canada
age
visits member for 1 year, 11 months
seen 13 hours ago
stats profile views 66

104 Answers

newest activity votes
1
How to create the multiple sum query with joins
jun 13 at 12:46
0
What structure should be used to store data with multiple category identifiers?
jun 4 at 16:36
1
Getting error ORA-01722: Invalid number but can't figure out why
jun 3 at 18:11
1
HOW to “SUM” and “JOIN” for single query of a poll results?
jun 2 at 17:54
4
Splitting SQL query with many joins into smaller ones helps?
jun 1 at 17:57
1
Bit column vs multiple join tables
may 29 at 17:16
4
Database structure for tags?
may 18 at 13:58
2
Is it possible to validate DML statements?
may 7 at 14:36
1
Same Parameter in MySQL Stored Procedure
may 3 at 14:47
2
Foreign Key to Multicolumn Primary Key?
may 1 at 18:50
1
Enforce indirect relationship
apr 25 at 18:03
0
getting error when i use merge statement
apr 15 at 13:51
1
database design- diagrams
apr 14 at 13:52
0
Reinsert data in new table with new IDs
apr 7 at 17:56
3
A database in MySQL is a schema in Oracle : I do not understand this statement
mar 4 at 16:23
1
Adding an ID column to a join table (many-to-many) so that it can be targeted
mar 3 at 16:23
3
Only one NULL for one part of primary key
mar 3 at 5:57
0
How does optimistic locking actually enforce re-read/update?
mar 2 at 21:14
0
Why is optimistic locking faster than pessimistic locking?
mar 2 at 21:05
2
ORDER BY clause is allowed over column that is not in SELECT list?
feb 18 at 17:56
1
MySQL - Performing an IF statement for each row in a query
feb 8 at 15:46
2
What is the correct result for this query?
jan 29 at 17:45
0
how to add trigger in mysql workbench, without UDF, using EER design
jan 22 at 15:04
0
multivalued weak key in ER database modeling
jan 18 at 16:25
5
SQL Server OPENQUERY vs Regular Query against AS400
jan 17 at 16:17
2
MySQL SELECT query: i want show duplicated entries
jan 3 at 17:52
2
T-SQL Case functionality
dec 31 at 16:15
1
Separate or Combine 2 Tables with Similar Attributes?
dec 30 at 17:15
0
Inner Join or direct data save in SQL Server
dec 27 at 16:54
5
Swap Columns on some rows?
dec 26 at 17:52
1 2 3 4