Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

2d
awarded Good Answer
Mar
3
comment PostgreSQL 9.3: Pass more than 100 arguments to `REPLACE` function
@struwi: I agree with you that in that case replace should work. As that solution is even in the question I assumed the OP was looking for different strings to find and replace.
Mar
3
revised PostgreSQL 9.3: Pass more than 100 arguments to `REPLACE` function
added 14 characters in body
Mar
3
comment PostgreSQL 9.3: Pass more than 100 arguments to `REPLACE` function
@struwi It does, but it can search for only one string to find and replace
Mar
3
answered PostgreSQL 9.3: Pass more than 100 arguments to `REPLACE` function
Mar
2
revised Tricky Postgresql query
edited tags
Mar
2
answered How to identify the missing value
Mar
2
comment Datetime with postgresql, python, and a stored procedure
The second example (a parameterized query) is a better choice, +1
Mar
1
answered T-SQL, get highest values from two columns while grouping by one column
Feb
28
answered How can I make use of LOCAL VARIABLES within a heroku postgres query?
Feb
28
comment SQL Server 2005: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint
The only way I've found out of the ORM morass is not to use an ORM. Anything else is just a temporary reprieve.
Feb
26
revised sql count() from multiple tables
added 2 characters in body
Feb
26
comment sql server merge rows and get latest value
@VladimirBaranov: The SQL Server optimizer has more freedom with the query above (specifically without top 1). Try it.
Feb
26
answered sql count() from multiple tables
Feb
26
revised sql count() from multiple tables
deleted 209 characters in body
Feb
26
revised Is there a way to update primary key Identity specification Increment 1 without dropping Foreign Keys?
edited title
Feb
26
comment Is there a way to update primary key Identity specification Increment 1 without dropping Foreign Keys?
You cannot alter the identity property, only set it for new columns. Create a new identity column, copy the values with set identity_insert [table] on, and drop and re-create the foreign key constraints.
Feb
26
revised sql server merge rows and get latest value
edited tags
Feb
26
answered sql server merge rows and get latest value
Feb
26
revised sql server merge rows and get latest value
added 60 characters in body
1 2 3 4 5