Top "Database-agnostic" questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for …

sql database syntax database-agnostic ansi-sql-92

Function that creates a timestamp in c#

I was wondering, is there a way to create a timestamp in c# from a datetime? I need a millisecond …

c# timestamp compact-framework database-agnostic time-precision

Database cluster and load balancing

What is database clustering? If you allow the same database to be on 2 different servers how do they keep the …

database load-balancing cluster-computing database-agnostic

Difference between Restrictions.like and .ilike in Hibernate Criteria API

Hibernate's Criteria API has Restrictions.ilike function which has the following contract: A case-insensitive "like", similar to Postgres ilike operator …

java sql hibernate database-agnostic

When to use database views and when not?

This question is about database views, not materialized-views. Pros: Query simplification. Avoid repeat the same joins on multiples queries. Avoid …

views database-agnostic

Getting week number of date in SQL

Is there a way to get the week number of a date with SQL that is database independent? For example …

sql date week-number database-agnostic

Should many to many tables have a primary key?

If I have two objects that have a many-to-many relationship, I would typically model them in my database schema with …

database many-to-many database-agnostic

How to get fully materialized query from querydsl

I am trying to use querydsl for building dynamic queries for dynamic schemas. I am trying to get just the …

java sql database querydsl database-agnostic

Does "group by" automatically guarantee "order by"?

Does "group by" clause automatically guarantee that the results will be ordered by that key? In other words, is it …

sql database group-by database-agnostic