Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Select the just-inserted record with a composite Primary Key

How do I write a sql statement to calculate totals, based on groups from another table?

sql sql-server tsql

What are the key difference between MySQL and MS SQL Language? [duplicate]

mysql sql sql-server

Invalid floating point operation error when counting logarithm in SQL Server 2008

sql sql-server-2008

How to Transpose a resultset from SQL

sql sql-server-2008

SQL Azure Backup & Restore strategy

sql azure

ORDER BY and = (equals) in MYSQL

mysql sql sql-order-by

Create a comma-separated string from multiple rows of one column?

Sqlite: Why does 'select min(time) from asdftable' return a blank row when DB is empty?

sql sqlite

Determine table referenced in a view in SQL Server

Oracle and ADO.NET (The types in System.Data.OracleClient are deprecated.)

.net sql oracle

Is inserting a new database entry faster than checking if the entry exists first?

SQLite Insert or Replace Where

sql sqlite

Reading a text file with SSIS with CRLF or LF

sql ssis

Mysql return more than one row

mysql sql group-concat

SQL query: list of all IDs that were active during a given time interval, sorted by their start-time

mysql sql

Default value with two sets of parentheses instead of one

sql sql-server tsql

How can I optimize this query produced by SQLAlchemy?

mysql sql orm sqlalchemy

MySql - ON DUPLICATE KEY INSERT

Alternative to "IN" that works like "AND" instead of "OR"

mysql sql