Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

SQL indexes for "not equal" searches

sql postgresql indexing

What is the best way to implement a substring search in SQL?

Postgres UPSERT (INSERT or UPDATE) only if value is different

sql postgresql merge upsert

How can I make cx-oracle bind the results of a query to a dictionary rather than a tuple?

Is varchar(128) better than varchar(100)

sql database-design

MySQL LEFT JOIN with GROUP BY and WHERE IN (sub query)

mysql sql group-by left-join

SQL Server table to json

sql json sql-server-2008

Postgresql JSON has key

Is it possible for me to include a sub report in a tablix row that is grouped by an ID?

Using SQL LocalDB in a Windows Service

sql sql-server localdb

What's the reason / usefulness is to use ENABLE keyword in oracle database statements

sql database oracle keyword

Pseudo Random Repeatable Sort in SQL Server (not NEWID() and not RAND())

PostgreSQL - best way to return an array of key-value pairs

sql database postgresql npgsql

sqlite3 views affect performance?

sql sqlite views

Generate report from URL - SQL Server Reporting Services 2008

Using IF / ELSE to determine a SELECT INTO statement

Using COUNT in GROUP_CONCAT

mysql sql count group-concat

SQL: Select a list of numbers from "nothing"

sql sqlite postgresql sequence

Should I round my database field sizes to a the nearest multiple of a base 2 number?

mysql sql database performance

PHP sqlsrv query to database

php sql sql-server sqlsrv