Maximilian Mayerl

Austria

none

Age: 24

I'm currently working as a C# developer, primarily working on a cost accounting system. Technologies I constantly use include C#, VB, Nemerle and SQL Server.

My hobbies (beside the computer of course) are ice hockey, reading and anime/manga.

Nov
20
awarded Enlightened
Nov
20
awarded Nice Answer
Sep
30
awarded Explainer
Sep
14
awarded Yearling
Mar
12
awarded Notable Question
Jul
17
awarded sql-server
Sep
21
awarded Custodian
Aug
8
comment two sql tables having 197000 rows in word table and second is wp_posts contains 60000 rows want to subtract second second table from first?
That joins all records in word with all records in wp_posts that have a different title... Does something completely different than the original query (and is SLOW!).
Aug
8
answered two sql tables having 197000 rows in word table and second is wp_posts contains 60000 rows want to subtract second second table from first?
Jul
19
answered Why i can't use my column in WHERE while i can in GROUP BY?
Jul
17
answered MYSQL How to count elements grouped by type
Jun
8
awarded Caucus
May
10
comment Why InitializeComponent is public
@Sharun: It is called inside the constructor of the control, isn't it? So it doesn't have to be public...
May
8
comment How to pass multiple values in a single parameter for a stored procedures?
Another way would be a comma-separated list of values... But not really any good way for SQL Server 2005. In SQL Server 2008, you could use table-valued parameters.
May
3
answered How do I enforce uniqueness in a table?
May
3
answered Reading value from data row
May
2
comment Java Database AutoIncrement Primary Key Algorithm
For "application reasons"? I'm not sure what exactly you mean, but maybe sqlite's sqlite3_int64 sqlite3_last_insert_rowid could help you and make it possible to use the database to generate your IDs... Have a look at the documentation: sqlite.org/c3ref/last_insert_rowid.html
Apr
4
comment Sql error with query #1064
"and Category NOT Category LIKE 'beauty%'" should be "and Category NOT LIKE 'beauty%'"
Apr
4
answered Sql error with query #1064
Apr
4
comment C#: Access Call hierarchy from code
That's probably the best method available, but it doesn't account for inlined methods, so it's not perfect... +1 anyway, because I can't think of a better alternative!
1 2 3 4 5