New posts in sql

How to match all rows in a table in which an interval intersects the `start_time` and `end_time` columns?

sql postgresql intervals

SQL select everything in an array

sql select

A good hostname convention for few servers with many different services?

http sql hostname

SQL: How can I get the value of an attribute in XML datatype?

sql xml tsql xpath xquery

MySQL starts with searching issue

mysql sql sql-like

Duplicating a TABLE using Microsoft SQL Server Management

sql sql-server tsql ssms

How to get stored procedure parameters details?

sql sql-server tsql stored-procedures parameters

Truncate with condition

sql mysql truncate

Multiple aggregate functions in HAVING clause

mysql sql count

How do I query for fields containing a given text in MySQL?

mysql sql database

How to check the existence of a row in SQLite with Python?

python sql sqlite

ODBC: trouble removing system DSN

windows-xp sql odbc dsn

Backup database at certain intervals?

windows asp.net sql sql-server

SQL query to determine that values in a column are unique

sql sql-server tsql

Re-order columns of table in Oracle

sql oracle rename

Database on the fly with scripting languages

python sql database sqlite sqlalchemy

How to count the number of times a character appears in a SQL column?

sql tsql char

Create an inline SQL table on the fly (for an excluding left join)

mysql sql rdbms

str_replace in SQL UPDATE?

sql mysql string

How to get week start and end date string in PostgreSQL?

sql postgresql timestamp