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.

Feb
24
awarded Good Answer
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
1 2 3 4 5