Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Default size for database fields

Best way to check whether a row has been updated in SQL

c# sql asp.net sql-server tsql

ExecuteReader requires an open and available Connection. The connection's current state is closed

SQL query to return one single record for each unique value in a column

sql tsql sql-server-2000

Oracle Analytic function for min value in grouping

How do constant values effect the ON clause of Joins?

sql join on-clause

MySql bulk load command line tool

Query on datetime fields with milliseconds gives wrong result in SQL Server

How to resolve ORA-00937: not a single-group group function when calculating percentage?

sql oracle ora-00937

Seeding SQLite RANDOM()

mysql sql sqlite random seeding

In mysql or postgres, is there a limit to the size of an IN (1,2,n) statement?

Select count / duplicates

sql mysql database

LINQ version of SQL's LIKE statement

sql linq

Querying Same Lookup Table With Multiple Columns

sql sqlite

.nextval JDBC insert problem

java sql oracle jdbc ora-01722

MERGE syntax used to UPSERT or INSERT on duplicate UPDATE

postgresql upsert sql

sql query to mongodb?

sql mongodb

Insert id (autogenerated, only column)

sql sql-server-2005

MySQL UNIX_TIMESTAMP for PostgreSQL

mysql sql postgresql timestamp

What's the significance of # in SQL?

sql oracle plsql oracle10g