All Sql Solutions on Gang of Coders

Total of 2717 Sql Solutions

What is the difference between "INNER JOIN" and "OUTER JOIN"?

Sql Database Join Inner Join Outer Join

How do I UPDATE from a SELECT in SQL Server?

Sql Sql Server Tsql Select Sql Update

Add a column with a default value to an existing table in SQL Server

Sql Sql Server Sql Server-2005 Sql Server-2000

How can I prevent SQL injection in PHP?

Php Mysql Sql Security Sql Injection

How does database indexing work?

Sql Database Performance Indexing Database Indexes

How do I import an SQL file using the command line in MySQL?

Mysql Sql Command Line Import

Finding duplicate values in a SQL table

How to concatenate text from multiple rows into a single text string in SQL Server

Sql Sql Server Csv String Concatenation Group Concat

How to return only the Date from a SQL Server DateTime datatype

Sql Sql Server Tsql Date Datetime

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

Mysql Sql Join Inner Join Outer Join

Inserting multiple rows in a single SQL query?

Sql Sql Server Tsql Insert

Select first row in each GROUP BY group?

Sql Sqlite Postgresql Group By Greatest N-per-Group

How to query MongoDB with "like"

Sql Mongodb Mongodb Query Sql Like

Insert results of a stored procedure into a temporary table

Sql Sql Server Sql Server-2005 Tsql Stored Procedures

How do I perform an IF...THEN in an SQL SELECT?

Sql Sql Server Tsql If Statement Case

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

Sql Database Syntax Database Agnostic Ansi Sql-92

Table Naming Dilemma: Singular vs. Plural Names

Sql Sql Server Naming Conventions

What is the difference between UNION and UNION ALL?

Sql Union Union All

How can I delete using INNER JOIN with SQL Server?

Sql Sql Server Sql Server-2008 Inner Join Sql Delete

Find all tables containing column with specified name - MS SQL Server

Sql Sql Server Tsql System Tables

SQL select only rows with max value on a column

Mysql Sql Aggregate Functions Greatest N-per-Group Groupwise Maximum

What are the options for storing hierarchical data in a relational database?

Sql Database Tree Relational Database Hierarchical Data

How can I do an UPDATE statement with JOIN in SQL Server?

Sql Sql Server Tsql Sql Server-2005 Sql Update

How to reset AUTO_INCREMENT in MySQL

Mysql Sql Auto Increment

Can I concatenate multiple MySQL rows into one field?

Mysql Sql Concat Group Concat

Using group by on multiple columns

Sql Group By Multiple Columns

How can I list the tables in a SQLite database file that was opened with ATTACH?

Sql Database Sqlite Metadata

SQL Server - Best way to get identity of inserted row?

Sql Sql Server Tsql

Difference between JOIN and INNER JOIN

Sql Sql Server Join Inner Join

How do I limit the number of rows returned by an Oracle query after ordering?

Sql Oracle Pagination Sql Limit

How do I escape a single quote in SQL Server?

Sql Sql Server Tsql Delimiter Single Quotes

Retrieving the last record in each group - MySQL

Mysql Sql Group By Greatest N-per-Group Groupwise Maximum

Get list of all tables in Oracle?

SQL update from one Table to another based on a ID match

Sql Sql Server Select Join Sql Update

Parameterize an SQL IN clause

Sql Sql Server Parameters

When should I use CROSS APPLY over INNER JOIN?

Sql Sql Server Performance Tsql Cross Apply

Save PL/pgSQL output from PostgreSQL to a CSV file

Sql Postgresql Csv Postgresql Copy

INNER JOIN ON vs WHERE clause

Sql Mysql Join Inner Join

Insert into a MySQL table or update if exists

Mysql Sql Insert Update Upsert

Join vs. sub-query

Sql Mysql Subquery Join

Search text in stored procedure in SQL Server

Sql Sql Server Stored Procedures

How can I do 'insert if not exists' in MySQL?

Mysql Sql Sql Insert Primary Key Unique Constraint

Exclude a column using SELECT * [except columnA] FROM tableA?

Sql Sql Server Tsql

Function vs. Stored Procedure in SQL Server

Sql Sql Server Tsql Stored Procedures Sql Function

How can I get column names from a table in SQL Server?

Sql Sql Server Sql Server-2008 Tsql

How can I list all foreign keys referencing a given table in SQL Server?

Sql Sql Server Tsql

How to Join to first row

Sql Sql Server Tsql Sql Server-2000

How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?

Mysql Sql Max Distinct Greatest N-per-Group

Reset identity seed after deleting records in SQL Server

Sql Sql Server Database Sql Server-2008 Azure Sql-Database

Should I use != or <> for not equal in T-SQL?

Sql Sql Server Tsql

SQL JOIN - WHERE clause vs. ON clause

Sql Join Where Clause On Clause

DateTime2 vs DateTime in SQL Server

Sql Sql Server Tsql Datetime Datetime2

SQL SELECT WHERE field contains words

Count(*) vs Count(1) - SQL Server

Sql Sql Server Performance

SQL multiple column ordering

Sql Sql Order-By

How can I do a FULL OUTER JOIN in MySQL?

Sql Mysql Join Outer Join Full Outer-Join

Fastest Way of Inserting in Entity Framework

C#Sql Entity Framework

How can I temporarily disable a foreign key constraint in MySQL?

Mysql Sql Django Django Models

How do I get the query builder to output its raw SQL query as a string?

Php Sql Laravel Eloquent Laravel Query-Builder

SQL update query using joins

Sql Sql Server Tsql Sql Server-2005 Sql Update

MySQL Query GROUP BY day / month / year

Mysql Sql Date Datetime Group By

How do I see what character set a MySQL database / table / column is?

Sql Mysql Unicode Character Encoding Collation

Rename column SQL Server 2008

Sql Sql Server Sql Server-2008 Alter Table

'IF' in 'SELECT' statement - choose output value based on column values

Mysql Sql Database

SQL injection that gets around mysql_real_escape_string()

Php Mysql Sql Security Sql Injection

When to use single quotes, double quotes, and backticks in MySQL

Mysql Sql Quotes

postgres: upgrade a user to be a superuser?

Solutions for INSERT OR UPDATE on SQL Server

Sql Sql Server Database Insert Upsert

Get top 1 row of each group

Sql Sql Server Tsql Sql Server-2005 Greatest N-per-Group

How to select all records from one table that do not exist in another table?

Sql Sql Server Tsql

How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

Sql Sql Server Line Breaks

Skip certain tables with mysqldump

Sql Mysql Database Mysqldump

Fetch the row which has the Max value for a column

Sql Oracle Greatest N-per-Group Groupwise Maximum

How do I restore a dump file from mysqldump?

Mysql Sql Database

Is it possible to insert multiple rows at a time in an SQLite database?

Sql Sqlite Syntax

Insert text with single quotes in PostgreSQL

Sql Postgresql Quotes String Literals

MySql export schema without data

SQLite - UPSERT not INSERT or REPLACE

Sql Sqlite Upsert

OR is not supported with CASE Statement in SQL Server

Sql Sql Server Tsql Case Case When

NOT IN vs NOT EXISTS

Sql Sql Server Notin

Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

Sql Sql Server Max

What is the difference between Left, Right, Outer and Inner Joins?

Sql Database Join

Best approach to remove time part of datetime in SQL Server

Sql Sql Server Tsql Datetime Date

How to request a random row in SQL?

How to turn IDENTITY_INSERT on and off using SQL Server 2008?

Sql Sql Server-2008

What is the most efficient/elegant way to parse a flat table into a tree?

Sql Algorithm Recursion Tree Hierarchical Data

What is the best way to paginate results in SQL Server

Sql Sql Server Performance Pagination

java.util.Date vs java.sql.Date

Java Sql Datetime Date Jdbc

UPDATE and REPLACE part of a string

Sql Sql Server String Sql Server-2008 Replace

MySQL: @variable vs. variable. What's the difference?

Mysql Sql Variables

MySQL select 10 random rows from 600K rows fast

Mysql Sql Random

Selecting COUNT(*) with DISTINCT

Sql Sql Server Sql Server-2005 Tsql

How do I split a string so I can access item x?

Sql Sql Server Tsql Split

How to delete duplicate rows in SQL Server?

Sql Sql Server-2008 Duplicates Sql Delete

Adding an identity to an existing column

Sql Sql Server Alter Table Identity Column

Is it possible to specify condition in Count()?

Sql Sql Server Tsql

How to declare a variable in MySQL?

How do I (or can I) SELECT DISTINCT on multiple columns?

Sql Postgresql Sql Update Duplicates Distinct

Error related to only_full_group_by when executing a query in MySql

Mysql Sql Group By Mysql Error-1055

How to convert java.util.Date to java.sql.Date?

Java Sql Datetime Date

What is an index in SQL?

Difference between EXISTS and IN in SQL?

Sql Exists Sql In

How to create id with AUTO_INCREMENT on Oracle?

Sql Oracle Auto Increment

Using LIMIT within GROUP BY to get N results per group?

Mysql Sql Group By Greatest N-per-Group Ranking

When to use "ON UPDATE CASCADE"

Sql Foreign Keys

What is the syntax for an inner join in LINQ to SQL?

C#.Net Sql Linq to-Sql Join

Exporting data In SQL Server as INSERT INTO

Sql Sql Server Insert Data Migration

How to print a query string with parameter values when using Hibernate

Java Sql Hibernate Orm

Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

Sql Sql Server Sybase

Delete all Duplicate Rows except for One in MySQL?

Mysql Sql Duplicates

SQL MAX of multiple columns?

Sql Sql Server Tsql

Nested select statement in SQL Server

Sql Sql Server Nested Subquery Querying

how can I Update top 100 records in sql server

Sql Sql Server Tsql Sql Update

SQL query return data from multiple tables

Mysql Sql Select

Efficiently convert rows to columns in sql server

Sql Sql Server Sql Server-2008 Pivot

Explicit vs implicit SQL joins

MySQL Error: : 'Access denied for user 'root'@'localhost'

Mysql Sql Database Database Connection

What is the meaning of the prefix N in T-SQL statements and when should I use it?

Sql Sql Server Tsql

MySQL error: key specification without a key length

Mysql Sql Mysql Error-1170

What are DDL and DML?

How to select the nth row in a SQL database table?

Mysql Sql Database Oracle Postgresql

How Stuff and 'For Xml Path' work in SQL Server?

Sql Sql Server For Xml-Path Stuff

How to use GROUP BY to concatenate strings in SQL Server?

Sql Sql Server String Concatenation Sql Server-Group-Concat

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

Sql Linq to-Sql Entity Framework ado.net Linq to-Entities

SQL/mysql - Select distinct/UNIQUE but return all columns?

Sql Select Distinct

updating table rows in postgres using subquery

Sql Postgresql Subquery Sql Update

Postgres DB Size Command

Sql Postgresql Postgresql 9.2

How to get multiple counts with one SQL query?

SQL Server SELECT into existing table

Sql Sql Server Tsql Stored Procedures

Multiple Updates in MySQL

Mysql Sql Sql Update

You can't specify target table for update in FROM clause

Sql Mysql Mysql Error-1093

How do I query for all dates greater than a certain date in SQL Server?

Sql Sql Server Datetime

How to select rows with no matching entry in another table?

Sql Foreign Keys

How to concatenate strings of a string field in a PostgreSQL 'group by' query?

Sql Postgresql Group By String Aggregation

How to avoid the "divide by zero" error in SQL?

Sql Sql Server Sql Server-2005 Sql Server-2008

What's the difference between VARCHAR and CHAR?

Select statement to find duplicates on certain fields

Sql Sql Server Tsql Sql Server-2008

Hibernate show real SQL

Java Sql Hibernate Orm

Remove duplicate rows in MySQL

Mysql Sql Duplicates Subquery Sql Delete

Best way to select random rows PostgreSQL

Sql Performance Postgresql Random

How to get the insert ID in JDBC?

Java Sql Jdbc Insert Id

How to use GROUP BY to concatenate strings in MySQL?

Sql Mysql String Aggregate Concatenation

How to insert a value that contains an apostrophe (single quote)?

Sql Sql Update Sql Insert

Postgres and Indexes on Foreign Keys and Primary Keys

Sql Postgresql Foreign Keys

Get day of week in SQL Server 2005/2008

Sql Sql Server Datetime

Is there a combination of "LIKE" and "IN" in SQL?

Sql Sql Server Oracle Tsql Plsql

Altering a column to be nullable

Can a foreign key be NULL and/or duplicate?

Sql Sql Server Oracle Foreign Keys

Rename a column in MySQL

Is a view faster than a simple query?

Sql Sql Server Performance

How can I see the raw SQL queries Django is running?

Is there any difference between GROUP BY and DISTINCT

Sql Group By Distinct

What is the difference between Views and Materialized Views in Oracle?

Sql Oracle View Relational Database Materialized Views

Selecting data from two different servers in SQL Server

Sql Sql Server Tsql

SQL join: selecting the last records in a one-to-many relationship

Sql Select Join Indexing Greatest N-per-Group

Update a column value, replacing part of a string

How to SELECT FROM stored procedure

Sql Sql Server Sql Server-2005 Stored Procedures

SQL to find the number of distinct values in a column

Difference between numeric, float and decimal in SQL Server

Sql Sql Server Types

must appear in the GROUP BY clause or be used in an aggregate function

Sql Group By Aggregate Functions Postgresql 9.1

Get record counts for all tables in MySQL database

Mysql Sql Rowcount

Best database field type for a URL

Sql Mysql Database

SQL statement to get column type

How to create a MySQL hierarchical recursive query?

Mysql Sql Hierarchical Data Recursive Query

Oracle: If Table Exists

Sql Oracle Sql Drop

How to perform OR condition in django queryset?

Python Sql Django Django Queryset Django Orm

How to set variable from a SQL query?

Sql Sql Server Tsql

How to replace a string in a SQL Server Table Column

Sql Sql Server Database Database Administration

Best way to test if a row exists in a MySQL table

Sql Mysql Performance Exists

What is the difference between SQL, PL-SQL and T-SQL?

SQL Server - Return value after INSERT

Sql Sql Server Sql Server-2008

What is the equivalent of 'describe table' in SQL Server?

Sql Sql Server Tsql

How can I select the first day of a month in SQL?

Sql Sql Server Tsql Sql Server-2008 Datetime

Get all table names of a particular database by SQL query?

Convert INT to VARCHAR SQL

Sql Select Type Conversion Sybase

Get table column names in MySQL?

SQL query to select dates between two dates

Sql Sql Server Tsql Datetime Sql Server-2005

Error 1046 No database Selected, how to resolve?

Sql Mysql Mysql Error-1046

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Sql Database Design Foreign Keys Relational Database Relationship

How to declare a variable in a PostgreSQL query

Sql Postgresql Postgresql 8.3

What's the difference between CharField and TextField in Django?

Sql Django Database Storage

SQL Inner-join with 3 tables?

Sql Join Inner Join

How to get the top 10 values in postgresql?

Sql Postgresql Sql Limit

Getting the SQL from a Django QuerySet

Python Sql Django Django Queryset

Are there any disadvantages to always using nvarchar(MAX)?

Sql Sql Server Sql Server-2005

SQL Server - stop or break execution of a SQL script

Sql Sql Server Scripting Exit

How can I search (case-insensitive) in a column using LIKE wildcard?

Mysql Sql Sql Like Case Insensitive

What represents a double in sql server?

C#Sql Sql Server Sql Server-2005 Tsql

Find records from one table which don't exist in another

How can I copy data from one column to another in the same table?

Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction

Mysql Sql Timeout Lock Timeout

How can I return pivot table output in MySQL?

Mysql Sql Pivot

What's the difference between TRUNCATE and DELETE in SQL

Sql Database Truncate

MySQL query String contains

Mysql Sql String Comparison

Error Code: 2013. Lost connection to MySQL server during query

Mysql Sql Database Mysql Workbench

Simulating group_concat MySQL function in Microsoft SQL Server 2005?

Sql Sql Server Sql Server-2005 String Aggregation

What datatype to use when storing latitude and longitude data in SQL databases?

Sql Database Geocoding Latitude Longitude

T-SQL Cast versus Convert

Sql Sql Server Database Tsql

Connect different Windows User in SQL Server Management Studio (2005 or later)

Sql Sql Server-2008

How do I obtain a Query Execution Plan in SQL Server?

Sql Sql Server Performance Tsql Sql Execution-Plan

How do I see active SQL Server connections?

Sql Sql Server Sql Server-2008

SET NOCOUNT ON usage

Sql Sql Server Tsql ado.net Concurrency

MySQL Cannot Add Foreign Key Constraint

Mysql Sql Foreign Keys

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

Sql Sql Server Tsql Alter

Dynamic SELECT TOP @var In SQL Server

Sql Sql Server-2005

Update statement with inner join on Oracle

Sql Oracle Inner Join Ora 00933

Select n random rows from SQL Server table

Sql Sql Server Random

SQL how to make null values come last when sorting ascending

Sql Sorting Sql Order-By

Combining "LIKE" and "IN" for SQL Server

How can I make SQL case sensitive string comparison on MySQL?

Mysql Sql Interop Case Sensitive String Comparison

How do I check if a column is empty or null in MySQL?

Altering column size in SQL Server

Sql Sql Server Database Tsql Alter Table

How to change a PG column to NULLABLE TRUE?

Sql Postgresql Nullable

Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework

C#Sql asp.net Mvc Entity Framework Code First

Not equal <> != operator on NULL

Sql Sql Server Tsql Null

Equals(=) vs. LIKE

Sql Performance Equals Sql Like

Reset auto increment counter in postgres

Sql Postgresql Reset Auto Increment

SQL Server Insert if not exists

Sql Sql Server Sql Server-2008 Stored Procedures

Best way to do multi-row insert in Oracle?

Sql Oracle Sql Insert Oracle9i

INSERT with SELECT

Mysql Sql Insert Select

Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

Sql Group By Aggregate Functions

Best practices for SQL varchar column length

Mysql Sql Sql Server Postgresql

Copy tables from one database to another in SQL Server

Sql Sql Server Copy Migrate Database Table

Entity Framework. Delete all rows in table

C#Sql Linq Entity Framework

How to get first character of a string in SQL?

Sql Sql Server Sql Server-2005

Recommended SQL database design for tags or tagging

Sql Database Design Tags Data Modeling Tagging

How to convert DateTime to VarChar

Sql Sql Server Datetime Sql Convert

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

Sql Postgresql Casting Timestamp

How to check if a stored procedure exists before creating it

Sql Sql Server Tsql Stored Procedures

how do I query sql for a latest record date for each user

Sql Greatest N-per-Group

Cast from VARCHAR to INT - MySQL

MySQL LIKE IN()?

Oracle: how to UPSERT (update or insert into a table?)

Sql Oracle Merge Upsert

What is a stored procedure?

Sql Sql Server Tsql Stored Procedures

How to select date without time in SQL

Sql Sql Server Sql Server-2005

What does SQL clause "GROUP BY 1" mean?

Mysql Sql Group By

SQL keys, MUL vs PRI vs UNI

ROW_NUMBER() in MySQL

Mysql Sql Greatest N-per-Group Rank Row Number

SET versus SELECT when assigning variables?

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

Convert Rows to columns using 'Pivot' in SQL Server

Sql Sql Server Pivot Pivot Table

MySQL SELECT only not null values

Mysql Sql Select Notnull

Is there any boolean type in Oracle databases?

Sql Database Oracle Boolean Sqldatatypes

Create unique constraint with null columns

Sql Postgresql Database Design Null Referential Integrity

What's faster, SELECT DISTINCT or GROUP BY in MySQL?

Mysql Sql Database Group By Distinct

Postgresql GROUP_CONCAT equivalent?

Sql Postgresql Group Concat String Aggregation

Difference between "read commited" and "repeatable read"

Sql Sql Server Isolation Level

Get records with max value for each group of grouped SQL results

Mysql Sql Greatest N-per-Group

How do I get the size of a java.sql.ResultSet?

Java Sql Jdbc Resultset Record Count

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

Sql Sql Server Sql Server-2005 Tsql

What is the difference between JOIN and UNION?

Sql Database Join Union

How do I find duplicate values in a table in Oracle?

Sql Oracle Duplicate Data

T-SQL: Deleting all duplicate rows but keeping one

Sql Sql Server Tsql

Can table columns with a Foreign Key be NULL?

Sql Mysql Database Foreign Keys

Oracle SQL: Update a table with data from another table

Sql Oracle Sql Update

How can I add a column that doesn't allow nulls in a Postgresql database?

Sql Postgresql Alter Table

SQL Server SELECT INTO @variable?

Sql Sql Server Tsql Sql Server-2008

How do I query between two dates using MySQL?

Rails raw SQL example

Sql Ruby on-Rails

Update multiple rows in same query using PostgreSQL

Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

Sql Dynamic Sql

How can I create a copy of an Oracle table without copying the data?

Sql Oracle Copy Database Table

Saving changes after table edit in SQL Server Management Studio

Sql Sql Server Ssms Database Table

How to convert all tables from MyISAM into InnoDB?

Mysql Sql Innodb

How to copy a row and insert in same table with a autoincrement field in MySQL?

Mysql Sql Insert Copy

How to fetch the row count for all tables in a SQL SERVER database

Sql Sql Server Rowcount

How to store decimal values in SQL Server?

Sql Sql Server Types Decimal

Disable Rails SQL logging in console

Sql Ruby on-Rails Console

How to execute raw SQL in Flask-SQLAlchemy app

Python Sql Sqlalchemy Flask Flask Sqlalchemy

Why do you create a View in a database?

Sql Sql Server Database Tsql

Counting DISTINCT over multiple columns

Sql Sql Server Performance Tsql Query Optimization

How to set auto increment primary key in PostgreSQL?

Sql Postgresql Auto Increment

How to check for Is not Null And Is not Empty string in SQL server?

In Postgresql, force unique on combination of two columns

Sql Postgresql Unique

Syntax of for-loop in SQL Server

Sql Sql Server Loops Tsql Syntax

mysql update column with value from another table

Mysql Sql Sql Update

How to list active connections on PostgreSQL?

Sql Postgresql Database Connection Listings

MySQL search and replace some text in a field

Mysql Sql Search Replace

INNER JOIN vs LEFT JOIN performance in SQL Server

Sql Sql Server Performance

Why is SELECT * considered harmful?

Can I use multiple "with"?

Sql Tsql Sql Server-2008

error, string or binary data would be truncated when trying to insert

SQL left join vs multiple tables on FROM line?

Sql Syntax Join

SELECT * FROM X WHERE id IN (...) with Dapper ORM

.Net Sql Dapper

Inner join vs Where

Sql Performance Oracle

Max length for client ip address

Sql Database Database Design

What is the difference between single and double quotes in SQL?

Sql Database Quotes

NULL values inside NOT IN clause

Sql Sql Server Tsql Null Notin

How do I set a column value to NULL in SQL Server Management Studio?

Sql Sql Server Ssms

How does MySQL process ORDER BY and LIMIT in a query?

Mysql Sql Sql Order-By Sql Limit

difference between primary key and unique key

Mysql Sql Database Primary Key Unique Key

What are the use cases for selecting CHAR over VARCHAR in SQL?

How do I list all the columns in a table?

Sql Mysql Sql Server Database Oracle

How do I do top 1 in Oracle?

Sql Oracle Oracle11g Sql Limit

SQL Case Sensitive String Compare

What is the difference between HAVING and WHERE in SQL?

Sql Where Clause Having

Oracle "Partition By" Keyword

Sql Oracle Window Functions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

Sql Sql Server Tsql Sql Server-2008 Sql Server-2008-R2

Using an ORM or plain SQL?

Sql Language Agnostic Orm

How do I interpret precision and scale of a number in a database?

Sql Database Decimal Scale Precision

MySQL OPTIMIZE all tables?

PostgreSQL DISTINCT ON with different ORDER BY

Sql Postgresql Sql Order-By Distinct On

How to find duplicate records in PostgreSQL

Sql Postgresql Duplicates

What's the best practice for primary keys in tables?

Sql Sql Server Database Relational

MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET

Sql Mysql Performance

What does ON [PRIMARY] mean?

Sql Sql Server Database Database Design

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Sql Sql Server Sql Server-2005 Foreign Keys

PostgreSQL: Give all permissions to a user on a PostgreSQL database

Sql Postgresql Ddl Privileges Sql Grant

SQL: How to properly check if a record exists

Sql Optimization Query Optimization

Create a date from day month and year with T-SQL

Sql Sql Server Sql Server-2005 Tsql

How to deal with SQL column names that look like SQL keywords?

Select count(*) from multiple tables

Sql Oracle Count

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints

Sql Sql Server Database Sql Server-2005 Custom Data-Type

ERROR: permission denied for sequence cities_id_seq using Postgres

Sql Postgresql Permissions Auto Increment

SQL select join: is it possible to prefix all columns as 'prefix.*'?

Storing JSON in database vs. having a new column for each key

Mysql Sql Sql Server Database Optimization

What are the pros and cons to keeping SQL in Stored Procs versus Code

C#Sql Sql Server Stored Procedures

How do I drop a foreign key constraint only if it exists in sql server?

Sql Sql Server Sql Server-2005 Tsql

How to use count and group by at the same select statement

Sql Count Group By

Adding a new SQL column with a default value

How can I backup a remote SQL Server database to a local drive?

Sql Sql Server Backup

Correct use of transactions in SQL Server

Sql Sql Server Database Tsql Transactions

Generate class from database table

C#Sql Sql Server Tsql

How to list table foreign keys

Is it possible to GROUP BY multiple columns using MySQL?

Mysql Sql Group By

List columns with indexes in PostgreSQL

Sql Postgresql Indexing

How to compare dates in datetime fields in Postgresql?

Sql Database Postgresql Date

How can I group by date time column without taking time into consideration

Sql Sql Server Tsql Sql Server-2008

Cannot simply use PostgreSQL table name ("relation does not exist")

Php Sql Postgresql Quoted Identifier

How do I use an INSERT statement's OUTPUT clause to get the identity value?

Sql Sql Server-2005 Insert

How do you import a large MS SQL .sql file?

Sql Sql Server Import

How to randomly select rows in SQL?

Sql Database Random

How to use DbContext.Database.SqlQuery<TElement>(sql, params) with stored procedure? EF Code First CTP5

C#Sql ado.net Linq to-Entities Entity Framework-Ctp5

Convert Datetime column from UTC to local time in select statement

How to round an average to 2 decimal places in PostgreSQL?

Sql Ruby Postgresql Sequel

How do you return the column names of a table?

Sql Sql Server Tsql

Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?

Sql Sql Server Tsql Subquery Common Table-Expression

WHERE vs HAVING

Mysql Sql Where Clause Having Clause

Need to list all triggers in SQL Server database with table name and table's schema

Sql Sql Server Database Tsql Triggers

How do I convert from BLOB to TEXT in MySQL?

Sql Mysql Blobs

SQL WITH clause example

Sql With Clause

Check if a row exists, otherwise insert

Sql Sql Server Sql Server-2008 Tsql

How to speed up insertion performance in PostgreSQL

Sql Postgresql Bulkinsert Sql Insert

Count the occurrences of DISTINCT values

Mysql Sql Database Distinct

SQL - HAVING vs. WHERE

Sql Where Clause Having

Rounding off to two decimal places in SQL

PostgreSQL delete with inner join

How to update Identity Column in SQL Server?

Sql Sql Server Tsql Sql Server-2008

Fastest way to count exact number of rows in a very large table?

How to write UPDATE SQL with Table alias in SQL Server 2008?

Sql Sql Server Sql Server-2008 Sql Update Alias

How to use RETURNING with ON CONFLICT in PostgreSQL?

Sql Postgresql Upsert Sql Returning

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Sql Sql Server Database Foreign Keys

COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better?

Sql Select Count

SQL JOIN and different types of JOINs

How do I create a foreign key in SQL Server?

Sql Sql Server Tsql

When to use Common Table Expression (CTE)

Sql Sql Server Tsql Common Table-Expression

SQL RANK() versus ROW_NUMBER()

Sql Sql Server Tsql

Convert timestamp to date in MySQL query

Mysql Sql Date Formatting

MySQL - Rows to Columns

Mysql Sql Pivot Table Etl Crosstab

Find rows that have the same value on a column in MySQL

Sql Mysql Database

Case insensitive searching in Oracle

Sql Oracle Case Sensitive Case Insensitive Sql Like

Find a string by searching all tables in SQL Server

Sql Sql Server Search

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Mysql Sql Wordpress Collation

PostgreSQL create table if not exists

Sql Postgresql Ddl Create Table Database Table

Does MS SQL Server's "between" include the range boundaries?

Sql Sql Server Between

Condition within JOIN or WHERE

Sql Performance

Check if value exists in Postgres array

Sql Arrays Postgresql

List all tables in postgresql information_schema

Sql Postgresql Information Schema

PostgreSQL Crosstab Query

Sql Postgresql Pivot Case Crosstab

mysql Foreign key constraint is incorrectly formed error

Mysql Sql Heidisql

Select top 10 records for each category

Sql Sql Server Sql Server-2005 Greatest N-per-Group

MySQL dump by query

Sql Mysql Database

How to order by with union in SQL?

Sql Sql Order-By Union

Best way to check for "empty or null value"

Sql Database Postgresql Null Coalesce

Does the join order matter in SQL?

Sql Join Relational Database

How do I ALTER a PostgreSQL table and make a column unique?

Sql Postgresql Unique Constraint

What are the most common SQL anti-patterns?

Sql Anti Patterns

What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?

Sql Sql Server Identity

Use email address as primary key?

Sql Database Database Design Postgresql

I want to use CASE statement to update some records in sql server 2005

Sql Sql Server Tsql Sql Update

What did MongoDB not being ACID compliant before v4 really mean?

Sql Mongodb Acid Database Nosql

How to create a table from select query result in SQL Server 2008

Sql Sql Server Sql Server-2008

MySQL, better to insert NULL or empty string?

Mysql Sql Sql Null

Finding duplicate rows in SQL Server

Sql Sql Server Duplicates

How to get script of SQL Server data?

Sql Sql Server Export

Add primary key to existing table

Sql Sql Server Sql Server-2008 Constraints Primary Key

Best way to work with dates in Android SQLite

Android Sql Database Sqlite Date

How to alter a column and change the default value?

Simple way to calculate median with MySQL

Sql Mysql Statistics Median

sql query to return differences between two tables

Sql Sql Server Sql Server-2008 Sql Server-2005

How to move columns in a MySQL table?

Mysql Sql Alter

Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created?

Sql Database Postgresql Indexing Unique Constraint

Fastest check if row exists in PostgreSQL

JOIN two SELECT statement results

Sql Select Join Group By

Using column alias in WHERE clause of MySQL query produces an error

Mysql Sql Mysql Error-1054

Difference between left join and right join in SQL Server

Sql Sql Server Join Left Join Right Join

postgresql - add boolean column to table set default

SQL Server dynamic PIVOT query?

Sql Sql Server Tsql Pivot

Use variable with TOP in select statement in SQL Server without making it dynamic

Sql Sql Server Sql Server-2005 Tsql

Optimise PostgreSQL for fast testing

Sql Database Performance Postgresql Database Tuning

How to calculate percentage with a SQL statement

Sql Sql Server Tsql

MySQL's now() +1 day

Sql Mysql Datetime

How to get the count of each distinct value in a column?

Mysql Sql Count

MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query

Sql Mysql Duplicates

CREATE TABLE IF NOT EXISTS equivalent in SQL Server

Sql Sql Server Sql Server-2008-R2

Foreign key constraints: When to use ON UPDATE and ON DELETE

Mysql Sql Database Foreign Keys

Difference between natural join and inner join

Sql Join Natural Join

How to drop all tables from a database with one SQL query?

Convert Month Number to Month Name Function in SQL

Sql Sql Server Tsql Sql Server-2005

Turn off constraints temporarily (MS SQL)

Sql Sql Server Sql Server-2005 Constraints Entity Relationship

Cannot delete or update a parent row: a foreign key constraint fails

MySQL: How to copy rows, but change a few fields?

How do I query using fields inside the new PostgreSQL JSON datatype?

Sql Json Postgresql Postgresql 9.2 Postgresql 9.3

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

Mysql Sql Mariadb Mysql Error-1452

Why does Oracle 9i treat an empty string as NULL?

Sql Oracle Null String

How can a LEFT OUTER JOIN return more records than exist in the left table?

Sql Sql Server Sql Server-2005 Tsql

How to update two tables in one statement in SQL Server 2005?

Sql Sql Server Sql Server-2005 Tsql

django test app error - Got an error creating the test database: permission denied to create database

Python Sql Django Postgresql Django Testing

SQL: IF clause within WHERE clause

Sql Sql Server Tsql

Oracle Differences between NVL and Coalesce

Sql Oracle Coalesce Nvl

Extracting hours from a DateTime (SQL Server 2005)

Sql Tsql Datetime Sql Server-2005 Hour

Grouped LIMIT in PostgreSQL: show the first N rows for each group?

The multi-part identifier could not be bound

Sql Sql Server Sql Server-2005

Changing the maximum length of a varchar column?

Sql Sql Server Sql Server-2008 Tsql Varchar

Import CSV file into SQL Server

Sql Sql Server Csv Bulkinsert Bulk

What is the difference between LATERAL JOIN and a subquery in PostgreSQL?

Sql Postgresql Subquery Lateral Join

Is SQL syntax case sensitive?

Sql Case Sensitive

How do I execute a stored procedure once for each row returned by query?

Sql Sql Server Stored Procedures

SQL WHERE ID IN (id1, id2, ..., idn)

How to combine date from one field with time from another field - MS SQL Server

Sql Sql Server Datetime

SQL Server - transactions roll back on error?

Sql Sql Server Sql Server-2005 Transactions

INSERT ... ON DUPLICATE KEY (do nothing)

Mysql Sql Unique Key

Inserting data into a temporary table

Sql Sql Server Temp Tables

Recover unsaved SQL query scripts

Sql Sql Server Tsql Sql Server-2012 Ssms

Creating an index on a table variable

Sql Sql Server Tsql Indexing Table Variable

Change Schema Name Of Table In SQL

Sql Sql Server Tsql Schema

Replacing NULL with 0 in a SQL server query

Best data type for storing currency values in a MySQL database

Mysql Sql Sqldatatypes

Alter a MySQL column to be AUTO_INCREMENT

Sql Mysql Alter Table

Select rows which are not present in other table

Sql Postgresql Null Left Join Exists

Postgres unique constraint vs index

Sql Postgresql Indexing Unique

How can I find which tables reference a given table in Oracle SQL Developer?

Sql Oracle Foreign Keys Oracle Sqldeveloper

How to select multiple rows filled with constants?

Sql Select Constants

How to update only one field using Entity Framework?

Sql Entity Framework-4 Entity Field Dbcontext

ERROR: there is no unique constraint matching given keys for referenced table "bar"

Sql Postgresql Foreign Keys Unique Constraint

Modify table: How to change 'Allow Nulls' attribute from not null to allow null

Sql Sql Server Sql Server-2008

Count the number of occurrences of a string in a VARCHAR field?

How to count occurrences of a column value efficiently in SQL?

Sql Performance

SQL Server equivalent of MySQL's NOW()?

Why historically do people use 255 not 256 for database field magnitudes?

Sql Rdbms Agnostic

What are best practices for multi-language database design?

Sql Database Database Design

How to create Temp table with SELECT * INTO tempTable FROM CTE Query

Sql Sql Server Common Table-Expression

How to export all data from table to an insertable sql format?

Sql Sql Server Copy Export Ssms

In SQL, what's the difference between count(column) and count(*)?

How to drop SQL default constraint without knowing its name?

Sql Sql Server Tsql

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

Sql Sql Server Tsql Exists

SQL query for finding records where count > 1

Sql Count Group By Having

ALTER TABLE to add a composite primary key

Mysql Sql Primary Key Alter Table Composite Primary-Key

How do I put an 'if clause' in an SQL string?

How do I do multiple CASE WHEN conditions using SQL Server 2008?

Sql Sql Server-2008

How to select records from last 24 hours using SQL?

is of a type that is invalid for use as a key column in an index

Sql Sql Server-2008

Referring to a Column Alias in a WHERE Clause

Sql Sql Server Tsql Sql Server-2005

Set database from SINGLE USER mode to MULTI USER

MySQL CONCAT returns NULL if any field contain NULL

Mysql Sql Null Concat

Truncate (not round) decimal places in SQL Server

Sql Sql Server Tsql Rounding

What is best tool to compare two SQL Server databases (schema and data)?

Sql Sql Server Database Compare

ORDER BY the IN value list

Sql Postgresql Sql Order-By Sql In

Group query results by month and year in postgresql

IN vs ANY operator in PostgreSQL

Sql Postgresql Sql In

Most efficient T-SQL way to pad a varchar on the left to a certain length?

Sql Sql Server Tsql

sqlite database default time value 'now'

Group by date only on a Datetime column

Best way to do nested case statement logic in SQL Server

Sql Sql Server Sql Server-2005 Select Nested

SQL Logic Operator Precedence: And and Or

Sql Logical Operators Operator Precedence

Set NOW() as Default Value for datetime datatype?

Mysql Sql Datetime Mysql Error-1067

How can prepared statements protect from SQL injection attacks?

Sql Security Sql Injection Prepared Statement

MySQL Workbench: How to keep the connection alive

Mysql Sql Mysql Workbench Connection Timeout

When do I need to use a semicolon vs a slash in Oracle SQL?

Sql Oracle Sqlplus

MySQL select where column is not empty

is it possible to select EXISTS directly as a bit?

Sql Sql Server Tsql

In SQL, how can you "group by" in ranges?

Sql Sql Server Tsql

Convert a string to int using sql query

Sql Sql Server-2005

Remove Primary Key in MySQL

Mysql Sql Database Design Primary Key Mysql Error-1075

Difference between a User and a Login in SQL Server

Sql Sql Server Sql Server-2005

How to calculate age (in years) based on Date of Birth and getDate()

Sql Sql Server Tsql

"where 1=1" statement

Mysql Sql Database

Are PostgreSQL column names case-sensitive?

Sql Postgresql Identifier Case Sensitive Case Insensitive

Effect of NOLOCK hint in SELECT statements

Sql Sql Server Locking

Strings as Primary Keys in SQL Database

Sql Database Database Design String Primary Key

Can you create nested WITH clauses for Common Table Expressions?

Sql Sql Server Tsql Nested Common Table-Expression

Can someone copyright a SQL query?

How to group time by hour or by 10 minutes

Sql Sql Server-2008 Tsql Group By

The object 'DF__' is dependent on column '' - Changing int to double

Sql Sql Server Database Entity Framework Entity Framework-4

How to change the default collation of a table?

Mysql Sql Collation

Multi-statement Table Valued Function vs Inline Table Valued Function

Sql Sql Server Sql Server-2008 Tsql User Defined-Functions

PostgreSQL wildcard LIKE for any of a list of words

What's the difference between RANK() and DENSE_RANK() functions in oracle?

Sql Oracle Window Functions

How to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?

Sql Sql Server String Concatenation

SQL to LINQ Tool

How important is the order of columns in indexes?

Sql Sql Server Sql Server-2005 Tsql Indexing

Return 0 if field is null in MySQL

Difference between two dates in MySQL

Mysql Sql Date Datetime

Datetime equal or greater than today in MySQL

Mysql Sql Datetime

The SQL OVER() clause - when and why is it useful?

Sql Sql Server Aggregate Functions Clause

OPTION (RECOMPILE) is Always Faster; Why?

Sql Sql Server Sql Server-2008 Compilation Query Hints

How do I use ROW_NUMBER()?

Sql Sql Server Row Number

Left Join With Where Clause

Sql Left Join Where Clause

Check if MySQL table exists without using "select from" syntax?

Saving results with headers in SQL Server Management Studio

Sql Sql Server-2008 Excel Ssms Export to-Excel

MYSQL OR vs IN performance

Mysql Sql Performance Optimization

SQL JOIN vs IN performance?

Sql Sql Server Performance Tsql

Find nearest latitude/longitude with an SQL query

Mysql Sql Coordinates Geospatial

mySQL :: insert into table, data from another table?

Detect if value is number in MySQL

Mysql Sql Where Clause

Add unique constraint to combination of two columns

How can I get column names from a table in Oracle?

Sql Database Oracle

Use '=' or LIKE to compare strings in SQL?

Is SQL or even TSQL Turing Complete?

Sql Tsql Programming Languages Language Features

Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

Are database triggers evil?

Equivalent of LIMIT and OFFSET for SQL Server?

Sql Sql Server Pagination Limit Offset

How to check if a table exists in a given schema

Sql Database Postgresql Information Schema Search Path

SQL Query to concatenate column values from multiple rows in Oracle

Sql Oracle String Aggregation

Postgresql - change the size of a varchar column to lower length

Sql Postgresql Varchar Alter Table

Error on renaming database in SQL Server 2008 R2

Sql Sql Server Sql Server-2008-R2

How to check which locks are held on a table

Sql Sql Server Database Performance Sql Server-2005

Foreign key constraint may cause cycles or multiple cascade paths?

Sql Sql Server Constraints

How do I remove the first characters of a specific column in a table?

Sql Sql Server String Tsql

What is the benefit of using "SET XACT_ABORT ON" in a stored procedure?

MySQL "NOT IN" query

MySQL - Get row number on select

Mysql Sql Row Number

How to change the CHARACTER SET (and COLLATION) throughout a database?

Mysql Sql Collation

How do I dump the data of some SQLite3 tables?

How can I tell when a MySQL table was last updated?

How to see the values of a table variable at debug time in T-SQL?

Sql Debugging Ssms Table Variable

A table name as a variable

Sql Sql Server Tsql Variable Names Tablename

Import SQL file into mysql

Mysql Sql Database Windows Import

Update multiple columns in SQL

Sql Sql Server Sql Update

How to create composite primary key in SQL Server 2008

Sql Sql Server-2008

Why can't I use an alias in a DELETE statement?

Sql Sql Server Sql Server-Ce

What is Ad Hoc Query?

Sql Adhoc Queries

selecting unique values from a column

What is the purpose of Order By 1 in SQL select statement?

Sql Sql Order-By

How to Select Every Row Where Column Value is NOT Distinct

Sql Sql Server Sql Server-2008

SQL Server loop - how do I loop through a set of records

MySQL - UPDATE multiple rows with different values in one query

Mysql Sql Sql Update

How to insert multiple rows from a single query using eloquent/fluent

Php Sql Laravel Eloquent

Copy data into another table

Sql Sql Server Sql Server-2008

Delete sql rows where IDs do not have a match from another table

GROUP BY with MAX(DATE)

Sql Oracle Group By Greatest N-per-Group Ora 00979

postgresql list and order tables by size

Sql Postgresql Postgresql 9.3

Oracle find a constraint

Sql Oracle Constraints

What does it mean by select 1 from table?

Mysql Sql Plsql

What is the simplest SQL Query to find the second largest value?

How do I reset a sequence in Oracle?

Sql Database Oracle Sequence

List all sequences in a Postgres db 8.1 with SQL

Sql Database Postgresql Migration Sequences

How do you run a single query through mysql from the command line?

Sql Mysql Unix Command Line

How to do a case sensitive search in WHERE clause (I'm using SQL Server)?

How to check existence of user-define table type in SQL Server 2008?

Sql Sql Server Sql Server-2008 Tsql User Defined-Types

How to alter a column's data type in a PostgreSQL table?

Sql Postgresql Psql Alter Table Alter Column

Conversion failed when converting date and/or time from character string while inserting datetime

How to concatenate columns in a Postgres SELECT?

Sql Postgresql Types Concatenation Coalesce

How big is too big for a PostgreSQL table?

Sql Ruby on-Rails Performance Postgresql Database Design

Storing money in a decimal column - what precision and scale?

Sql Database Database Design Currency

Counting null and non-null values in a single query

How to select a record and update it, with a single queryset in Django?

Sql Django Django Models Orm Django Queryset

Select SQL Server database size

Sql Sql Server Sql Server-2008 Sql Server-2008-R2

psql invalid command \N while restore sql

Sql Postgresql Dump

How to execute IN() SQL queries with Spring's JDBCTemplate effectively?

Java Sql Spring Jdbc Jdbctemplate

How to do an INNER JOIN on multiple columns

Oracle "(+)" Operator

Sql Oracle Join Outer Join

SQL UPDATE all values in a field with appended string CONCAT not working

Sql Mysql Concatenation Concat

PostgreSQL: Which Datatype should be used for Currency?

Sql Postgresql Database Design

Count work days between two dates

DataSet panel (Report Data) in SSRS designer is gone

Sql Visual Studio User Interface Reporting Services Toolbox

SQL Call Stored Procedure for each Row without using a cursor

Sql Sql Server Stored Procedures Database Cursor

What is the difference between a stored procedure and a view?

Sql Sql Server-2005 Stored Procedures Views

How do you run a SQL Server query from PowerShell?

Concatenate multiple result rows of one column into one, group by another column

Sql Postgresql Aggregate Functions

How to do INSERT into a table records extracted from another table

How to select the last record of a table in SQL?

Sql Sql Server Sql Server-2008

Right query to get the current number of connections in a PostgreSQL DB

Sql Database Postgresql Dbconnection

How to retrieve the current value of an oracle sequence without increment it?

Sql Oracle Sequence

CROSS JOIN vs INNER JOIN in SQL

Sql Sql Server Sql Server-2008 Tsql Cross Join

Fastest way to determine if record exists

Sql Sql Server Performance Select Count

Difference between BYTE and CHAR in column datatypes

Sql Oracle Unicode Varchar

Removing duplicate rows from table in Oracle

Sql Oracle Duplicates Delete Row

Better techniques for trimming leading zeros in SQL Server?

Sql Sql Server Sql Server-2005 Tsql String

DISTINCT for only one column

Difference between View and table in sql

Return Boolean Value on SQL Select Statement

Sql Select Boolean

What is this operator <=> in MySQL?

Mysql Sql Operators Spaceship Operator

How do I get the MIN() of two fields in Postgres?

Sql Postgresql Min

How can I get the SQL of a PreparedStatement?

Java Sql Jdbc Prepared Statement

How to get last inserted id?

C#Sql Sql Server

sqlite alter table add MULTIPLE columns in a single statement

Sql Sqlite Alter Table

How to select the first row of each group?

Sql Scala Apache Spark Dataframe Apache Spark-Sql

What is the string concatenation operator in Oracle?

Sql Oracle Plsql String Concatenation

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

C#asp.net Sql Database Informix

Fast way to discover the row count of a table in PostgreSQL

Sql Postgresql Count Rowcount

Query for array elements inside JSON type

Sql Json Postgresql Jsonb Lateral

Database Design for Tagging

Sql Database Design Tags Tagging

SQL Server 2005 How Create a Unique Constraint?

Sql Sql Server Constraints

Getting only Month and Year from SQL DATE

Sql Sql Server Tsql

IN vs OR in the SQL WHERE Clause

SQL, Postgres OIDs, What are they and why are they useful?

Sql Database Performance Postgresql

How do you manually execute SQL commands in Ruby On Rails using NuoDB

Sql Ruby on-Rails-3 Activerecord Nuodb

Write a number with two decimal places SQL Server

Sql Sql Server Decimal Number Formatting

Is it possible to use the SELECT INTO clause with UNION [ALL]?

How to do a batch insert in MySQL

Mysql Sql Database Insert

Escaping keyword-like column names in Postgres

SQL Server Operating system error 5: "5(Access is denied.)"

Sql Server equivalent of a COUNTIF aggregate function

Sql Sql Server-2005

Oracle SELECT TOP 10 records

Sql Oracle Top N

SQL Server SELECT LAST N Rows

Sql Sql Server Performance Sql Server-2008

Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?

Sql Database Postgresql Jdbc Ddl

How to generate a range of numbers between two numbers?

Sql Sql Server Tsql Sql Server-2008

Calculate a Running Total in SQL Server

Sql Sql Server Tsql Cumulative Sum

How do I list all tables in a schema in Oracle SQL?

SQL - using alias in Group By

Sql Group By Alias

Can I use CASE statement in a JOIN condition?

Sql Sql Server Join Case

SQL Query Where Field DOES NOT Contain $x

How to add 'ON DELETE CASCADE' in ALTER TABLE statement

Get top n records for each group of grouped results

Mysql Sql Greatest N-per-Group Mysql Variables

Possible to perform cross-database queries with PostgreSQL?

How to find current transaction level?

Sql Sql Server Sql Server-2008 Sql Server-2005 Isolation Level

ORA-00979 not a group by expression

Sql Oracle Ora 00979

SQL Server NOLOCK and joins

Sql Sql Server Nolock

DROP IF EXISTS VS DROP?

LIMIT 10..20 in SQL Server

Sql Sql Server Pagination Limit

Create PostgreSQL ROLE (user) if it doesn't exist

Sql Postgresql Roles Dynamic Sql

SQL order string as number

Mysql Sql String Numbers Sql Order-By

Difference between CTE and SubQuery?

Sql Sql Server Tsql Subquery Common Table-Expression

IndexOf function in T-SQL

Sql Sql Server Tsql String

postgresql: INSERT INTO ... (SELECT * ...)

Sql Postgresql Insert Dblink

Make column not nullable in a Laravel migration

Php Sql Database Migration Laravel

Postgresql query between date ranges

Sql Postgresql Date Intervals Between

MySQL Like multiple values

Mysql Sql Sql Like

What are the pros and cons of performing calculations in sql vs. in your application

Java .Net Sql Performance Postgresql

Implement paging (skip / take) functionality with this query

Sql Sql Server Join Pagination

How can I confirm a database is Oracle & what version it is using SQL?

SQL Server: Is it possible to insert into two tables at the same time?

Sql Sql Server Insert Temp Tables

Is there ever a time where using a database 1:1 relationship makes sense?

Sql Database Design One to-One Database Normalization

How to use NULL or empty string in SQL

Sql Sql Server Null Where

Foreign Key to non-primary key

SQL: Subtracting 1 day from a timestamp date

Sql Postgresql Date Casting Timestamp

Remove the last character in a string in T-SQL?

Sql Sql Server Tsql

How do I make a composite key with SQL Server Management Studio?

Sql Sql Server Tsql Ssms Key

postgresql foreign key syntax

Sql Postgresql Foreign Keys Relational Database Foreign Key-Relationship

SQL Switch/Case in 'where' clause

Sql Switch Statement Case

Efficient SQL test query or validation query that will work across all (or most) databases

Sql Connection Pooling

Escaping ampersand character in SQL string

Sql Oracle Escaping Sqlplus

SQL- Ignore case while searching for a string

Sql Sql Server Case Insensitive Sql Like Ignore Case

Ordering by the order of values in a SQL IN() clause

Mysql Sql Sql Order-By

Imply bit with constant 1 or 0 in SQL Server

Sql Sql Server Tsql Bit

How do I specify "close existing connections" in sql script

Rank function in MySQL

Joins are for lazy people?

C#Java Sql Join

GRANT EXECUTE to all stored procedures

Sql Sql Server Tsql Sql Server-2008 Permissions

Remove Trailing Spaces and Update in Columns in SQL Server

Sql Sql Server-2008 Trailing

How can I find out what FOREIGN KEY constraint references a table in SQL Server?

Sql Sql Server Sql Server-2008

Insert Data Into Temp Table with Query

Sql Sql Server Ssms

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Drop all tables whose names begin with a certain string

Sql Sql Server Dynamic Sql

How do you use script variables in psql?

Sql Postgresql Variables Psql

Comparing Dates in Oracle SQL

Sql Oracle Date Comparison

T-SQL split string

Sql Sql Server Tsql Sql Server-2008 Split

SQL "between" not inclusive

Sql Sql Server Sql Server-2008 Tsql Date

SQL join on multiple columns in same tables

Compare DATETIME and DATE ignoring time portion

Sql Sql Server Tsql Sql Server-2008 Datetime Conversion

Increment value in MySQL update query

Php Mysql Sql Sql Update

SQL query for today's date minus two months

How to identify all stored procedures referring a particular table

Sql Tsql Sql Server-2005

How to get current date & time in MySQL?

Mysql Sql Datetime

SQL-Server: Error - Exclusive access could not be obtained because the database is in use

Sql Sql Server Sql Server-2008

Concatenate columns in Apache Spark DataFrame

Sql Apache Spark Dataframe Apache Spark-Sql

How do I alter the position of a column in a PostgreSQL database table?

Sql Database Postgresql Alter Table

Unknown column in 'field list' error on MySQL Update query

Mysql Sql Mysql Error-1054

Why does NULL = NULL evaluate to false in SQL server

Sql Sql Server Null

How do I add a foreign key to an existing SQLite table?

Sql Sqlite Foreign Keys Ddl

Permanently Set Postgresql Schema Path

What do column flags mean in MySQL Workbench?

Sql Mysql Mysql Workbench

TSQL Pivot without aggregate function

Sql Sql Server Tsql Pivot Pivot without-Aggregate

Define variable to use with IN operator (T-SQL)

MySQL: Can't create table (errno: 150)

Mysql Sql Phpmyadmin Mysql Error-150

Distinct in Linq based on only one field of the table

Run a query with a LIMIT/OFFSET and also get the total number of rows

Sql Postgresql Count Pagination Limit

Database Structure for Tree Data Structure

Sql Database Design Tree

SQL update fields of one table from fields of another one

Sql Postgresql Sql Update Dynamic Sql

Set value to NULL in MySQL

SQL query to find record with ID not in another table

Sql Database Postgresql

Sql query to insert datetime in SQL Server

Sql Sql Server-2008 Datetime

Error in MySQL when setting default value for DATE or DATETIME

Mysql Sql Date Datetime Console

Subqueries vs joins

Sql Mysql Performance Database Design Join

What should I name a table that maps two tables together?

Sql Database Database Design Naming Conventions Data Modeling

Does Foreign Key improve query performance?

Sql Sql Server Performance Indexing Foreign Keys

How to write a simple database engine

Sql Database Theory Database Engine

SQL Server equivalent to MySQL enum data type?

Sql Sql Server Tsql Sql Server-2008 Types

Java - escape string to prevent SQL injection

Java Sql Regex Escaping Sql Injection

What's the difference between NOT EXISTS vs. NOT IN vs. LEFT JOIN WHERE IS NULL?

What's the purpose of SQL keyword "AS"?

The maximum recursion 100 has been exhausted before statement completion

Sql Stored Procedures Common Table-Expression

How to implement LIMIT with SQL Server?

Sql Sql Server Migration

How to report an error from a SQL Server user-defined function

Sql Sql Server Tsql Sql Server-2008 User Defined-Functions

MySQL Select Query - Get only first 10 characters of a value

Mysql Sql Select

Why does using an Underscore character in a LIKE filter give me all the results?

What is Full Text Search vs LIKE

Sql Full Text-Search Sql Like

WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT

Sql Sql Server Tsql Check Constraints

Is the SQL WHERE clause short-circuit evaluated?

Sql Short Circuiting

Can we pass parameters to a view in SQL?

Sql Sql Server Parameters Parameter Passing Views

MySQL "between" clause not inclusive?

Sql Mysql Between

How do I select an entire row which has the largest ID in the table?

Error in SQL script: Only one statement is allowed per batch

Sql Sql Server Visual Studio-2012 Dacpac

What is a 'multi-part identifier' and why can't it be bound?

How do I spool to a CSV formatted file using SQLPLUS?

Sql Oracle Csv Sqlplus

SQL query to group by day

Sql Sql Server Sql Server-2005 Group By

Using a Single Row configuration table in SQL Server database. Bad idea?

Sql Database Design Configuration Relational Database

SQL SERVER: Get total days between two dates

Sql Sql Server Sql Server-2008 Date

SQL Server: Get table primary key using sql query

Convert partially non-numeric text into number in MySQL query

Add new column with foreign key constraint in one command

What is a reasonable length limit on person "Name" fields?

Html Sql Sql Server Textbox Limit

How can I get dict from sqlite query?

Python Sql Sqlite Dictionary Dataformat

SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?

Sql Database Database Design Cascade Relation

What is the difference between SQL and MySQL?

Mysql Sql Database

How do I update if exists, insert if not (AKA "upsert" or "merge") in MySQL?

Sql Mysql Insert Update Upsert

How do I create a SQL table under a different schema?

Sql Sql Server-2008 Ssms

MySQL, update multiple tables with one query

Mysql Sql Sql Update

SQL is null and = null

How to design a database for User Defined Fields?

Sql Database Database Design User Defined-Fields

PostgreSQL - Rename database

Difference between Select Unique and Select Distinct

How to execute an .SQL script file using c#

C#Sql Oracle Scripting

SQL Server indexes - ascending or descending, what difference does it make?

Sql Sql Server Optimization Indexing

LINQ to SQL - Left Outer Join with multiple join conditions

C#Sql Linq Linq to-Sql Outer Join

SQL "select where not in subquery" returns no results

Sql Sql Server Tsql

How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?

Sql Postgresql Casting

How to use SQL Order By statement to sort results case insensitive?

Sql Sqlite Sorting Sql Order-By

How to store a list in a column of a database table

Sql Linq Linq to-Sql Database Design Linq to-Entities

SQLite in Android How to update a specific row

Java Android Sql Eclipse Sqlite

Reference alias (calculated in SELECT) in WHERE clause

Sql Sql Server Tsql

How to get a list column names and datatypes of a table in PostgreSQL?

Sql Postgresql Sqldatatypes

SQL Group By with an Order By

Mysql Sql Mysql Error-1111

How to trim a string in SQL Server before 2017?

How can I define a composite primary key in SQL?

Sql Primary Key Composite Primary-Key

Remove Identity from a column in a table

Sql Sql Server Tsql

Does the order of where clauses matter in SQL?

Sql Performance Where Clause

Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?

Sql Security Sql Server-2000 Sql Injection Sanitization

Alter Table Add Column Syntax

Sql Sql Server Tsql Ddl

SELECT INTO using Oracle

Sql Oracle Ora 00905

How to declare variable and use it in the same Oracle SQL script?

Sql Oracle Variables Declaration

How to check if a function exists in a SQL database?

Sql Sql Server Sql Function

What is SYSNAME data type in SQL Server?

Sql Sql Server Tsql Types

Get the last inserted row ID (with SQL statement)

When to use SELECT ... FOR UPDATE?

Mysql Sql Sql Server Transactions Select for-Update

Case in Select Statement

Sql Sql Server Case

Select row with most recent date per user

Mysql Sql Greatest N-per-Group

Check for changes to an SQL Server table?

Sql Sql Server Datatable Rdbms

Is there a good reason to use upper case for SQL keywords?

Sql Coding Style Capitalization

How do I get a raw, compiled SQL query from a SQLAlchemy expression?

Python Sql Mysql Sqlalchemy

How to list records with date from the last 10 days?

Find most frequent value in SQL column

How do I force Postgres to use a particular index?

Sql Postgresql Indexing

How do I declare and assign a variable on a single line in SQL

Sql Sql Server-2008 Variables

How to extract year and month from date in PostgreSQL without using to_char() function?

Delete duplicate rows from small table

python list in sql query as parameter

PostgreSQL: insert from another table

Sql Postgresql Insert Append

Is it possible to for SQL Output clause to return a column not being inserted?

SQL Server : Columns to Rows

Sql Sql Server Tsql Unpivot

MySQL Select minimum/maximum among two (or more) given values

How to use multiple WITH statements in one PostgreSQL query?

Sql Postgresql Common Table-Expression

Getting raw SQL query string from PDO prepared statements

Php Sql Mysql Pdo Pdostatement

Database design for a survey

Sql Database Design

SQL - Select first 10 rows only?

generate days from date range

Sql Mysql Datetime Between

Using union and order by clause in mysql

Mysql Sql Sql Order-By Union

Check if table exists and if it doesn't exist, create it in SQL Server 2008

Sql Sql Server Tsql Sql Server-2008-R2

How to select only 1 row from oracle sql?

Sql Oracle Oracle9i

sql "LIKE" equivalent in django query

Python Sql Django Django Models Django Queryset

Lock Escalation - What's happening here?

Sql Sql Server Sql Server-2008

SQL - many-to-many table primary key

Sql Primary Key Many to-Many

How to debug PDO database queries?

Naming convention for unique constraint

Sql Sql Server Naming Conventions Unique Constraint

Mysql - How to quit/exit from stored procedure

Mysql Sql Stored Procedures

How to split the name string in mysql?

Mysql Sql Split Substring

How do I format date and time on ssrs report?

Sql Reporting Services Ssrs 2008

Primary key or Unique index?

Sql Database Database Design

Find the number of columns in a table

SQL parser library for Java

Java Sql Parsing

SQL : BETWEEN vs <= and >=

Sql Sql Server Tsql Where Between

Use cases for NoSQL

Sql Mongodb Couchdb Relational Database Nosql

How do I drop table variables in SQL-Server? Should I even do this?

Sql Sql Server Table Variable

Formatting Numbers by padding with leading zeros in SQL Server

Sql Sql Server Tsql String Formatting

How can I join multiple SQL tables using the IDs?

MySQL INNER JOIN select only one row from second table

Mysql Sql Select Inner Join

How to include "zero" / "0" results in COUNT aggregate?

Sql Postgresql Aggregate Functions

printing a value of a variable in postgresql

How can I check if a View exists in a Database?

Sql Sql Server Database Stored Procedures View

How to get next/previous record in MySQL?

How does a PreparedStatement avoid or prevent SQL injection?

Java Sql Jdbc Prepared Statement Sql Injection

How to connect an existing SQL Server login to an existing SQL Server database user of same name

Difference between one-to-many and many-to-one relationship

Sql Relational Database One to-Many Many to-One

How can I create a unique constraint on my column (SQL Server 2008 R2)?

Sql Sql Server Sql Server-2008 Unique Constraint

What's best SQL datatype for storing JSON string?

Sql Sql Server Json

Handling List-types with Esqueleto

Sql List Haskell Esqueleto

How to sort the result from string_agg()

Sql Postgresql String Aggregation

Use tnsnames.ora in Oracle SQL Developer

Sql Oracle Tnsnames Oracle Sqldeveloper

Unioning two tables with different number of columns

Delete all data in SQL Server database

Sql Sql Server Delete Row Multi Table-Delete

The backend version is not supported to design database diagrams or tables

Sql Sql Server Database Ssms

Unknown Column In Where Clause

Mysql Sql Mysql Error-1054

MySQL Insert query doesn't work with WHERE clause

MySQL Results as comma separated list

Sql Mysql Concatenation

SQLite Reset Primary Key Field

String concatenation does not work in SQLite

Sql Sqlite String Operators Concatenation

Boolean vs tinyint(1) for boolean values in MySQL

Storing sex (gender) in database

Sql Database Design

Error Dropping Database (Can't rmdir '.test\', errno: 17)

Mysql Sql Phpmyadmin

Join between tables in two different databases?

Is there an auto increment in sqlite?

Sql Sqlite Cygwin

How can I query a value in SQL Server XML column

Sql Sql Server Xml Xquery

Padding zeros to the left in postgreSQL

Why do we need entity objects?

Sql Database Orm Entities

How do you copy a record in a SQL table but swap out the unique id of the new row?

Sql Sql Server Sql Server-2005 Tsql

Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine

Sql Sqlite Timezone Timestamp

How to create a multi-tenant database with shared table structures?

Sql Mysql Database Design Multi Tenant

What does collation mean?

Sql Sql Server-2005 Tsql Mysql

How to send multiple data fields via Ajax?

Jquery Sql Ajax

Row Offset in SQL Server

What is the reason not to use select *?

Physical vs. logical (hard vs. soft) delete of database record?

Sql Database Database Design Soft Delete Hard Delete

Entity Attribute Value Database vs. strict Relational Model Ecommerce

Sql Database Design Patterns Entity Attribute-Value Key Value

Facebook database design?

Sql Facebook Database Design Database Normalization Database Table

SQL statement to select all rows from previous day

Sql Sql Server Sql Server-2005

Two single-column indexes vs one two-column index in MySQL?

Sql Mysql Database Performance Indexing

SQLite string contains other string query

How can I schedule a job to run a SQL query daily?

Sql Sql Server Database Sql Server-2008 Sql Job

MySQL Multiple Joins in one query?

Real life example, when to use OUTER / CROSS APPLY in SQL

Sql Sql Server Sql Server-2008 Sql Server-2005

Is there any difference between "!=" and "<>" in Oracle Sql?

Good reasons NOT to use a relational database?

Sql Database Nosql

Insert all values of a table into another table in SQL

Sql Sql Server Sql Server-2005

How to count instances of character in SQL Column

Sql String Tsql Count Symbols

How can I convert bigint (UNIX timestamp) to datetime in SQL Server?

Sql Sql Server Tsql Datetime Unix Timestamp

Ruby on Rails: getting the max value from a DB column

Sql Ruby on-Rails

How do I delete a fixed number of rows with sorting in PostgreSQL?

Select something that has more/less than x character

COUNT DISTINCT with CONDITIONS

SQL Server - Create a copy of a database table and place it in the same database?

Sql Sql Server-2008 Tsql Sql Server-2008-R2

Unpivot with column name

Sql Sql Server Sql Server-2008 Tsql Unpivot

How to detect if a stored procedure already exists

Sql Sql Server-2005 Stored Procedures

Illegal mix of collations MySQL Error

Mysql Sql Mysql Error-1267

update columns values with column of another table based on condition

Sql Mysql Sql Server Oracle

In MySQL, how to copy the content of one table to another table within the same database?

Sql Mysql Database

How to remove not null constraint in sql server using query

How to use DISTINCT and ORDER BY in same SELECT statement?

Sql Sql Order-By Distinct

Computed / calculated / virtual / derived columns in PostgreSQL

Sql Postgresql Generated Columns

how to exclude null values in array_agg like in string_agg using postgres?

Sql Postgresql Postgresql 9.1 Postgresql 8.4

Identity increment is jumping in SQL Server database

Sql Sql Server Sql Server-2012 Identity Column

Generating a random & unique 8 character string using MySQL

Split function equivalent in T-SQL?

Sql Sql Server Tsql Sql Server-2008

Can I create a One-Time-Use Function in a Script or Stored Procedure?

Sql Sql Server Sql Server-2005 Tsql Scripting

Difference between FOR and AFTER triggers?

Sql Sql Server-2005 Triggers

How to use Oracle ORDER BY and ROWNUM correctly?

Sql Oracle Sql Order-By Rownum

Cast int to varchar

Mysql Sql Database Casting Mariadb

Generate sql insert script from excel worksheet

Convert HashBytes to VarChar

Copy table structure into new table

Are soft deletes a good idea?

Sql Database Database Design Data Modeling Soft Delete

count(*) vs count(column-name) - which is more correct?

SQL DELETE with INNER JOIN

Mysql Sql Sql Server Inner Join Sql Delete

How can I select multiple columns from a subquery (in SQL Server) that should have one record (select top 1) for each record in the main query?

Why should I capitalize my SQL keywords?

Sql Formatting Readability

SQL Server ':setvar' Error

Sql Sql Server Tsql

SQLite select where empty?

Sql Sqlite Select Isnullorempty

How to find gaps in sequential numbering in mysql?

Mysql Sql Gaps and-Islands

SQLAlchemy: how to filter date field?

Python Sql Database Orm Sqlalchemy

Execute Insert command and return inserted Id in Sql

C#Sql Sql Server asp.net Mvc-4

Dynamic Sorting within SQL Stored Procedures

Sql Tsql Stored Procedures Sorting

How to strip HTML tags from a string in SQL Server?

Html Sql Sql Server String Sql Server-2005

Postgres: How to do Composite keys?

Sql Postgresql Composite Key

What is SELF JOIN and when would you use it?

Getting result of dynamic SQL into a variable for sql-server

Sql Sql Server Sql Server-2005 Tsql Dynamic Sql

sql ORDER BY multiple values in specific order?

Sql Postgresql Sql Order-By

How to implement a many-to-many relationship in PostgreSQL?

Sql Database Postgresql Database Design Many to-Many

How do you version your database schema?

Sql Mysql Schema Versioning

Is there common street addresses database design for all addresses of the world?

Sql Database Design Street Address Postal Code

How do I return rows with a specific value first?

Sql Sql Order-By

select * vs select column

Sql Performance

ALTER DATABASE failed because a lock could not be placed on database

Sql Sql Server-2008 Ssms

Drop multiple tables in one shot in MySQL

Mysql Sql Multiple Tables Drop Table

LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression

C#Mysql Sql Linq

Delete column from SQLite table

How to get the next auto-increment id in mysql

How to return result of a SELECT inside a function in PostgreSQL?

Sql Postgresql Return Plpgsql Return Type

Oracle query to fetch column names

Ordering by specific field value first

Mysql Sql Select Sql Order-By

Rails 4 LIKE query - ActiveRecord adds quotes

Sql Ruby on-Rails Ruby Postgresql Activerecord

Best way to work with transactions in MS SQL Server Management Studio

Sql Tsql Transactions

Using DISTINCT and COUNT together in a MySQL Query

SQLite DateTime comparison

SQL (MySQL) vs NoSQL (CouchDB)

Mysql Sql Nosql Couchdb

Run all SQL files in a directory

Sql Sql Server Batch Processing

What's the best way to join on the same table twice?

How can I get the actual stored procedure line number from an error message?

Sql Sql Server-2005

Difference between datetime and timestamp in sqlserver?

Sql Sql Server Date Time

How to delete the top 1000 rows from a table using Sql Server 2008?

Sql Sql Server Sql Delete

how to increment integer Columns value by 1 in SQL

Sql Sql Server-2005 Sql Update

How to get the first and last date of the current year?

Sql Sql Server Sql Server-2000

Are Databases and Functional Programming at odds?

Sql Database Functional Programming Lisp

PostgreSQL - fetch the rows which have the Max value for a column in each GROUP BY group

Sql Postgresql Query Optimization Cbo Cost Based-Optimizer

Update or Insert (multiple rows and columns) from subquery in PostgreSQL

Sql Postgresql Sql Update

SQL Joins Vs SQL Subqueries (Performance)?

Sql Performance Sql Server-2008 Subquery Join

Converting Select results into Insert script - SQL Server

Sql Sql Server Sql Server-2008 Ssms

postgresql - sql - count of `true` values

PostgreSQL query to return results as a comma separated list

Flat file databases

Php Sql Database Flat File

How do I find a default constraint using INFORMATION_SCHEMA?

Sql Sql Server Tsql Information Schema

Search All Fields In All Tables For A Specific Value (Oracle)

Sql Oracle Search Plsql Database Table

What is your naming convention for stored procedures?

Sql Stored Procedures Naming Conventions

List of special characters for SQL LIKE clause

Sql Special Characters Sql Like

what is the difference between GROUP BY and ORDER BY in sql

Sql Mysql Database

How do I find a "gap" in running counter with SQL?

Sql Gaps and-Islands

How can I see the SQL that will be generated by a given ActiveRecord query in Ruby on Rails

Sql Ruby on-Rails Activerecord

Is the NOLOCK (Sql Server hint) bad practice?

Sql Sql Server Tsql Sql Server-2008 Nolock

mysql - how many columns is too many?

How to change column order in a table using sql query in sql server 2005?

Sql Sql Server-2005

Group by month and year in MySQL

Sql Mysql Group By Date

MySQL JOIN the most recent row only?

Do I need to create indexes on foreign keys on Oracle?

Sql Oracle Indexing

How to find the size of an array in postgresql

Sql Arrays Postgresql Size

How to make Sequelize use singular table names

Mysql Sql node.js sequelize.js

SELECT * FROM tablename WHERE 1

Sql Select Query

Is there a version control system for database structure changes?

Sql Database Oracle Version Control

Why do people hate SQL cursors so much?

Sql Database Cursor

How do I delete from multiple tables using INNER JOIN in SQL server

Sql Sql Server Tsql

IDENTITY_INSERT is set to OFF - How to turn it ON?

Sql Sql Server Tsql

Lightweight SQL editor for Eclipse

Sql Eclipse Editor Eclipse Plugin

How can I append a string to an existing field in MySQL?

Mysql Sql String Append

How to select only the first rows for each unique value of a column?

Sql Sql Server Tsql Select Unique

ActiveRecord: List columns in table from console

Sql Ruby on-Rails Ruby on-Rails-3 Activerecord

How do I use variables in Oracle SQL Developer?

Sql Oracle Variables Declare

SQL Server 2008: How to query all databases sizes?

Sql Sql Server Tsql Sql Server-2008-R2

Could not find an implementation of the query pattern

C#Sql Silverlight Wcf Linq

SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry

Sql Sql Server Sql Server-2012 Identity

Select data from date range between two dates

SQL: capitalize first letter only

Can we have multiple "WITH AS" in single sql - Oracle SQL

Favourite performance tuning tricks

Sql Sql Server Database Performance

Database Design for Revisions?

Sql Database Database Design Versioning

Why is iterating through a large Django QuerySet consuming massive amounts of memory?

Sql Django Postgresql Django Orm

postgresql return 0 if returned value is null

Can we use join for two different database tables?

Display names of all constraints for a table in Oracle SQL

Sql Oracle Oracle11g Constraints

Add a column to existing table and uniquely number them on MS SQL Server

How to assign an exec result to a sql variable?

Sql Sql Server Tsql Stored Procedures

Avoid duplicates in INSERT INTO SELECT query in SQL Server

Sql Sql Server Tsql Sql Insert

org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

Java Sql Postgresql Jdbc

WITH (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Sql Sql Server Sql Server-2005

MySQL: Transactions vs Locking Tables

Sql Mysql Transactions Locking

SQL error "ORA-01722: invalid number"

Sql Oracle Plsql Casting Type Conversion

How to select rows that have current day's timestamp?

Mysql Sql Timestamp

DateTime format to SQL format using C#

MySQL combine two columns into one column

How to select from subquery using Laravel Query Builder?

Sql Laravel Laravel 4 Eloquent Query Builder

Postgresql tables exists, but getting "relation does not exist" when querying

How do I rename a column in a database table using SQL?

Sql Database Rename

A beginner's guide to SQL database design

Sql Database Database Design Scalability

SQL to determine minimum sequential days of access?

Sql Sql Server Date Gaps and-Islands

How to delete from multiple tables in MySQL?

Mysql Sql Mysql Error-1064 Sql Delete

Grant execute permission for a user on all stored procedures in database?

Sql Sql Server Sql Server-2000

MySQL - why not index every field?

Mysql Sql Indexing

How can I insert values into a table, using a subquery with more than one result?

Sql Insert Subquery

Simple way to transpose columns and rows in SQL?

Sql Sql Server Tsql Pivot

What's the difference between comma separated joins and join on syntax in MySQL?

Mysql Sql Join Syntax

How do you list the primary key of a SQL Server table?

Sql Sql Server Tsql

SQL UPDATE SET one column to be equal to a value in a related table referenced by a different column?

How do I get textual contents from BLOB in Oracle SQL

Sql Oracle Blob

How to change a table name using an SQL query?

Sql Sql Server Sql Server-2005

Changing the size of a column referenced by a schema-bound view in SQL Server

JPQL IN clause: Java-Arrays (or Lists, Sets...)?

Sql Orm Jpa Jpql Named Query

Python SQL query string formatting

Python Sql String Formatting

Index (zero based) must be greater than or equal to zero

C#asp.net Mysql Sql

How to print VARCHAR(MAX) using Print Statement?

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

Multiple INSERT statements vs. single INSERT with multiple VALUES

Sql Sql Server Performance Sql Server-2008 Tsql

Does PostgreSQL support "accent insensitive" collations?

Sql Postgresql Localization Indexing Pattern Matching

Select Row number in postgres

Sql Postgresql Window Functions

Splitting string into multiple rows in Oracle

Sql String Oracle Plsql Tokenize

subquery in FROM must have an alias

Sql Oracle Postgresql Subquery

How to find a table having a specific column in postgresql

Sql Database Postgresql Postgresql 9.1

What does Include() do in LINQ?

MySQL 'create schema' and 'create database' - Is there any difference

Sql Mysql Oracle Jdbc Database

How to quickly edit values in table in SQL Server Management Studio?

Sql Sql Server Ssms

How do I import .sql files into SQLite 3?

How to apply bindValue method in LIMIT clause?

Php Mysql Sql Pdo Bindvalue

PostgreSQL, checking date relative to "today"

T-SQL: Using a CASE in an UPDATE statement to update certain columns depending on a condition

Sql Sql Update Case

T-SQL datetime rounded to nearest minute and nearest hours with using functions

Sql Sql Server Tsql Sql Server-2008

C# SQL Server - Passing a list to a stored procedure

C#Sql Stored Procedures

SQL Server reports 'Invalid column name', but the column is present and the query works through management studio

Django select only rows with duplicate field values

Sql Django Django Orm

How to show all privileges from a user in oracle?

Sql Oracle Rules Privileges

MySql : Grant read only options?

Comparing date ranges

Can you use an alias in the WHERE clause in mysql?

Mysql Sql Having Having Clause

Is there a way to access the "previous row" value in a SELECT statement?

Sql Sql Server Sql Server-2008

How do I change db schema to dbo

Sql Sql Server Database Sql Server-2008 Schema

How do I insert datetime value into a SQLite database?

Sql Datetime Sqlite

TSQL - Cast string to integer or return default value

SQL SELECT speed int vs varchar

Sql Performance Postgresql Select

What is a good reason to use SQL views?

sqlalchemy: how to join several tables by one query?

Python Sql Join Sqlalchemy

How to query database by id using SqlAlchemy?

Python Sql Model Sqlalchemy

"CASE" statement within "WHERE" clause in SQL Server 2008

Sql Sql Server Case

MySQL offset infinite rows

Mysql Sql Sql Limit

Querying data by joining two tables in two database on different servers

Sql Sql Server Database Sql Server-2005 Sql Server-2008

The transaction log for the database is full

Sql Sql Server Sql Server-2008 Dynamics Crm

MIN/MAX vs ORDER BY and LIMIT

efficient way to implement paging

Sql Sql Server asp.net Mvc Linq to-Sql Pagination

Best way to test SQL queries

Sql Unit Testing

Is a one column table good design?

Sql Database Design

SQL Server Script to create a new user

Sql Sql Server Database

Oracle SQL, concatenate multiple columns + add text

Sql Oracle Concatenation

Double colon (::) notation in SQL

Sql Postgresql Casting

Is having an 'OR' in an INNER JOIN condition a bad idea?

Sql Sql Server Sql Server-2008 Tsql Inner Join

How to print SQL statement in codeigniter model

Php Sql Codeigniter

Most efficient conversion of ResultSet to JSON?

Java Sql Json Resultset

Why do we always prefer using parameters in SQL statements?

Sql Sql Server Sql Injection

GROUP BY to combine/concat a column

Sql Sql Server Sql Server-2008 Group By

Calculating Cumulative Sum in PostgreSQL

Sql Postgresql Window Functions Analytic Functions Cumulative Sum

Simple Random Samples from a Sql database

Mysql Sql Postgresql Random

Convert varchar to uniqueidentifier in SQL Server

Sql Sql Server-2005 Uniqueidentifier

Repair all tables in one go

Foreign keys in mongo?

Sql Mongodb Foreign Keys Nosql

Division ( / ) not giving my answer in postgresql

Sql Postgresql Division Modulo

Paging with Oracle

Sql Oracle Stored Procedures

SQL Server - where is "sys.functions"?

Sql Sql Server Sql Server-2005 Stored Functions

Execution sequence of Group By, Having and Where clause in SQL Server?

Sql Sql Server Sql Server-2005

MySQL: Invalid use of group function

Mysql Sql Mysql Error-1111

MySQL: Selecting multiple fields into multiple variables in a stored procedure

Sql Mysql Stored Procedures Sql Function

varbinary to string on SQL Server

Sql Sql Server Sql Server-2005 Tsql

In SQL Server, when should you use GO and when should you use semi-colon ;?

Generate random int value from 3 to 6

Sql Sql Server Sql Server-2008

View's SELECT contains a subquery in the FROM clause

Mysql Sql Database Views

Does a UNIQUE constraint automatically create an INDEX on the field(s)?

Mysql Sql Indexing

Postgresql aggregate array

Sql Arrays Postgresql

Subtract one day from datetime

Sql Sql Server Datetime

Is there a better way to dynamically build an SQL WHERE clause than by using 1=1 at its beginning?

Find all records which have a count of an association greater than zero

Sql Ruby on-Rails Ruby on-Rails-3 Activerecord

Update Multiple Rows in Entity Framework from a list of ids

C#Sql asp.net Mvc Entity Framework Sql Update

SQL Server: Get data for only the past year

Sql Sql Server Database Tsql

Cleanest way to build an SQL string in Java

Java Sql Oracle String

How to select unique records by SQL

Importance of varchar length in MySQL table

Sql Mysql Performance Types

When to use a View instead of a Table?

Sql Database Design View

How To Create Table with Identity Column

Sql Sql Server Tsql

How to take last four characters from a varchar?

Sql Sql Server-2008 Tsql

How can I select rows with most recent timestamp for each key value?

Sql Greatest N-per-Group

Connecting to Microsoft SQL server using Python

Python Sql Windows

How can I combine multiple rows into a comma-delimited list in Oracle?

Sql Oracle Concatenation Pivot String Aggregation

Why no love for SQL?

Which SQL query is faster? Filter on Join criteria or Where clause?

Sql Sql Server Tsql Sql Server-2008

Is there a way to list open transactions on SQL Server 2000 database?

Sql Sql Server Transactions Sql Server-2000

MySQL Query to select data from last week?

Mysql Sql Database Datetime

How do I find duplicates across multiple columns?

Sql Sql Server Sql Server-2008 Duplicates

How to test an SQL Update statement before running it?

Mysql Sql Database Testing Myisam

How to kill/stop a long SQL query immediately?

Sql Sql Server Sql Server-2008

Backup a single table with its data from a database in sql server 2008

Sql Sql Server Sql Server-2008

How to Concatenate Numbers and Strings to Format Numbers in T-SQL?

Return rows in random order

Sql Sql Server Tsql

Generate a random number in the range 1 - 10

Sql Postgresql Random

Search an Oracle database for tables with specific column names?

How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?

Mysql Sql Into Outfile

SELECT from nothing?

Django in / not in query

Sort NULL values to the end of a table

Sql Postgresql Null Sql Order-By

Declare variable in SQLite and use it

Sql Sqlite Variables Declaration

How can I alter a primary key constraint using SQL syntax?

Sql Sql Server Primary Key Composite Primary-Key

Delete rows with foreign key in PostgreSQL

Sql Postgresql Foreign Keys Cascading Deletes

How to enable Ad Hoc Distributed Queries

Sql Sql Server-2008

Is the LIKE operator case-sensitive with SQL Server?

Sql Sql Server-2005 Varchar Sql Like

unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

Sql Sql Server Tsql Sql Server-Data-Tools

What are the uses for Cross Join?

Sql Database Join Relational Database

How to use variables in SQL statement in Python?

Simplest way to do a recursive self-join?

Sql Sql Server Recursion Hierarchical Data Self Join

alternatives to REPLACE on a text or ntext datatype

Sql Sql Server Tsql

Grouping into interval of 5 minutes within a time range

Mysql Sql Group By

Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?

Sql Transactions Ddl Create Table

NOT DEFERRABLE versus DEFERRABLE INITIALLY IMMEDIATE

1052: Column 'id' in field list is ambiguous

Mysql Sql Database Join Mysql Error-1052

SQLite - How do you join tables from different databases?

Sql Database Sqlite Join

Get mySQL MONTH() to use leading zeros?

LISTAGG in Oracle to return distinct values

Sql Oracle Aggregate Functions Listagg

SQL to Entity Framework Count Group-By

Sql Entity Framework Linq to-Entities Count Group By

Search of table names

Sql Sql Server Sql Server-2008-R2

Optimal way to concatenate/aggregate strings

Sql Sql Server Azure Aggregate Functions Azure Sql-Database

Checking for empty or null JToken in a JObject

Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?

Sql Database Stored Procedures

SQL function as default parameter value?

Sql Sql Server Stored Procedures

What are projection and selection?

Sql Database Relational Algebra

How to select bottom most rows?

Sql Sql Server Database Select Keyword

In MySQL queries, why use join instead of where?

Sql Mysql Database

How to force a SQL Server 2008 database to go Offline

Sql Sql Server Tsql Sql Server-2008

Execute raw SQL using Doctrine 2

Php Sql Doctrine

Export database schema into SQL file

Sql Sql Server Database Tsql Export

Comparison of Relational Databases and Graph Databases

Sql Relational Database Graph Databases

Add a column to a table with a default value equal to the value of an existing column

Sql Sql Server-2008

How to group by month from Date field using sql

Sql Sql Server Tsql

Is it safe to not parameterize an SQL query when the parameter is not a string?

C#Sql Sql Injection Sqlcommand Parameterized Query

How do I ignore ampersands in a SQL script running from SQL Plus?

Sql Oracle Sqlplus

SQL Server: Make all UPPER case to Proper Case/Title Case

Sql Sql Server Uppercase Title Case

ALTER TABLE without locking the table?

Sql Mysql Ddl Alter Table

How can I list ALL grants a user received?

Sql Oracle Sql Grant

Generating random strings with T-SQL

Sql Tsql Random

MySQL syntax for Join Update

How to get execution time in rails console?

Sql Ruby on-Rails Time Console

Compare dates in MySQL

Mysql Sql Comparison

How to use index in select statement?

Sql Database Indexing

MySQL - Operand should contain 1 column(s)

Mysql Sql Mysql Error-1241

How to SUM two fields within an SQL query

Naming of ID columns in database tables

Sql Naming Conventions

How do you create a temporary table in an Oracle database?

Sql Oracle Temp Tables

Select where count of one field is greater than one

SQL Server 2008: how do I grant privileges to a username?

Sql Sql Server Sql Server-2008 Ssms

Select max value of each group

Display an array in a readable/hierarchical format

Is there any good dynamic SQL builder library in Java?

Java Sql Sqlbuilder

Read SQL Table into C# DataTable

C#.Net asp.net Sql Datatable

Query grants for a table in postgres

Sql Postgresql Sql Grant

How to get max value of a column using Entity Framework?

C#Sql Entity Framework Max

PostgreSQL unnest() with element number

Sql Arrays Postgresql Window Functions Set Returning-Functions

SQLite - replace part of a string

Multiple queries executed in java in single statement

Java Mysql Sql Jdbc

How to select a column name with a space in MySQL

SQL LEFT JOIN Subquery Alias

Sql Subquery Left Join

Avoid division by zero in PostgreSQL

Sql Postgresql Null Aggregate Functions Divide by-Zero

How to detect query which holds the lock in Postgres?

Sql Postgresql Locking

Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually

Mysql Sql Database Intellij Idea Mysql Workbench

SQL - Query to get server's IP address

What does "select count(1) from table_name" on any database tables mean?

Sql Database Oracle

MySQL "WITH" clause

Mysql Sql Common Table-Expression

Commands out of sync; you can't run this command now

Php Sql Mysql Mysqli

Get the week start date and week end date from week number

Sql Sql Server Date Sql Server-2005 Week Number

Java Programming - Where should SQL statements be stored?

Aggregate function in an SQL update query?

Sql Sql Server Tsql

Add Foreign Key relationship between two Databases

Sql Sql Server Tsql Foreign Keys

Arithmetic overflow error converting numeric to data type numeric

Sql Sql Server-2008

How to print GETDATE() in SQL Server with milliseconds in time?

Sql Sql Server Sql Server-2008 Datetime Getdate

Is there StartsWith or Contains in t sql with variables?

Sql Sql Server-2008 Tsql

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio

Sql Sql Server-2005

COALESCE Function in TSQL

Sql Sql Server Sql Server-2008 Tsql

How to check if field is null or empty in MySQL?

How do I copy data from one table to another in postgres using copy command

Sql Postgresql Copy

SQL selecting rows by most recent date with two unique columns

Why isn't SQL ANSI-92 standard better adopted over ANSI-89?

Sql Join Ansi Sql Ansi 92

sql primary key and index

Sql Sql Server Tsql Indexing Primary Key

MySQL "Group By" and "Order By"

Mysql Sql Group By Sql Order-By Aggregate Functions

How to delete from a table where ID is in a list of IDs?

Sql Database Design

Can I have H2 autocreate a schema in an in-memory database?

Java Sql Database H2

Store select query's output in one array in postgres

Sql Arrays Postgresql Plpgsql

Partition Function COUNT() OVER possible using DISTINCT

Sql Sql Server Tsql Sql Server-2008-R2 Sql Server-2014

what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?

Java Sql Hibernate Java Annotations

How to change Column size of varchar type in mySQL?

What is the difference between `->>` and `->` in Postgres SQL?

Sql Json Postgresql

How to create relationships in MySQL

Mysql Sql Foreign Keys Relational Database

Replace Default Null Values Returned From Left Outer Join

Mysql Sql Sql Server Tsql Sql Server-2008

Restrict varchar() column to specific values?

Sql Sql Server-2008 Ssms

SQL standard to escape column names?

How to do a Postgresql subquery in select clause with join in from clause like SQL Server?

Sql Sql Server Postgresql Subquery

SQL how to compare two tables for same data content?

When using MySQL's FOR UPDATE locking, what is exactly locked?

MYSQL Dump only certain rows

Mysql Sql Mysqldump

IN Clause with NULL or IS NULL

Sql Postgresql Null Conditional Statements In Clause

django models: get list of id

Sql Django Django Models

When would I use XML instead of SQL?

MySql - Way to update portion of a string?

Mysql Sql String Sql Update

SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)

Sql Mysql Database Sqlite Upsert

Describe table structure

SQL set values of one column equal to values of another column in the same table

Retrieve the maximum length of a VARCHAR column in SQL Server

Sql Sql Server String Length Maxlength

MySQL, Concatenate two columns

SQL update trigger only when column is modified

Sql Sql Server Triggers

IF-THEN-ELSE statements in postgresql

Spring JPA @Query with LIKE

Java Jquery Sql Spring Jpa

Postgresql extract last row for each id

Sql Postgresql Greatest N-per-Group

Android Room @Delete with parameters

Java Android Sql Android Room

Insert Update stored proc on SQL Server

Sql Sql Server Stored Procedures Upsert

How to determine the number of days in a month in SQL Server?

Sql Sql Server Datetime Date User Defined-Functions

Return number of rows affected by UPDATE statements

How long should SQL email fields be?

Sql Varchar Convention

Why are joins bad when considering scalability?

sqlalchemy filter multiple columns

Python Sql Database Sqlalchemy

How to exclude rows that don't join with another table?

Create SQL script that create database and tables

Show MySQL host via SQL Command

Mysql Sql Database

Get most recent row for given ID

Mysql Sql Greatest N-per-Group

cannot get simple PostgreSQL insert to work

Sql Postgresql String Constant

SQL split values to multiple rows

Mysql Sql Delimiter Csv

How to get/generate the create statement for an existing hive table?

Sql Hive Hiveql

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0

Sql Sql Server-2012 Sqlexception

WHERE Clause to find all records in a specific month

Sql Sql Server-2008

How to filter SQL results in a has-many-through relation

Mysql Sql Postgresql Sql Match-All Relational Division

In SQL Server, what does "SET ANSI_NULLS ON" mean?

Sql Tsql Stored Procedures

How to Alter Constraint

How to find third or nᵗʰ maximum salary from salary table?

Sql Sql Server Sql Server-2008

How to get current instance name from T-SQL

Sql Sql Server Tsql Sql Server-2008r2-Express

Difference between INNER JOIN and LEFT SEMI JOIN

What is a columnar database?

What is the difference between "LINQ to Entities", "LINQ to SQL" and "LINQ to Dataset"

C#Sql Linq Dataset Entities

Is it better to create an index before filling a table with data, or after the data is in place?

Sql Database Postgresql Indexing

How to check for null/empty/whitespace values with a single test?

Sql Oracle Oracle10g

Storing DateTime (UTC) vs. storing DateTimeOffset

Sql Sql Server Tsql Sql Server-2008 Datetimeoffset

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

Sql Sql Server Tsql Sql Server-2008 Full Text-Search

TSQL - How to use GO inside of a BEGIN .. END block?

Sql Sql Server Tsql Sql Server-2008

SQL Column definition : default value and not null redundant?

Rails 3 execute custom sql query without a model

Sql Ruby on-Rails

A strange operation problem in SQL Server: -100/-100*10 = 0

Sql Sql Server Tsql Operator Precedence

Removing leading zeroes from a field in a SQL statement

Sql Sql Server Tsql

How to create a unique index on a NULL column?

Sql Sql Server Indexing Constraints Unique

Should I commit or rollback a read transaction?

Sql Database Transactions

What are good alternatives to SQL (the language)?

MySQL "IN" operator performance on (large?) number of values

Mysql Sql Performance Operators

How to get first/top row of the table in Sqlite via Sql Query

SQL WHERE condition is not equal to?

Mysql Sql Where Clause Negate

Postgres: Add constraint if it doesn't already exist

Sql Postgresql Constraints

Deleting duplicate rows from sqlite database

Sql Database Sqlite

How to change the column position of MySQL table without losing column data?

SQL NVARCHAR and VARCHAR Limits

Sql Sql Server Sql Server-2008 Variables String Concatenation

SQL Server : GROUP BY clause to get comma-separated values

Sql Sql Server-2008

Relationship of Primary Key and Clustered Index

Sql Sql Server Database Database Design

How to delete multiple rows in SQL where id = (x to y)

Cannot execute script: Insufficient memory to continue the execution of the program

Sql Tsql Sql Server-2012

mysql delete under safe mode

PostgreSQL: Remove attribute from JSON column

Sql Json Postgresql Postgresql Json

How to copy a row from one SQL Server table to another

INSERT vs INSERT INTO

Sql Sql Server Tsql

What is SQL injection?

Sql Sql Injection Security

conditional unique constraint

Sql Sql Server Sql Server-2005

Checking for an empty field with MySQL

Php Sql Mysql Null

How to insert table values from one database to another database?

Sql Sql Server-2005 Integration Append

How can I do SELECT UNIQUE with LINQ?

Sql Visual Studio Linq Select Unique

MySQL DELETE FROM with subquery as condition

Mysql Sql Subquery Sql Delete In Subquery

Update one MySQL table with values from another

Xcode 4 and Core Data: How to enable SQL Debugging

Sql Ios Core Data Xcode4

Rails find record with zero has_many records associated

Sql Ruby on-Rails Activerecord Has Many

How do I grant myself admin access to a local SQL Server instance?

Sql Sql Server Sql Server-2008 Ssms Sqlcmd

how to update the multiple rows at a time using linq to sql?

C#Sql Entity Framework Linq Linq to-Sql

Calculating distance between two points (Latitude, Longitude)

Sql Sql Server Tsql Math Sql Server-2008-R2

MySQL Error 1264: out of range value for column

Mysql Sql Insert Integer

Add Auto-Increment ID to existing table?

Mysql Sql Definition Auto Increment

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions

Sql Sql Server Database Sql Server-2012 Sql Query-Store

Index for finding an element in a JSON array

Sql Json Postgresql Indexing Jsonb

SQL Server: Invalid Column Name

Sql Sql Server Sql Server-2008 Stored Procedures

'^M' character at end of lines

Sql Unix Newline Line Endings Os Dependent

How to read the last row with SQL Server

Are there disadvantages to using a generic varchar(255) for all text-based fields?

Mysql strip time component from datetime

Sql Mysql Datetime

What's the best way to select the minimum value from several columns?

Sql Sql Server Tsql Sql Server-2005 Min

Dynamic SQL - EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)

Sql Sql Server Dynamic

New line in Sql Query

SQL server ignore case in a where expression

Sql Sql Server Where Clause Case Insensitive

SQL Row_Number() function in Where Clause

Sql Sql Server Tsql Analytic Functions

Maximum size for a SQL Server Query? IN clause? Is there a Better Approach

Sql Sql Server Tsql Limits

Is there a C# IN operator?

C#Sql Operators In Operator

Delete duplicate records in SQL Server?

Sql Tsql Duplicates Delete Row

How to call a stored procedure from Java and JPA

Java Sql Stored Procedures Jpa Jboss

MySQL query finding values in a comma separated string

Sql Mysql Database

Drop a temporary table if it exists

creating a random number using MYSQL

SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12

Sql Sql Order-By

How to execute raw queries with Laravel 5.1?

Php Mysql Sql Database Laravel 5.1

Cleansing User Passwords

Php Sql Pdo Hash

How can I have multiple common table expressions in a single SELECT statement?

Sql Sql Server Sql Server-2008 Tsql Common Table-Expression

SQL Server table creation date query

Sql Sql Server Tsql Sql Server-2005

SCOPE_IDENTITY() for GUIDs?

Sql Sql Server Guid Uniqueidentifier Scope Identity

How to add a column and make it a foreign key in single MySQL statement?

Use a LIKE statement on SQL Server XML Datatype

Sql Sql Server Xml Sql Server-2005

MySQL: Order by field size/length

Sql Mysql Sql Order-By

Remove trailing zeros from decimal in SQL Server

Sql Tsql Sql Server-2008 Formatting Decimal

How to find the size of a table in SQL?

converting int to real in sqlite

Sql Sqlite Casting Division

How to get Database Name from Connection String using SqlConnectionStringBuilder

C#asp.net Sql ado.net

Empty IN clause parameter list in MySQL

Mysql Sql In Clause

Can you have if-then-else logic in SQL?

How to select id with max date group by category in PostgreSQL?

Sql Postgresql Greatest N-per-Group

Include in SELECT a column that isn't actually in the database

Oracle DateTime in Where Clause?

Sql Oracle Time Date Arithmetic

Sort by column ASC, but NULL values first?

Sql Postgresql Null Sql Order-By

Integrity constraint violation: 1452 Cannot add or update a child row:

Query comparing dates in SQL

Sql Sql Server Date Compare

SQL query: Delete all records from the table except latest N?

Mysql Sql Sql Delete

Foreign key referring to primary keys across multiple tables?

Sql Foreign Keys Primary Key

T-SQL: Looping through an array of known values

Sql Sql Server Tsql

including parameters in OPENQUERY

Sql Parameters Openquery

Clustered vs Non-Clustered

Sql Performance Sql Server-2008 Indexing

Rename a constraint in SQL Server?

Sql Sql Server Constraints

How to separate DATE and TIME from DATETIME in MySQL?

Php Mysql Sql Datetime

Insert data in 3 tables at a time using Postgres

Sql Postgresql Common Table-Expression Sql Insert Sql Returning

Printing integer variable and string on same line in SQL

Sql Sql Server Tsql

Disable all table constraints in Oracle

The most sophisticated way for creating comma-separated Strings from a Collection/Array/List?

Java Sql String

Script entire database SQL-Server

Sql Sql Server Sql Server-2008

Primary key/foreign Key naming convention

Sql Database Design Naming Conventions

What are database constraints?

Sql Sql Server Constraints Rdbms

delete all from table

Sql Mysql Ms Access Optimization Performance

Does the order of columns matter in a group by clause?

Sql Sql Server Group By

MySQL - how to front pad zip code with "0"?

Sql Mysql Database Database Design

Copy data from one column to other column (which is in a different table)

Declare Variable for a Query String

Sql Sql Server Sql Server-2005 Tsql Dynamic Sql

Why doesn't SQL Server support unsigned datatype?

Sql Sql Server Sqldatatypes Unsigned Integer

How to create a temporary function in PostgreSQL?

Sql Postgresql Sql Function

How to insert a timestamp in Oracle?

ORA-00904: invalid identifier

Sql Database Oracle Ora 00904

I want to copy table contained from one database and insert onto another database table

Mysql Sql Mysqldump

How to round down to nearest integer in MySQL?

Mysql Sql Rounding

How do you force mysql LIKE to be case sensitive?

Mysql Sql Case Sensitive Sql Like

Django: Adding "NULLS LAST" to query

Python Sql Django

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

Sql Select Where Clause Advantage Database-Server Sql Delete

How to run a SQL query on an Excel table?

Sql Excel Filtering

Is there a way to persist a variable across a go?

Sql Sql Server Sql Server-2008 Sql Server-2012 Sql Server-2000

Oracle SQL escape character (for a '&')

Sql Oracle Escaping Oracle Sqldeveloper

SQL Server, division returns zero

How many rows in a database are TOO MANY?

Sql Mysql Database Performance

PostgreSQL Index Usage Analysis

Sql Database Design Postgresql

Find stored procedure by name

Sql Database Sql Server-2005 Ssms

How to drop multiple tables in PostgreSQL using a wildcard

querying WHERE condition to character length?

Sql Conditional Statements Where

How to hide result set decoration in Psql output

PostgreSQL IF statement

Sql Postgresql If Statement Plpgsql

Difference between LIKE and ~ in Postgres

Sql Regex Postgresql Syntax

PostgreSQL: how to convert from Unix epoch to date?

Sql Postgresql Date Type Conversion Epoch

How do I convert a database row into a struct

Select multiple columns from a table, but group by one

Laravel Advanced Wheres how to pass variable into function?

Php Sql Laravel

How to check the maximum number of allowed connections to an Oracle database?

Copy a table (including indexes) in postgres

Sql Postgresql Indexing

How can you get the active users connected to a postgreSQL database via SQL?

Sql Postgresql Active Users

How do I create a parameterized SQL query? Why Should I?

Sql vb.net Sql Parametrized-Query

How can I merge two MySQL tables?

Sql Mysql Merge

Is it necessary to manually close and dispose of SqlDataReader?

C#Sql .Net ado.net

Delete from two tables in one query

Combining UNION and LIMIT operations in MySQL query

Mysql Sql Union Limit

MySQL "CREATE TABLE IF NOT EXISTS" -> Error 1050

Sql Mysql Mysql Error-1050

How do I write LINQ's .Skip(1000).Take(100) in pure SQL?

.Net Sql Sql Server

Explanation of self-joins

Why do I get "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." when I try to use sp_executesql?

Sql Sql Server Tsql Dynamic Sql

How to generate a new Guid in stored procedure?

Sql Sql Server Stored Procedures

SQL Server: How to check if CLR is enabled?

Sql Sql Server Clr

Select NOT IN multiple columns

Sql Database Multiple Columns

Invalid default value for 'dateAdded'

Using group by on two fields and count in SQL

T-SQL and the WHERE LIKE %Parameter% clause

Sql Sql Server-2008 Tsql

Remove uniqueness of index in PostgreSQL

Sql Database Postgresql

could not extract ResultSet in hibernate

Java Sql Hibernate Spring Mvc

eloquent laravel: How to get a row count from a ->get()

Php Sql Laravel Eloquent

Export result set on Dbeaver to CSV

Sql Csv Dbeaver

Drop all tables command

Sql Sqlite Rdbms Database

Equivalent of Oracle's RowID in SQL Server

Sql Sql Server Tsql Rowid Row Number

SQL SELECT multi-columns INTO multi-variable

Sql Sql Server Teradata

is there an advantage to varchar(500) over varchar(8000)?

Sql Sql Server Tsql

max(length(field)) in mysql

How to rethrow the same exception in SQL Server

Sql Sql Server Database Tsql Exception

What does a (+) sign mean in an Oracle SQL WHERE clause?

Applying the MIN aggregate function to a BIT field

Sql Sql Server Tsql

What are practical differences between `REPLACE` and `INSERT ... ON DUPLICATE KEY UPDATE` in MySQL?

Mysql Sql Insert Replace

SQL Server - copy stored procedures from one db to another

Sql Sql Server-2008 Copy Procedures

Update query using Subquery in Sql Server

Sql Sql Server Tsql Sql Update

How to use a calculated column to calculate another column in the same view

What are views good for?

Sql View Rdbms Agnostic

Get a list of dates between two dates

Mysql Sql Date Gaps and-Islands

Fulltext Search with InnoDB

Sql Mysql Search Full Text-Search Innodb

Delete all rows in a table based on another table

SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

Sql Sql Server Tsql

How do SQL EXISTS statements work?

Calculating time difference between 2 dates in minutes

Mysql Sql Timestamp

How to remove unique key from mysql table

Mysql Sql Unique Key

MySQL SELECT DISTINCT multiple columns

Mysql Sql Distinct

Filter Table Before Applying Left Join

Sql Join Filter Where Clause

Getting random row through SQLAlchemy

Python Sql Database Random Sqlalchemy

Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)

Mysql Sql Transactions

Difference between RIGHT & LEFT JOIN vs RIGHT & LEFT OUTER JOIN in SQL

Sql Join Left Join Outer Join Right Join

MySQL get row position in ORDER BY

Sql Mysql Analytic Functions

SQL sum with condition

How to delete from select in MySQL?

Sql Mysql Select Uniqueidentifier Subquery

SQL 'like' vs '=' performance

Sql Performance

Must declare the scalar variable

Sql Sql Server Stored Procedures

Find records with a date field in the last 24 hours

Sequence vs identity

Sql Sql Server Tsql Sql Server-2012

How to properly set up a PDO connection

Php Mysql Sql Class Pdo

SELECT INTO in MySQL

Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

When is a timestamp (auto) updated?

Mysql Sql Timestamp

MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB

Mysql Sql Create Table

Is there a LastIndexOf in SQL Server?

Sql Sql Server Sql Server-2016

Get month and year from a datetime in SQL Server 2005

Delete all but top n from database table in SQL

Why does Sql Server keep executing after raiserror when xact_abort is on?

Sql Sql Server Tsql

Natural Sort in MySQL

Sql Mysql Sorting Natural Sort

Getting list of tables, and fields in each, in a database

How do I rename an Index in MySQL

Sql Mysql Indexing

Subquery using Exists 1 or Exists *

Sql Sql Server Tsql

How to delete duplicate entries?

Sql Postgresql Duplicate Removal Unique Constraint Sql Delete

ORA-00972 identifier is too long alias column name

Sql Oracle Alias

Database Naming Conventions by Microsoft?

Sql Sql Server Tsql

use current date as default value for a column

SQL Query to get column values that correspond with MAX value of another column?

Mysql Sql Group By Max Aggregate Functions

Find all columns of a certain type in all tables in a SQL Server database

Sql Sql Server-2008

Rails: How to find_by a field containing a certain string

Sql Ruby on-Rails Ruby on-Rails-3 Ruby on-Rails-3.1

FULL OUTER JOIN vs. FULL JOIN

Sql Sql Server-2008 Tsql Join

ListAGG in SQLSERVER

Sql Sql Server Aggregate

sql: check if entry in table A exists in table B

Is it necessary to use # for creating temp tables in SQL server?

Sql Sql Server Sql Server-2008 Sql Server-2005

how to move tables from public to other schema in Postgres

Sql Postgresql Postgresql 9.1

Functions vs Stored Procedures

Sql Sql Server Database Function Stored Procedures

SQL query to make all data in a column UPPER CASE?

Is this the proper way to do boolean test in SQL?

Sql Boolean Expression

Is there any reason to worry about the column order in a table?

Mysql Sql Database Table

SQL Server Plans : difference between Index Scan / Index Seek

Sql Sql Server Sql Execution-Plan

How can I get the number of records affected by a stored procedure?

Sql Sql Server Oracle Tsql Plsql

Get the records of last month in SQL server

Sql Sql Server Tsql

SQL LIKE condition to check for integer?

Can I do a max(count(*)) in SQL?

Sql Sql Order-By Greatest N-per-Group Window Functions

SQL - Does the order of WHERE conditions matter?

Get all characters before space in MySQL

SQL grouping by month and year

Android SQLite: Update Statement

Android Sql Sqlite

Simple DateTime sql query

Sql Sql Server Sql Server-2005 Tsql Sql Server-2008

Rounding SQL DateTime to midnight

Sql Sql Server Sql Server-2005 Getdate

How to convert all tables in database to one collation?

SQL - IF EXISTS UPDATE ELSE INSERT INTO

Mysql Sql Insert Exists

How can I log the generated SQL from DbContext.SaveChanges() in my Program?

C#Sql Entity Framework Logging Dbcontext

How to create a new schema/new user in Oracle Database 11g?

Sql Database Design Oracle11g Schema Database

"Data too long for column" - why?

How do I do a simple 'Find and Replace" in MsSQL?

How do you interpret a query's explain plan?

Sql Database Performance Oracle Sql Execution-Plan

How to order by column A and then by column B?

Sql Select Sql Order-By

how to get the 30 days before date from Todays Date

Sql Sql Server Datetime

How do I select all the columns from a table, plus additional columns like ROWNUM?

Sql Oracle Select

How to get the size of a varchar[n] field in one SQL statement?

Sql Sql Server-2008 Varchar

PostgreSQL visual interface similar to phpMyAdmin?

Can I reuse a calculated field in a SELECT query?

Mysql Sql Mysql Error-1054

How do I extract data from a DataTable?

How to get First and Last record from a sql query?

Why use Select Top 100 Percent?

Sql Sql Server Tsql

Difference of two date time in sql server

Sql Sql Server Datetime

How to escape simple SQL queries in C# for SqlServer

C#Sql Sql Server

How to log SQL statements in Grails

Sql Logging Grails

Using an Alias column in the where clause in Postgresql

Sql Postgresql Column Alias

Returning Month Name in SQL Server Query

Sql Sql Server-2008 Type Conversion

Aggregate function in SQL WHERE-Clause

Data is Null. This method or property cannot be called on Null values

C#asp.net Sql Stored Procedures

Improve SQL Server query performance on large tables

Sql Sql Server Sql Server-2008

SQL Server JOIN missing NULL values

SQL Coalesce with empty string

Select Top 1 field and assign to local variable

How to compare datetime with only date in SQL Server

Sql Sql Server Tsql Datetime

How to select all the columns of a table except one column?

Laravel 5 Eloquent where and or in Clauses

Sql Laravel Eloquent

ALTER TABLE DROP COLUMN failed because one or more objects access this column

C#Sql Sql Server Code First

Generate SQL Create Scripts for existing tables with Query

Sql Sql Server Tsql

How to insert into a table with just one IDENTITY column?

Sql Sql Server Identity

Error importing SQL dump into MySQL: Unknown database / Can't create database

Mysql Sql Mysqldump Mysql Error-1049 Mysql Error-1007

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

Sql Sql Server Stored Procedures

How to make a view column NOT NULL

Sql Sql Server-2008 Nullable Sql View

dbms_lob.getlength() vs. length() to find blob size in oracle

Sql Oracle Blob

How do you update a DateTime field in T-SQL?

Sql Sql Server Tsql Types

Simple PHP Pagination script

Php Sql Pagination

mysql too many indexes?

Sql Mysql Indexing

How to find rows that have a value that contains a lowercase letter

sqlite copy data from one table to another

Do clustered indexes have to be unique?

Sql Database Tsql Sql Server-2008 Clustered Index

Column calculated from another column?

mysql SQL: specific item to be first and then to sort the rest of the items

EF 4.1 exception "The provider did not return a ProviderManifestToken string"

asp.net Sql Entity

Difference between Top and Limit Keyword in SQL

Strip last two characters of a column in MySQL

Mysql Sql String

Huge performance difference when using GROUP BY vs DISTINCT

Sql Performance Group By Distinct Hsqldb

Delete statement in SQL is very slow

Sql Sql Server Sql Server-2008 Database Optimization

Cannot use UPDATE with OUTPUT clause when a trigger is on the table

Sql Sql Server Sql Server-2008-R2

String or binary data would be truncated. The statement has been terminated

ERROR 1148: The used command is not allowed with this MySQL version

Mysql Sql Import

Getting the current date in SQL Server?

Sql Sql Server Sql Server-2008 Datetime Current Time

What does the "@" symbol do in SQL?

handling DATETIME values 0000-00-00 00:00:00 in JDBC

Java Sql Date Jdbc

Doctrine 2: Update query with query builder

Php Sql Database Doctrine

Return multiple fields as a record in PostgreSQL with PL/pgSQL

Sql Postgresql Stored Procedures Types Plpgsql

How to get export output in "real" CSV format in SQL Server Management Studio?

Sql Sql Server Csv Ssms

How to use SQL Select statement with IF EXISTS sub query?

Sql Sql Server Exists

Perform insert for each row taken from a select?

Sql Sql Server-2008 Tsql Insert

MySQL pivot row into dynamic number of columns

Mysql Sql Pivot

SQL versus noSQL (speed)

Query to get only numbers from a string

LEFT OUTER JOIN in Rails 4

Sql Ruby on-Rails Ruby on-Rails-4 Rails Activerecord Mysql2

Create or replace trigger postgres

Sql Postgresql Ddl Database Trigger

Why use "where 1=2" on a SQL CREATE TABLE syntax?

SQL distinct for 2 fields in a database

Watching variables in SSIS during debug

Sql Sql Server-2005 Debugging Ssis Watch

How do I UPDATE a row in a table or INSERT it if it doesn't exist?

Mysql Sql Sqlite Postgresql Upsert

Storing UUID as base64 String

Java Sql Bytearray Base64 Uuid

MySQL: Typecasting NULL to 0

Sql Mysql Casting

SELECT FOR UPDATE with SQL Server

Sql Sql Server Sql Server-2005 Tsql Read Committed-Snapshot

Fastest way to copy a table in mysql?

SELECTING with multiple WHERE conditions on same column

Mysql Sql Aggregate Functions Where Clause

MySQL: How to insert a record for each result in a SQL query?

Mysql Sql Loops Insert

WHERE statement after a UNION in SQL?

Can parameterized statement stop all SQL injection?

Sql Sql Injection Code Injection Exploit

Why not use varchar(max)?

Sql Tsql Sql Server-2008 Varcharmax

Why is SQL server throwing this error: Cannot insert the value NULL into column 'id'?

Transfer data from one database to another database

Sql Sql Server Sql Server-2008

Export table data from one SQL Server to another

Sql Sql Server Sql Server-2005 Export

CASE .. WHEN expression in Oracle SQL

Sql Oracle Oracle10g

How to count rows with SELECT COUNT(*) with SQLAlchemy?

Python Sql Sqlalchemy

Count how many rows have the same value

Table storage engine for <TABLE> doesn't have this option on order by query (ERROR 1031)

Boolean 'NOT' in T-SQL not working on 'bit' datatype?

Sql Sql Server Tsql Boolean Operations

Are Parameters really enough to prevent Sql injections?

asp.net Sql Database Sql Injection

Tinyint vs Bit?

Sql Mysql Sql Server Types

SQL grouping by all the columns

What is "Advanced" SQL?

Synchronizing client-server databases

Sql Database Design Patterns Client Server Data Synchronization

Command for adding a default constraint

Sql Sql Server Tsql Default Constraint

MySQL: Curdate() vs Now()

Mysql Sql Datetime

Count distinct values

How do I get just the date when using MSSQL GetDate()?

Sql Sql Server Tsql Date Datetime

SQL NOT IN not working

Best way to delete millions of rows by ID

Sql Postgresql Bigdata Sql Delete Postgresql Performance

Trying to modify a constraint in PostgreSQL

Sql Postgresql Alter

How to test run an UPDATE statement in PostgreSQL?

Sql Database Postgresql

CURRENT_TIMESTAMP in milliseconds

Mysql Sql Postgresql Datetime Timestamp

How do you check if IDENTITY_INSERT is set to ON or OFF in SQL Server?

Sql Sql Server Identity Insert

how to extract only the year from the date in sql server 2008?

Sql Sql Server-2008 Datetime Extract

Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column

Sql Sql Server Csv

Group by minimum value in one field while selecting distinct rows

Sql Group By Max Distinct Min

SQL Error: ORA-01861: literal does not match format string 01861

Sql Oracle Sql Insert

Multiple CTE in single query

Sql Postgresql Common Table-Expression Arel Recursive Cte

SQL Query - Using Order By in UNION

Sql Ms Access Sorting Sql Order-By Union

ORDER BY items must appear in the select list if SELECT DISTINCT is specified

Sql Sql Server Tsql

SQL Identity (autonumber) is Incremented Even with a Transaction Rollback

.Net Sql Sql Server-2005 Transactions Identity Column

DBCC CHECKIDENT Sets Identity to 0

Is SQL IN bad for performance?

Sql Sql Server-2000

How to compare values which may both be null in T-SQL

Sql Sql Server Tsql Stored Procedures

Auto Increment after delete in MySQL

Sql Mysql Primary Key Auto Increment

MySQL: How to add one day to datetime field in query

Update table values from another table with the same user name

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

Mysql Sql Phpmyadmin Innodb Mysql Error-1025

How to Select a substring in Oracle SQL up to a specific character?

Sql Oracle Substring Trim

Get Multiple Values in SQL Server Cursor

Sql Sql Server Tsql Database Cursor

A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

Java Mysql Sql Datetime Jdbc

The total number of locks exceeds the lock table size

How to update selected rows with values from a CSV file in Postgres?

Sql Database Postgresql File Io Csv

Discard millisecond part from timestamp

Sql Postgresql Casting Timestamp Rounding

Creating new database from a backup of another Database on the same server?

Sql Database Sql Server-2008

What is the difference between IFNULL and COALESCE in MySQL?

Mysql Sql Sql Server

Select info from table where row has max date

Sql Sql Server-2005 Greatest N-per-Group

GROUP BY without aggregate function

Sql Oracle Group By Aggregate Functions

Importing data from a MySQL database into a Pandas data frame including column names

Python Mysql Sql Pandas Numpy

How do I flip a bit in SQL Server?

Sql Sql Server Bit Manipulation

NULL in MySQL (Performance & Storage)

MySQL - Selecting data from multiple tables all with same structure but different data

Sql Mysql Join Mysql Error-1052

How to do IF NOT EXISTS in SQLite

Sql script to find invalid email addresses

Sql Validation Email

In SQL, is UPDATE always faster than DELETE+INSERT?

Sql Sql Insert Sql Delete

What should be the best way to store a percent value in SQL-Server?

Sql Sql Server Tsql Types

Move SQL data from one table to another

Updating entry WITHOUT updating timestamp

Mysql Sql Timestamp

Inserting rows into a table with one IDENTITY column only

Sql Sql Server Tsql Stored Procedures

Left Outer Join using + sign in Oracle 11g

Completely copying a postgres table with SQL

Sql Postgresql Data Migration

ALTER table - adding AUTOINCREMENT in MySQL

Mysql Sql Alter Table

SQL Server - boolean literal?

Sql Sql Server Boolean Literals

unwrap postgresql array into rows

Sql Arrays Postgresql

PostgreSQL: using a calculated column in the same query

Sql Postgresql Calculated Columns Column Alias

Can I parameterize the table name in a prepared statement?

exec failed because the name not a valid identifier?

Sql Sql Server Sql Server-2008

Google spreadsheet "=QUERY" join() equivalent function?

Sql Google Sheets Google Query-Language

Can a foreign key refer to a primary key in the same table?

Sql Foreign Keys Primary Key

Postgresql LEFT JOIN json_agg() ignore/remove NULL

Sql Json Postgresql Postgresql 9.3

Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

Sql Postgresql Roles Ddl Database Administration

Search for "whole word match" in MySQL

Mysql Sql Full Text-Search

MySQL SELECT last few days?

Indexing boolean fields

Sql Mysql Database Indexing

Can MySQL convert a stored UTC time to local timezone?

Mysql Sql Timezone Convert Tz

Mysql 1050 Error "Table already exists" when in fact, it does not

Mysql Sql Mysql Error-1146 Mysql Error-1050

SQL Query: order by length of characters?

What are valid table names in SQLite?

What is it exactly a BLOB in a DBMS context

Sql Oracle Blob Database Blobstore

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

Mysql Sql Ms Access Import Dump

Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Sql asp.net Mvc Windows Server-2003 Sql Server-2005-Express

Get execution time of PostgreSQL query

Sql Postgresql Performance Timing

Adding a leading zero to some values in column in MySQL

Mysql Sql Database

Select a Column in SQL not in Group By

Sql Sql Server-2008 Tsql Greatest N-per-Group

Alter a SQL server function to accept new optional parameter

Sql Sql Server-2005

SUM of grouped COUNT in SQL Query

Delete many rows from a table using id in Mysql

Mysql Sql Sql Delete

PostgreSql INSERT FROM SELECT RETURNING ID

Sql Postgresql Insert Postgresql 9.2

How to check if an array is empty in Postgres

Sql Arrays Postgresql Stored Procedures Null

Oracle SQL - DATE greater than statement

Sql Oracle Date Format

How to create a Date in SQL Server given the Day, Month and Year as Integers

Performance differences between equal (=) and IN with one literal value

Mysql Sql Postgresql Equals Operator In Operator

What is the difference between single quotes and double quotes in PostgreSQL?

How do I concatenate text in a query in sql server?

Difference between drop table and truncate table?

Sql Sql Server Sybase

What does a transaction around a single statement do?

Sql Sql Server Transactions

How do I return the SQL data types from my query?

Sql Sql Server Tsql Sql Server-2008

Timestamp Difference In Hours for PostgreSQL

Sql Postgresql Timestamp

Change a Nullable column to NOT NULL with Default Value

Sql Sql Server Default Value Alter Table Alter Column

Replace null with 0 in MySQL

remove duplicates from sql union

Use LIKE %..% with field values in MySQL

Mysql Sql Sql Like

Alternative to column name "order" in MySQL

Why does the Contains() operator degrade Entity Framework's performance so dramatically?

C#Sql Performance Entity Framework-4 Contains

Split comma separated column data into additional columns

Sql Postgresql Split Delimiter Postgresql 8.4

Can't drop table: A foreign key constraint fails

Mysql Sql Drop Table

MySQL variable format for a "NOT IN" list of values

Mysql Sql In Clause

How can I include null values in a MIN or MAX?

Sql Sql Server Tsql

Error when connect database continuously

C#Sql Azure Azure Sql-Database

Rebuild all indexes in a Database

Sql Sql Server Indexing Sql Server-2008-R2

Howto? Parameters and LIKE statement SQL

asp.net Sql vb.net

How to update rows with a random date

How do composite indexes work?

Sql Indexing Composite

Create a SQL query to retrieve most recent records

Sql Tsql Derived Table

SQL: sum 3 columns when one column has a null value?

OVER clause in Oracle

Sql Oracle Window Functions

SQLite - ORDER BY RAND()

Sql Mysql Database Sqlite Random Access

Does sqlite support any kind of IF(condition) statement in a select

How can I introduce multiple conditions in LIKE operator?

Seeing the underlying SQL in the Spring JdbcTemplate?

Sql Jdbc Spring Jdbc

SQlite: select into?

How to find column names for all tables in all databases in SQL Server

Sql Sql Server Tsql Database Schema

How to handle a single quote in Oracle SQL

Sql Oracle Escaping

sql error errno: 121

Mysql Sql Mysql Error-1064 Mysql Error-1005

Efficient way to do batch INSERTS with JDBC

Java Sql Performance Jdbc

Can I add a not null column without DEFAULT value

Sql Sql Server Sql Server-2005 Tsql

Add column to table and then update it inside transaction

Sql Sql Server Tsql Transactions Alter Table

Export a CREATE script for a database

Sql Database Postgresql

In Postgres, how do you restrict possible values for a particular column?

SQL multiple join statement

SQL Select between dates

Best way to create a temp table with same columns and type as a permanent table

How to return the output of stored procedure into a variable in sql server

Sql Sql Server Variables Stored Procedures

How to do the Recursive SELECT query in MySQL?

Mysql Sql Query Optimization Recursive Query

MySQL SELECT AS combine two columns into one

MySQL Sum() multiple columns

Empty array as PostgreSQL array column default value

What difference between the DATE, TIME, DATETIME, and TIMESTAMP Types

Mysql Sql Datetime

How do I perform a GROUP BY on an aliased column in SQL Server?

Sql Sql Server Tsql Syntax

Delete the 'first' record from a table in SQL Server, without a WHERE condition

How to limit rows in PostgreSQL SELECT

Sql Postgresql Sql Limit

Create a Cumulative Sum Column in MySQL

Mysql Sql Cumulative Sum

Simple check for SELECT query empty result

Sql Sql Server Database

Should every SQL Server foreign key have a matching index?

Sql Sql Server Tsql

Which table exactly is the "left" table and "right" table in a JOIN statement (SQL)?

GROUP BY - do not group NULL

Mysql Sql Group By

PostgreSQL: Create schema in specific database

Sql Database Schema Postgresql

Using ISNULL vs using COALESCE for checking a specific condition?

Sql Tsql Coalesce Isnull

Is varchar(MAX) always preferable?

Sql Sql Server Tsql

Comparing results with today's date?

Sql Sql Server Current Time

Update records in table from CTE

Sql Sql Server Tsql Common Table-Expression

Strange PostgreSQL "value too long for type character varying(500)"

Sql Database Django Postgresql Postgresql 9.1

Get RETURN value from stored procedure in SQL

SQL Performance UNION vs OR

Mysql Sql Performance Union

GROUP BY having MAX date

Mysql Sql Optimization Greatest N-per-Group

What is "Connect Timeout" in sql server connection string?

How to drop all NOT NULL constraints from a PostgreSQL table in one go

Sql Postgresql Constraints Sql Drop Notnull

How to join only one row in joined table with postgres?

Sql Postgresql Join

When can I save JSON or XML data in an SQL Table

Sql Json Xml Normalization Structured Data

Key value pairs in relational database

Best way to get result count before LIMIT was applied

Php Sql Postgresql Window Functions Sql Limit

SQL Statement indentation good practice

Sql Coding Style Indentation

Is it possible to output a SELECT statement from a PL/SQL block?

Sql Oracle Plsql Oracle10g Oracle Apex

Search for a string in all tables, rows and columns of a DB

Sql Sql Server-2005

Convert integer to hex and hex to integer

Sql Sql Server Integer Hex

Add row to query result using select

Sql Sql Server Tsql Select Insert

Conditional Count on a field

Sql Count Conditional Statements

How to flip bit fields in T-SQL?

Sql Sql Server Tsql

How do I find the data directory for a SQL Server instance?

Sql Sql Server Sql Server-2008 Sql Server-2005 Sql Server-2008-R2

Comparing SQL and Prolog

Most efficient way to store IP Address in MySQL

Mysql Sql Ip Address

How can I see CakePHP's SQL dump in the controller?

How to generate the whole database script in MySQL Workbench?

Mysql Sql Database Mysql Workbench

Calculate Age in MySQL (InnoDb)

Does Dapper support the like operator?

MySQL : transaction within a stored procedure

Mysql Sql Stored Procedures Transactions

SQL Server Invalid Column name after adding new column

Sql Sql Server Sql Server-2008 Tsql Sql Server-2005

How to execute .sql file using powershell?

Sql Sql Server Powershell Powershell Module

How to find sum of multiple columns in a table in SQL Server 2005?

Sql Sql Server Sql Server-2005

How can I get all sequences in an Oracle database?

Sql Database Oracle Sequence Toad

How to Select Top 100 rows in Oracle?

Difference between query, native query, named query and typed query

Sql Hibernate Jpa Native Sql

How to get SQL from Hibernate Criteria API (not for logging)

Java Sql Hibernate Criteria

Is it possible to have a default parameter for a mysql stored procedure?

Sql Mysql Stored Procedures Default Value

SQL Join Table Naming Convention

Sql Sql Server Naming Conventions

Insert multiple values using INSERT INTO (SQL Server 2005)

Sql Sql Server Sql Server-2005 Tsql

How to drop all stored procedures at once in SQL Server database?

Sql Sql Server Tsql

From Now() to Current_timestamp in Postgresql

Sql Datetime Postgresql

How to show row numbers in PostgreSQL query?

Sql Database Postgresql

MySQL how to fill missing dates in range?

Mysql Sql Recursive Query Gaps and-Islands Date Arithmetic

what's the escape sequence for hyphen (-) in PostgreSQL

Sql Postgresql Escaping

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

Php Sql Mysql Pdo Mysql Error-1064

Select NULL Values in SQLAlchemy

Python Sql Database Sqlalchemy

ORA-12560: TNS:protocol adaptor error

Sql Oracle Oracle9i Ora 12560

How to use andWhere and orWhere in Doctrine?

Php Sql Doctrine

List rows after specific date

Sql Sql Server Sql Server-2008 Sql Server-2005

SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE

Sql Sql Server-2008

How to select records without duplicate on just one field in SQL?

Sql Select Duplicates Distinct

SQLite Order By Date1530019888000

Sql Sqlite Android Sqlite Sql Order-By

Find duplicate rows with PostgreSQL

Sql Database Ruby on-Rails-3 Duplicates Postgresql 9.2

SQL like search string starts with

SQL Get all records older than 30 days

Conditional WHERE clause in SQL Server

Sql Sql Server Sql Server-2008 Tsql Where Clause

Truncate/Clear table variable in SQL Server 2008

Sql Sql Server Tsql

How to COALESCE for empty strings and NULL values?

Sql Postgresql Coalesce

Most efficient way in SQL Server to get date from date+time?

Sql Sql Server Tsql

How do I find records that are not joined?

Sql Select Join Anti Join

How to resolve ambiguous column names when retrieving results?

Php Sql Mysql Mysql Error-1052

Parsing SQL code in C#

Can you define "literal" tables in SQL?

Sql Mysql Subquery Temp Tables

how do you insert null values into sql server

Sql Sql Server Null

What do you do in SQL Server to CREATE OR ALTER?

Sql Sql Server Tsql

Using an Alias in SQL Calculations

Mysql Sql Database Syntax

Only inserting a row if it's not already there

Sql Sql Server Tsql Concurrency Locking

Get count of records affected by INSERT or UPDATE in PostgreSQL

Sql Postgresql Sql Update

Create parameterized VIEW in SQL Server 2008

Why can't I use "create schema" in a begin/end block in SQL Management Studio?

Sql Sql Server Tsql

Standard use of 'Z' instead of NULL to represent missing data?

Sql Database Design Null Standards Rdbms

Rails where date is greater than given date query

Sql Ruby on-Rails-3

How to extract group from regular expression in Oracle?

Should I set max pool size in database connection string? What happens if I don't?

Sql Sql Server-2008 Connection String Connection Pooling

Get the latest date from grouped MySQL data

Mysql Sql Date Greatest N-per-Group

How do I use properly CASE..WHEN in MySQL

Mysql Sql Conditional Switch Statement Case

Select a column if other column is null

Sql Sql Server Tsql

How to do join on multiple criteria, returning all combinations of both criteria

Sql Sql Server Join

SQL Inner join more than two tables

How to avoid error "aggregate functions are not allowed in WHERE"

Mysql Sql Aggregate Functions

How to find the users list in oracle 11g db?

How to remove duplicates, which are generated with array_agg postgres function

Sql Postgresql Select Array Agg

Querying Spark SQL DataFrame with complex types

Sql Scala Apache Spark Dataframe Apache Spark-Sql

Loading .sql files from within PHP

Php Sql Mysql Import Scripting

How to do select from where x is equal to multiple values?

What is the difference between function and procedure in PL/SQL?

Sql Stored Procedures Function Plsql

How do I get the current year using SQL on Oracle?

Sql Oracle Date

How to find rows in one table that have no corresponding row in another table

Sql Optimization H2

List stored functions that reference a table in PostgreSQL

Sql Postgresql Metaprogramming

SQL DELETE with JOIN another table for WHERE condition

Mysql Sql Delete Row Sql Delete Mysql Error-1093

Foreign key reference to table in another schema

Sql Oracle Database Design

how to check type of value in postgres

What is the purpose of system table master..spt_values and what are the meanings of its values?

Sql Sql Server Database Design Configuration

SQL Server silently truncates varchar's in stored procedures

Sql Sql Server Stored Procedures Truncate Truncation

MySQL Trigger after update only if row has changed

Mysql Sql Database Triggers

Postgresql: Check if Schema Exists?

Are Views automatically updated

T-SQL Substring - Last 3 Characters

Sql Sql Server Sql Server-2005 Tsql

How to find which views are using a certain table in SQL Server (2008)?

Sql Sql Server Views

JPA 2 CriteriaQuery, using a limit

Java Sql Jpa Persistence Limit

How SQL query result insert in temp table?

SQL Server 2008- Get table constraints

Sql Sql Server Sql Server-2008 Constraints

DateTime group by date and hour

Get 2 Digit Number For The Month

Sql Sql Server Sql Server-2008 Tsql

How to use order by with union all in sql?

Get Table and Index storage size in sql server

Sql Sql Server Sql Server-2008 Indexing

MYSQL syntax not evaluating not equal to in presence of NULL

Can I use VARCHAR as the PRIMARY KEY?

Mysql Sql Primary Key Unique Varchar

Difference between language sql and language plpgsql in PostgreSQL functions

Sql Function Postgresql Stored Procedures Plpgsql

How to delete duplicate rows without unique identifier

Sql Database Postgresql Duplicates Netezza

Cannot access field in Big Query with type ARRAY<STRUCT<hitNumber INT64, time INT64, hour INT64, ...>>

Sql Nested Google Bigquery

What's the difference between a Table Scan and a Clustered Index Scan?

Sql Sql Server Indexing

Getting return value from stored procedure in C#

C#Sql Sql Server

Passing an array of parameters to a stored procedure

Sql Sql Server-2005 Stored Procedures

How can multiple rows be concatenated into one in Oracle without creating a stored procedure?

Sql Oracle Concatenation String Aggregation

Understanding how JOIN works when 3 or more tables are involved. [SQL]

SQL comment header examples

What is an efficient way of inserting thousands of records into an SQLite table using Django?

Python Sql Django Sqlite Insert

Difference between Oracle's plus (+) notation and ansi JOIN notation?

Sql Performance Oracle Join

MySQL number of items within "in clause"

Sql Mysql In Clause

SELECT max(x) is returning null; how can I make it return 0?

PostgreSQL GROUP BY different from MySQL?

Sql Mysql Ruby on-Rails Postgresql Heroku

What are NDF Files?

How to use (install) dblink in PostgreSQL?

Sql Postgresql Dblink

How to use table variable in a dynamic sql statement?

Sql Sql Server Sql Server-2008 Dynamic Sql Table Variable

TransactSQL to run another TransactSQL script

Sql Sql Server Tsql Sql Server-2008

Understanding the differences between CUBE and ROLLUP

Sql Sql Server Sql Server-2008 Tsql

Finding the data types of a SQL temporary table

Select from one table where not in another

Use one CTE many times

Sql Sql Server Sql Server-2008 Common Table-Expression

Get the number of rows in table using SQLAlchemy

Python Sql Sqlalchemy

how to execute a .sql script on heroku?

Sql Postgresql Heroku

SQL query to select distinct row with minimum value

Sql Database Greatest N-per-Group

reading external sql script in python

Left Join without duplicate rows from left table

Sql Join Duplicates

Does Order of Fields of Multi-Column Index in MySQL Matter

Mysql Sql Performance Indexing

Pandas read_sql with parameters

Python Sql Pandas Psycopg2

Insert Picture into SQL Server 2005 Image Field using only SQL

Sql Sql Server Sql Server-2005 Image

When or why would you use a right outer join instead of left?

Sql Database Right Join

When shouldn't you use a relational database?

Sql Database Nosql Relational Database

How to retrieve field names from temporary table (SQL Server 2008)

Sql Sql Server Sql Server-2008 Temp Tables

TSQL DATETIME ISO 8601

Sql Sql Server Tsql Datetime

Limit on the WHERE col IN (...) condition

Sql Sql Server Tsql

How to pass a null variable to a SQL Stored Procedure from C#.net code

C#Sql Sql Server Stored Procedures

C# guid and SQL uniqueidentifier

C#Sql Guid Uniqueidentifier

Can I loop through a table variable in T-SQL?

Sql Sql Server Tsql Database Cursor Table Variable

Syntax for INSERTing into a table with no values?

Sql Sql Server Tsql Insert

How to find similar results and sort by similarity?

Mysql Sql String Sorting Similarity

MySQL, coalesce equivalent for empty values?

set default schema for a sql query

Sql Sql Server Schema

how to insert datetime into the SQL Database table?

.Net Sql Sql Server Sql Server-2005 C# 3.0

How to execute Table valued function

Sql Sql Server Sql Server-2008 Tsql

T-SQL: How to Select Values in Value List that are NOT IN the Table?

Sql Sql Server Tsql

SQL Query with NOT LIKE IN

Sql Sql Server-2008 Tsql

How to compare two dates to find time difference in SQL Server 2005, date manipulation

Sql Sql Server-2005 Date Datediff

Postgresql column reference "id" is ambiguous

Sql Postgresql Select

Get everything after and before certain character in SQL Server

mysql update query with sub query

How do I get the creation date of a MySQL table?

Mysql Sql Sql Server Database

How to send email from SQL Server?

Sql Sql Server Tsql Sp Send-Dbmail

Grouping timestamps by day, not by time

Get the SQL query result without the table format

Mysql Sql Shell

PostgreSQL - query from bash script as database user 'postgres'

Sql Bash Postgresql

Optimize GROUP BY query to retrieve latest row per user

Sql Postgresql Indexing Greatest N-per-Group Postgresql Performance

SQL Server IF EXISTS THEN 1 ELSE 2

Sql Sql Server If Statement Stored Procedures Sql Server-2012

Postgres - How to check for an empty array

Sql Arrays Postgresql

Will a SQL Server Job skip a scheduled run if it is already running?

Sql Sql Server Scheduled Tasks Sql Server-Agent

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Sql Sql Server Metadata

MySQL: Compare differences between two tables

Database/SQL: How to store longitude/latitude data?

Sql Mysql Database Performance Sqlperformance

How do you write a conditional in a MySQL select statement?

Datetime in where clause

Sql Sql Server Datetime Sql Server-2005 Filter

Can I Comma Delimit Multiple Rows Into One Column?

Sql Sql Server Sql Server-2008 Tsql

Selecting distinct column values in SQLAlchemy/Elixir

Python Sql Sqlalchemy Python Elixir

Variable value assignment using RETURNING clause

Sql Postgresql Sql Returning

How does MongoDB avoid the SQL injection mess?

Sql Mongodb Sql Injection

SQLite - SELECT TOP syntax error

Count cumulative total in Postgresql

Sql Postgresql Aggregate Functions

Having issues with a MySQL Join that needs to meet multiple conditions

Select * from subquery

Convert SQL to Linq left join with null

C#.Net Sql Linq

How to Create a real one-to-one relationship in SQL Server

Sql Sql Server Entity Framework One to-One

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)

Sql Sql Server-2008 Sql Server-Express

Getting date list in a range in PostgreSQL

Sql Postgresql Date Date Comparison

Inner Joining three tables

What's a PostgreSQL "Cluster" and how do I create one?

Sql Database Postgresql Postgresql 9.1

How to Generate Scripts For All Triggers in Database Using Microsoft SQL Server Management Studio

Sql Sql Server-2008 Triggers

Passing table name as a parameter in psycopg2

Python Sql Postgresql Sql Injection Psycopg2

To ignore duplicate keys during 'copy from' in postgresql

ActiveRecord find_each combined with limit and order

Sql Ruby on-Rails Activerecord

Add a summary row with totals

Sql Sql Server Rollup

Get SQL query count during a Django shell session

Python Sql Django Shell

SQL Left Join first match only

Sql Sql Server Tsql Join Greatest N-per-Group

missing FROM-clause entry for table

How to generate a Guid in SQL Server?

Distinct pair of values SQL

Sql Group By Distinct

SQL SELECT from multiple tables

Sql Select Join Left Join Outer Join

SQL Server replace, remove all after certain character

Sql Sql Server Tsql Replace

MySQL - How to count all rows per table in one query

Sql Mysql Count

How to replace specific values in a oracle database column?

Sql Oracle Replace

What's the right way to compare an NTEXT column with a constant value?

Sql Sql Server Tsql Ntext

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

Python Sql Ms Access Pyodbc

SQL unique varchar case sensitivity question

Mysql Sql Case Sensitive Varchar Unique Constraint

What is the fastest way to truncate timestamps to 5 minutes in Postgres?

Sql Performance Postgresql Datetime

How to include a PHP variable inside a MySQL statement

Php Mysql Sql String Variables

Finding even or odd ID values

Sql Sql Server-2008

SQL: set existing column as Primary Key in MySQL

Mysql Sql Indexing Primary Key

In a join, how to prefix all column names with the table it came from

sql joins as venn diagram

Mysql Sql Visualization Set Theory

Increasing the Command Timeout for SQL command

C#Sql ado.net Connection Timeout

How to subtract 30 days from the current date using SQL Server

Sql Sql Server Sql Server-2008 Sql Server-2012

TRIM is not a recognized built-in function name

Sql Sql Server Tsql

Using an Alias in a WHERE clause

Sql Oracle Alias Decode Ora 00904

How to document a database

Sql Oracle Documentation

Passing multiple values for a single parameter in Reporting Services

Sql Reporting Services Parameters Query String

Why is SQL Server losing a millisecond?

Most recent record in a left join

Sql Sql Server Sql Server-2005

Select a random sample of results from a query result

Sql Oracle Random Sample

Which SQL query is better, MATCH AGAINST or LIKE?

Sql Mysql Database Search

Examples of SQL Injections through addslashes()?

Php Sql Sql Injection Security

How do you drop a default value or similar constraint in T-SQL?

Sql Tsql Constraints Default

Why does MySQL allow "group by" queries WITHOUT aggregate functions?

Mysql Sql Standards Compliance Ansi Sql

Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)

Sql Sql Server Database Design Sql Server-2008

MySQL remove duplicates from big database quick

Sql Mysql Duplicates

Query to check index on a table

Sql Sql Server-2008 Indexing

How to detect if a string contains at least a number?

Sql Sql Server Tsql

How in H2DB get sql dump like in MySql?

Materialized View vs. Tables: What are the advantages?

Sql Oracle Materialized Views

How to check if a string is a uniqueidentifier?

PostgreSQL: SQL script to get a list of all tables that have a particular column as foreign key

Sql Database Postgresql Foreign Keys

Postgresql - select something where date = "01/01/11"

Sql Postgresql Datetime

Doing a WHERE .. IN subquery in Doctrine 2

Sql Database Doctrine Orm

how to increase sqlplus column output length?

Sql Oracle Sqlplus Column Width

SQL Server: Cannot insert an explicit value into a timestamp column

Sql Sql Server-2008 Insert Timestamp

LISTAGG function: "result of string concatenation is too long"

How to return a incremental group number per group in SQL

Sql Sql Server Tsql Group By

How to rollback or commit a transaction in SQL Server

Sql Sql Server Sql Server-2008 Sql Server-2005

SQL Insert into table only if record doesn't exist

Mysql Sql Sql Insert

Hive insert query like SQL

Sql Hadoop Hive Hiveql

Connecting to SQL Server using windows authentication

C#asp.net Sql Sql Server

How to return rows from left table not found in right table?

Sql Join Left Join Outer Join

Composite Primary Keys : Good or Bad?

Sql Database Database Design Relational Database

Split column into multiple rows in Postgres

Sql Postgresql Split Set Returning-Functions

ROW_NUMBER Without ORDER BY

Sql Sql Server Tsql Window Functions

Dynamic Database Schema

Sql Database Design Architecture Dynamic Data

SQL User Defined Function Within Select

Sql Sql Server Select User Defined-Functions

Passing a varchar full of comma delimited values to a SQL Server IN function

Sql Sql Server Tsql Sql In

Running a .sql script using MySQL with JDBC

Java Sql Mysql Jdbc

General rules for simplifying SQL statements

Sql Logic Complexity Theory Reduction

Compare dates in T-SQL, ignoring the time part

Sql Sql Server Sql Server-2005 Tsql

Efficient latest record query with Postgresql

Sql Postgresql Subquery Distinct

CTE error: "Types don't match between the anchor and the recursive part"

Sql Sql Server Tsql Common Table-Expression

How can I tell what edition of SQL Server runs on the machine?

Can an INNER JOIN offer better performance than EXISTS

Sql Sql Server Sql Server-2005 Performance Tsql

How can I alter this computed column in SQL Server 2008?

Sql Sql Server-2008 Edit Alter Calculated Columns

I've caught an exception!! Now what?

Sql vb.net Exception

select a value where it doesn't exist in another table

Sql Sql Server-2000

Why does VARCHAR need length specification?

Sql Database Varchar

Execute SQL script from command line

Sql Sql Server Batch File Command Line Scripting

EXISTS vs JOIN and use of EXISTS clause

Sql Sql Server Sql Server-2005 Sql Server-2008

SQL Server: IF EXISTS ; ELSE

Sql Sql Server If Statement Exists

Using tuples in SQL "IN" clause

Sql Sql Server Tuples Row Value-Expression

How do you find results that occurred in the past week?

Sql Postgresql Date Arithmetic

Alter multiple columns in a single statement

Mysql Sql Mysql Error-1064 Alter Table

How can I tell if a VARCHAR variable contains a substring?

Sql String Contains Sql Server-2012

New Line Issue when copying data from SQL Server 2012 to Excel

Sql Sql Server-2008 Excel Copy Paste Sql Server-2012

MySQL INSERT INTO ... VALUES and SELECT

Mysql Sql Select Insert

Rails includes with conditions

Sql Ruby on-Rails

SQL Server procedure declare a list

Sql Sql Server Sql Server-2008-R2

MySQL and JDBC with rewriteBatchedStatements=true

Java Mysql Sql Jdbc

What is ROWS UNBOUNDED PRECEDING used for in Teradata?

Sql Teradata Window Functions Analytic Functions

Decoding T-SQL CAST in C#/VB.NET

C#Sql vb.net Ascii Hex

Swap unique indexed column values in database

What is a Covered Index?

Sql Database Indexing

Library of Useful (Difficult) SQL scripts

How do I return my records grouped by NULL and NOT NULL?

Sql Null Group By

Doesn't Linq to SQL miss the point? Aren't ORM-mappers (SubSonic, etc.) sub-optimal solutions?

Sql Linq to-Sql Linq to-Entities

Search and replace part of string in database

Sql Sql Server Tsql

How different is PostgreSQL to MySQL?

Sql Mysql Postgresql

SQLException : String or binary data would be truncated

C#Sql Sql Server

SQL: find missing IDs in a table

What is the purpose of constraint naming

Sql Database Constraints Naming

Convert varchar into datetime in SQL Server

Sql Sql Server Sql Server-2008 Tsql Type Conversion

Can MySQL replace multiple characters?

Mysql Sql String Replace

MySQL - Conditional Foreign Key Constraints

Mysql Sql Database Design Foreign Keys Polymorphic Associations

SQLite3 Integer Max Value

Sql Sqlite Integer Ip

PostgreSQL: Case insensitive string comparison

Sql Postgresql String Comparison Case Insensitive

How can I convert a Sql Server 2008 DateTimeOffset to a DateTime

Sql Sql Server Sql Server-2008 Datetime Datetimeoffset

How to select several hardcoded SQL rows?

Mysql Sql Oracle

MYSQL select DISTINCT values in two columns

Is there a way to get a list of all current temporary tables in SQL Server?

Sql Sql Server Sql Server-2000 Temp Tables

SQL Server: how to add new identity column and populate column with ids?

Sql Sql Server Primary Key Database Cursor

Oracle insert from select into table with more columns

How create json format with group-concat mysql?

Mysql Sql Group Concat

What is difference between SQLite and SQL

Android Sql Database Sqlite

How do I get the month and day with leading 0's in SQL? (e.g. 9 => 09)

MySQL LEFT JOIN 3 tables

using sql count in a case statement

sql query distinct with Row_Number

Temporary table in SQL server causing ' There is already an object named' error

Sql Sql Server Tsql Temp Tables

Pandas left outer join multiple dataframes on multiple columns

Python Sql Merge Pandas

Using COALESCE to handle NULL values in PostgreSQL

Sql Database Postgresql Null Coalesce

What is wrong with my SQL here? #1089 - Incorrect prefix key

SQL query to check if a name begins and ends with a vowel

Mysql Sql Select

Linked List in SQL

Sql Data Structures

Fastest way to remove non-numeric characters from a VARCHAR in SQL Server

Sql Sql Server Performance Optimization

Size of VARBINARY field in SQL Server 2005

Sql Sql Server Sql Server-2005 Clr

Most efficient way to get table row count

Mysql Sql Count

How can I change NULL to 0 when getting a single value from a SQL function?

Sql Tsql Null Sum

Truncate Table Within Transaction

Sql Sql Server Sql Server-2005 Transactions Truncate

Why can't I use alias in a count(*) "column" and reference it in a having clause?

Sql Sql Server Alias

Is it faster to access data from files or a database server?

Sql Performance Cgi Flat File

MySQL GROUP BY two columns

Sql Mysql Database

Python: Number of rows affected by cursor.execute("SELECT ...)

Python Sql Rows Database

How do you access the value of an SQL count () query in a Java program

Java Sql Jdbc Count

Transfer data between databases with PostgreSQL

Sql Postgresql Insertion

Stored Procedures Vs. Views

Sql Sql Server-2008 Stored Procedures Comparison Views

Adding a column after another column within SQL

SQL Query to add a new column after an existing column in SQL Server 2005

Sql Sql Server Sql Server-2005

How to check if a column exists before adding it to an existing table in PL/SQL?

Sql Oracle Plsql

What's the recommended location for SQL (DDL) scripts?

MySQL - Replace Character in Columns

Mysql Sql Database

How to Troubleshoot Intermittent SQL Timeout Errors

.Net Sql Sql Server Sql Server-2008 Timeout

How do I import a sql data file into SQL Server?

Sql Sql Server-2008

SQL Server 2008 delete all tables under special schema

Retrieve an object from entityframework without ONE field

C#.Net Sql Entity Framework

How to convert Calendar to java.sql.Date in Java?

Java Sql Calendar

INNER JOIN vs INNER JOIN (SELECT . FROM)

Sql Sql Server Join Inner Join

Calculating difference between two timestamps in Oracle in milliseconds

Sql Oracle Datetime

MySQL - SELECT all columns WHERE one column is DISTINCT

SQL Server find and replace specific word in all rows of specific column

Sql Sql Server Sql Server-2008

How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?

Php Mysql Sql Escaping

Case statement in MySQL

Mysql Sql Database Case

MySQL error 1241: Operand should contain 1 column(s)

Mysql Sql Select Insert Mysql Error-1241

MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint

Mysql Sql Database

Is there a coalesce-like function in Excel?

Sql Excel Xls Coalesce

Get week day name from a given month, day and year individually in SQL Server

Sql Sql Server Function Date

How to find longest string in the table column data

How do I pass a list as a parameter in a stored procedure?

Sql Sql Server Stored Procedures

How do I index a database column

Sql Database Indexing

SQL Server 2005 Using DateAdd to add a day to a date

Sql Sql Server Tsql Date Dateadd

Using WITH NOLOCK Table Hint in Query Using View - Does it Propagate Within the View?

Sql Sql Server Locking

Does End Using close an open SQL Connection

.Net Sql Sql Server vb.net

Oracle: What does `(+)` do in a WHERE clause?

Sql Oracle Operators

How to store a list in a db column

What are Covering Indexes and Covered Queries in SQL Server?

Sql Sql Server Indexing

How to get N rows starting from row M from sorted table in T-SQL

How to Suppress the SELECT Output of a Stored Procedure called from another Stored Procedure in SQL Server?

Sql Sql Server Tsql

Is it possible to run native sql with entity framework?

Sql Entity Framework ado.net

Oracle DB: How can I write query ignoring case?

Sql Database Oracle

What is the most appropriate data type for storing an IP address in SQL server?

Sql Sql Server Types Ip Address Ipv4

Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?

Sql Server Tsql Join Sql

MySQL: Returning multiple columns from an in-line subquery

Sql Mysql Subquery

Questions every good Database/SQL developer should be able to answer

Difference between FULL JOIN & INNER JOIN

Is a Primary Key necessary in SQL Server?

Sql Sql Server Sql Server-2005

Select count of rows in another table in a Postgres SELECT statement

SQLite Query in non case sensitive alphabetical order

Android Sql Sqlite Sql Order-By Collate

Bulk/batch update/upsert in PostgreSQL

Sql Database Postgresql Insert Sql Update

Pass In "WHERE" parameters to PostgreSQL View?

Sql Postgresql Stored Procedures View

Why no windowed functions in where clauses?

Sql Sql Server Tsql Window Functions

What kind of datatype should one use to store hashes?

Sql Sql Server Sql Server-2008 Tsql

SQL Server Case Statement when IS NULL

Sql Sql Server Sql Server-2008

Different CURRENT_TIMESTAMP and SYSDATE in oracle

Sql Oracle Plsql Oracle10g

How to create a large pandas dataframe from an sql query without running out of memory?

Python Sql Pandas Bigdata

Select multiple columns into multiple variables

Sql Oracle Plsql Select Into

Counting number of joined rows in left join

Sql Oracle Join Count Left Join

Postgres - Transpose Rows to Columns

Sql Database Postgresql Crosstab Transpose

How to skip the first n rows in sql query

GROUP BY and COUNT using ActiveRecord

Sql Ruby on-Rails Ruby Postgresql Activerecord

Why doesn't Oracle tell you WHICH table or view does not exist?

Sql Database Oracle Ora 00942

SQL Server Agent Job - Exists then Drop?

Sql Sql Server Sql Server-Agent Sql Job

Boolean Expressions in SQL Select list

Sql Unit Testing Tsql Expression Assert

How can I compare time in SQL Server?

Sql Sql Server Datetime

Is a JOIN faster than a WHERE?

Sql Performance Join Where Clause

SQL query to get most recent row for each instance of a given key

Sql Postgresql Greatest N-per-Group

How do I get the primary key(s) of a table from Postgres via plpgsql?

Sql Postgresql Plpgsql

The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'

Sql Sql Server Permissions Dotnetnuke Sysobjects

LOAD DATA LOCAL, How do I skip the first line?

Sql Mysql Csv Import Load Data-Infile

FULL OUTER JOIN with SQLite

Sql Sqlite Join Full Outer-Join

Is there a good LINQ way to do a cartesian product?

C#Sql asp.net Linq Cartesian Product

Find duplicate entries in a column

Sql Oracle Subquery

nvarchar(max) still being truncated

Sql Sql Server-2008 Dynamic Sql

Common Table Expression, why semicolon?

Sql Sql Server Tsql Sql Server-2008 Common Table-Expression

skip copying to tmp table on disk mysql

How to group by month using SQL Server?

Sql Sql Server-2008 Datediff

See whether an item appears more than once in a database column

SQL Server FOR EACH Loop

Sql Sql Server Tsql

Custom Order in Oracle SQL

Sql Oracle Sql Order-By

Update int column in table with unique incrementing values

Sql Sql Server Sql Server-2008

MySQL - One To One Relationship?

Mysql Sql Database Database Design One to-One

Composite Primary key vs additional "ID" column?

Sql Sql Server Database Database Design

PostgreSQL query to count/group by day and display days with no data

Sql Postgresql Join Group By

Counting number of grouped rows in mysql

Mysql Sql Count

MySQL COUNT with LIMIT

Mysql Sql Limit Sql Limit

How to add plus one (+1) to a SQL Server column in a SQL Query

Sql Sql Server Tsql

Select rows with same id but different value in another column

What is the meaning of SELECT ... FOR XML PATH(' '),1,1)?

TypeError: tuple indices must be integers, not str

Python Sql Database

MySQL: SyntaxError: Unexpected identifier

@@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity

Sql Sql Server Tsql Identity Output Clause

How to select data of a table from another database in SQL Server?

Sql Sql Server Database Linked Server

What does the term "Tuple" Mean in Relational Databases?

Sql Terminology Rdbms Definition Tuples

Downsides to "WITH SCHEMABINDING" in SQL Server?

Sql Sql Server Query Optimization Schemabinding

T-SQL STOP or ABORT command in SQL Server

Sql Sql Server Tsql Sql Scripts

add a temporary column with a value

Count based on condition in SQL Server

Sql Sql Server Tsql

SQL Server LIKE containing bracket characters

Sql Sql Server Pattern Matching

I got error "The DELETE statement conflicted with the REFERENCE constraint"

C#Sql Truncate Sql Delete

The parameterized query expects the parameter which was not supplied

Sql Sql Server vb.net

How can I compare two sets of 1000 numbers against each other?

Php Javascript Sql Algorithm

mysql datetime comparison

Sql Mysql Implicit Conversion Explicit Conversion

How do I swap column values in sql server 2008?

Sql Sql Server Sql Server-2008

Get month name from date in Oracle

Sql Oracle Date

Query to convert from datetime to date mysql

Sql Mysql Datetime Date

How do parameterized queries help against SQL injection?

C#.Net Sql Sql Server-2005 Parameterized Query

How to format bigint field into a date in Postgresql?

Sql Postgresql Date Timestamp Bigint

Best way to reset an Oracle sequence to the next value in an existing column?

Sql Oracle Oracle10g Primary Key Sequence

What is the difference between OFFLINE and ONLINE index rebuild in SQL Server?

combining Date and Time fields to DateTime, SQL Server 2008

Sql Sql Server-2008

How to count the number of instances of each foreign-key ID in a table?

Entity Framework throws exception - Invalid object name 'dbo.BaseCs'

C#Sql asp.net Mvc-3 Entity Framework

ActiveRecord Arel OR condition

Sql Ruby on-Rails Ruby Activerecord Arel

Oracle SQL : timestamps in where clause

Sql Oracle Where Sql Timestamp

How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?

Sql Sql Server Tsql Sql Server-2008-R2 Ansi Sql

MySQL very slow for alter table query

Mysql Sql Alter Table

PostgreSQL MAX and GROUP BY

Sql Postgresql Group By Max Greatest N-per-Group

Update MySQL with if condition

Mysql Sql Sql Update

CASE WHEN statement for ORDER BY clause

Sql Sql Server Sql Server-2008-R2

Allow null in unique column

Sql Postgresql Database Design Null Unique Constraint

Sql connection-string for localhost server

C#Sql Sql Server-2008-Express

Entity Framework The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

C#Sql .Net Sql Server Entity Framework

ERROR 1115 (42000): Unknown character set: 'utf8mb4'

Mysql Sql Character Encoding Utf8mb4

Passing Output parameters to stored procedure using dapper in c# code

C#Sql Sql Server Stored Procedures Dapper

Possible to restore a backup of SQL Server 2014 on SQL Server 2012?

Sql Sql Server Sql Server-2012 Compatibility Sql Server-2014

How to get the trigger(s) associated with a view or a table in PostgreSQL

Sql Database Postgresql

PostgreSQL query to rename and change column type with single query

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

Sql Sql Server Tsql Ssis

Laravel: getting a single value from a MySQL query

Php Mysql Sql Laravel

python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?

Python Sql Pandas Sqlalchemy Pyodbc

Counting the number of occurrences of a substring within a string in PostgreSQL

Sql String Postgresql

SQL Query for Logins

Is it possible to make a recursive SQL query?

Sql Postgresql Recursive Query

How to insert multiple records and get the identity value?

Sql Sql Server Sql Server-2005

Default port for SQL Server

asp.net Sql Sql Server

Hibernate Union alternatives

Java Sql Hibernate Union

Do SQL connections opened with PDO in PHP have to be closed

Php Sql Mysql Pdo

DateTimeOffset.Now in T-SQL

Sql Sql Server Tsql Sql Server-2008 Datetime

Changing the CommandTimeout in SQL Management studio

Sql Ssms Timeoutexception

Column name or number of supplied values does not match table definition

Sql Sql Server Sql Server-2005 Tsql

SQL query for a carriage return in a string and ultimately removing carriage return

Sql Char Carriage Return Sql Like

Can there be constraints with the same name in a DB?

Sql Sql Server Sql Server-2005 Tsql Constraints

Favorite SQL*Plus tips and tricks

Sql Oracle Sqlplus

DROP...CREATE vs ALTER

Sql Sql Server Tsql

SQL Server Int or BigInt database table Ids

SQL to generate a list of numbers from 1 to 100

Sql Oracle Plsql

Can select * usage ever be justified?

Convert Xml to Table SQL Server

Sql Xml Sql Server-2008 Tsql Sql Server-2005

SQL Server 2008: The columns in table do not match an existing primary key or unique constraint

Sql Sql Server Foreign Keys Foreign Key-Relationship

Using a conditional UPDATE statement in SQL

Increment field of mysql database using codeigniter's active record syntax

Mysql Sql Codeigniter Activerecord

Postgresql turn null into zero

Sql Postgresql Null Max

Return pre-UPDATE column values using SQL only

Sql Postgresql Concurrency Sql Update Subquery

Is the 'as' keyword required in Oracle to define an alias?

Sql Oracle Alias Required

Selecting by month in PostgreSQL

Sql Postgresql Date

oracle - what statements need to be committed?

Sql Database Oracle Session Commit

PL/pgSQL checking if a row exists

Sql Postgresql Plpgsql Postgresql 9.1 Exists

Using IF ELSE statement based on Count to execute different Insert statements

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

Are left outer joins and left joins the same?

SQL Server : Arithmetic overflow error converting expression to data type int

Sql Sql Server Tsql

Using setDate in PreparedStatement

Java Sql Oracle Jdbc Prepared Statement

postgresql - view schema privileges

Sql Postgresql Amazon Redshift

Online SQL Query Syntax Checker

PostgreSQL: Create an index to quickly distinguish NULL from non-NULL values

Sql Postgresql Indexing Null

Pyspark: Filter dataframe based on multiple conditions

Sql Filter Pyspark Apache Spark-Sql Pyspark Sql

Generating a range of numbers in MySQL

SQL changing a value to upper or lower case

Sql Case Uppercase Lowercase

Drop MySQL databases matching some wildcard?

MySQL not using indexes with WHERE IN clause?

Sql Mysql Ruby on-Rails Database Optimization

Performance of inner join compared to cross join

Sql Performance

How to release possible Postgres row locks?

Sql Database Postgresql

What is the difference between a hash join and a merge join (Oracle RDBMS )?

Sql Performance Oracle Join

how to use LIKE with column name

How to use BOOLEAN type in SELECT statement

Sql Oracle Plsql Oracle10g Ora 00904

Generate a resultset of incrementing dates in TSQL

Sql Sql Server Database Sql Server-2005 Tsql

SQL: Alias Column Name for Use in CASE Statement

When to use an auto-incremented primary key and when not to?

Sql Database Design

TSQL: Get Last Queries Ran

Sql Tsql History

What does a question mark represent in SQL queries?

Sql Prepared Statement

Use SQL Server time datatype in C#.NET application?

C#.Net Sql Sql Server Time

Select from one table matching criteria in another?

Sql Multiple Tables

Get last record of a table in Postgres

How can I select from list of values in Oracle

Sql Oracle Select Oracle11g

How can I have NHibernate only generate the SQL without executing it?

Sql Nhibernate Fluent Nhibernate

Get MAX value of a BIT column

Sql Sql Server Tsql Sql Server-2008 Stored Procedures

How to get the latest record in each group using GROUP BY?

Mysql Sql Greatest N-per-Group

Entity Framework error: Cannot insert explicit value for identity column in table

C#Sql Entity Framework

Is there a way to define a named constant in a PostgreSQL query?

How to write SQL in a migration in Rails

Sql Postgresql Ruby on-Rails-3 Migration Rails Activerecord

Using the DISTINCT keyword causes this error: not a SELECTed expression

Sql Oracle Hibernate Oracle11g

How to properly manage database deployment with SSDT and Visual Studio 2012 Database Projects?

Sql Visual Studio-2012 Sqlcmd Database Project Sql Server-Data-Tools

Convert Date format into DD/MMM/YYYY format in SQL Server

Sql Sql Server Sql Server-2008 Sql Server-2012

Rails order by association field

Sql Ruby on-Rails Postgresql

Replace Into Query Syntax

Mysql Sql Database Replace

Add a row number to result set of a SQL query

Sql Sql Server Sql Server-2005

How to run .sql file in Oracle SQL developer tool to import database?

Sql Oracle Oracle Sqldeveloper

SQL: Two select statements in one query

How to write function for optional parameters in postgresql?

Sql Postgresql Plpgsql

SQL Case Expression Syntax?

Select data from "show tables" MySQL query

Mysql Sql Metadata

What is the purpose for using OPTION(MAXDOP 1) in SQL Server?

SELECT * EXCEPT

SQL formatting standards

Sql Sql Server Formatting Standards Coding Style

How to get difference between two rows for a column field?

Sql Sql Server Tsql Sql Server-2005

Calculate a running total in MySQL

CONCAT'ing NULL fields

Sql Sql Server Concatenation

Calculating number of full months between two dates in SQL

When should I use stored procedures?

Sql Database Stored Procedures

PL/SQL block problem: No data found error

Sql Oracle Plsql Oracle10g Ora 01403

MySQL: Alternatives to ORDER BY RAND()

Sql Mysql Random Sql Order-By

How to compare two SQLite databases on Linux

Sql Linux Sqlite

PostgreSQL JOIN with array type with array elements order, how to implement?

Sql Arrays Postgresql Join

How to select the last record from MySQL table using SQL syntax

In SQL / MySQL, what is the difference between "ON" and "WHERE" in a join statement?

Sql Mysql Join Where Clause

How to TRUNCATE TABLE using Django's ORM?

Python Sql Django Orm Truncate

The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'

Is there an elegant way to Invert a Bit value in an SQL insert Statement?

Sql Sql Server Bit Manipulation

How to get the difference between two dates rounded to hours

How to check db2 version

MySQL unknown column in ON clause

Sql Mysql Mysql Error-1054

Select random row(s) in SQLite

Capturing count from an SQL query

C#Sql Sql Server

MySql can't make column auto_increment

Mysql Sql Mysql Error-1062

MySQL Long Query Progress Monitoring

Do all columns in a SELECT list have to appear in a GROUP BY clause

MS SQL Exception: Incorrect syntax near '@P0'

SQLite Like % and _

Sql Sqlite Sql Like

MySQL add days to a date

Increment Row Number on Group

Sql Sql Server Sql Server-2005

select records from postgres where timestamp is in certain range

LINQ to SQL multiple tables left outer join

C#Mysql Sql Linq Entity Framework

Is there some way I can "join" the contents of two javascript arrays much like I would do a join in SQL

SQL SELECT LIKE (Insensitive casing)

Mysql Sql Sql Like Case Insensitive

Find all stored procedures that reference a specific column in some table

Sql Sql Server Select Find Columnname

belongsTo vs hasMany in Sequelize.js

Sql node.js Orm sequelize.js

"IN" clause limitation in Sql Server

Grant privileges on future tables in PostgreSQL?

Sql Database Postgresql

Cannot drop table users because other objects depend on it

Where condition for joined table in Sequelize ORM

Javascript Sql Postgresql Orm sequelize.js

What is the meaning of <> in mysql query?

Generate insert SQL statements from a CSV file

Sql Csv Insert Firebird

SQL, Auxiliary table of numbers

MySQL: View with Subquery in the FROM Clause Limitation

Mysql Sql View Mysql Error-1349

How to update and order by using ms sql

Sql Sql Server Tsql Sql Order-By Sql Update

SQL GROUP BY CASE statement with aggregate function

Sql Sql Server Sql Server-2005 Group By

how to use a like with a join in sql?

Mysql Sql Join Sql Like

Maintaining order in MySQL "IN" query

How do I create a comma-separated list using a SQL query?

Sql Sql Server Tsql String Aggregation

SQL Server 2008: TOP 10 and distinct together

Sql Sql Server Sql Server-2008

MySQL incorrect key file for tmp table when making multiple joins

Mysql Sql Mysql Error-126

How to represent a data tree in SQL?

Sql Tree Hierarchical Data

What is the linq equivalent to the SQL IN operator

Sql Linq Contains

IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation

Sql Oracle Plsql

How can I roll back my last delete command in MySQL?

Mysql Sql Sql Delete Rollback

Why does MySQL report a syntax error on FULL OUTER JOIN?

Mysql Sql Join Mysql Error-1064

Referencing outer query's tables in a subquery

Inserting text string with hex into PostgreSQL as a bytea

C# Version Of SQL LIKE

C#.Net Sql String

SQL COUNT overflow

Sql Sql Server Count Overflow

Equivalent of explode() to work with strings in MySQL

Group by day from timestamp

Execute Stored Procedure from a Function

Sql Sql Server Sql Server-2005 Stored Procedures User Defined-Functions

"This SqlTransaction has completed; it is no longer usable."... configuration error?

Sql Stored Procedures Sql Server-2008-R2 Server Error

How do I add a auto_increment primary key in SQL Server database?

Sql Sql Server Auto Increment

PostgreSQL syntax check without running the query

Sql Parsing Postgresql Syntax Cvs

Group by with union mysql select query

Mysql Sql Group By Union

How to SELECT WHERE NOT EXIST using LINQ?

C#Sql Linq Entity Framework

Get affected rows on ExecuteNonQuery

C#Mysql .Net Sql Executenonquery

PostgreSQL column 'foo' does not exist

Sql Postgresql Quoted Identifier

How to create a new database with the hstore extension already installed?

Sql Postgresql Postgresql 9.1 Hstore

PostgreSQL: FOREIGN KEY/ON DELETE CASCADE

Sql Postgresql Cascade

What is the syntax meaning of RAISERROR()

Sql Sql Server Database Sql Server-2008 Sql Server-2008-R2

How to regex in a MySQL query

Mysql Sql Regex Innodb

Not all parameters were used in the SQL statement (Python, MySQL)

Python Mysql Sql

Get all dates between two dates in SQL Server

MySQL Select last 7 days

Mysql Sql Where Clause Date Arithmetic

Run raw SQL in migration

Php Mysql Sql Laravel Laravel 4

How to group by week in postgresql

PostgreSQL Index on JSON

Sql Json Postgresql Indexing Database Design

How to drop column if it exists in PostgreSQL 9+?

Getting the number of rows with a GROUP BY query

How do I determine if a database role exists in SQL Server?

Create a one to many relationship using SQL Server

Sql Sql Server Sql Server-2005

Which sql server data type best represents a double in C#?

C#Sql Sql Server Tsql Double

How to export data with Oracle SQL Developer?

Sql Oracle Oracle Sqldeveloper

SQL Server - In clause with a declared variable

Sql Sql Server-2008 In Clause

What Free SQL Formatting Tools exist?

Sql query to select from 1 hour ago?

SQL IN Clause 1000 item limit

How to use multiple LEFT JOINs in SQL?

Sql Join Left Join

UNION with WHERE clause

Sql Oracle Union

How to write "not in ()" sql query using join

Sql Sql Server Tsql Notin

How to get first two characters of a string in oracle query?

SQL Update query with group by clause

Date in mmm yyyy format in postgresql

mysql SELECT IF statement with OR

Mysql Sql Select If Statement

Composite Primary Key On Table Variable In Stored Procedure

Sql Sql Server Sql Server-2008 Stored Procedures Primary Key

How to restore PostgreSQL dump file into Postgres databases?

Sql Postgresql Dump Database Restore Database Dump

Retrieving Data from SQL Using pyodbc

Python Sql Sql Server Pyodbc

How to query GROUP BY Month in a Year

How to add a variable number of hours to a date in PostgreSQL?

Sql Postgresql Datetime

SQL How to replace values of select return?

Mysql Sql Select

How to query for null values in json field type postgresql?

Sql Json Postgresql

Laravel Eloquent get results grouped by days

Php Mysql Sql Laravel Laravel 4

Laravel Eloquent how to use between operator

Php Sql Laravel Laravel 4 Eloquent

Add days Oracle SQL

How can I import a JSON file into PostgreSQL?

Sql Json Postgresql

What's the fastest way to bulk insert a lot of data in SQL Server (C# client)

C#Sql Sql Server Sql Server-2005

What’s the best way to capitalise the first letter of each word in a string in SQL Server

Sql Sql Server String

Is it possible to query a tree structure table in MySQL in a single query, to any depth?

Mysql Sql Database Design Data Structures Hierarchical Data

Rename SQL Server Schema

Sql Sql Server Sql Server-2005 Schema

T-SQL, updating more than one variable in a single select

Sql Sql Server Tsql

Creating table names that are reserved words/keywords in MS SQL Server

Delete duplicate records from a SQL table without a primary key

Sql Sql Server-2005 Tsql Duplicate Removal

in general, should every table in a database have an identity field to use as a PK?

Sql Database Database Design

What does =* mean?

Sql Sql Server Database Tsql

How to select an empty result set?

Sql Mysql Stored Procedures Null Resultset

SQL constraint minvalue / maxvalue?

Sql Constraints

Insert Data Into Tables Linked by Foreign Key

When is a good situation to use a full outer join?

sqlite select with condition on date

Sql Database Sqlite Date

SQL Update to the SUM of its joined values

Sql Sum Sql Update

SQL Server Update Group by

Sql Group By Sql Update

Why use SQL database?

Sql Database Database Design Data Structures

Alternatives to LIMIT and OFFSET for paging in Oracle

Sql Oracle Sql Limit

SQL Populate table with random data

Sql Postgresql Insert

adding a column description

Sql Sql Server Sql Server-2005

I want to show all tables that have specified column name

Sql Sql Server-2008

Conditional logic in PostDeployment.sql script using SQLCMD

Sql Database Sql Server-2008 Sqlcmd

Why no many-to-many relationships?

Subtract month and day mysql

Making a javascript string sql friendly

Javascript Sql String node.js Escaping

Generate Dates between date ranges

Sql Sql Server Tsql Sql Server-2008 Range

How do I extract Month and Year in a MySQL date and compare them?

Excel function to make SQL-like queries on worksheet data?

Sql Excel Vba Function

How to select last 6 months from news table using MySQL

Convert negative data into positive data in SQL Server

Unique key vs. unique index on SQL Server 2008

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

SQL COUNT* GROUP BY bigger than,

Sql Count Group By

Delete with "Join" in Oracle sql Query

Sql Oracle Sql Delete

Doctrine 2 Query with LIKE

Sql Symfony Doctrine Orm

Convert date to YYYYMM format

Sql Sql Server Tsql

Can't see MySQL BIT field value when using SELECT

How to execute a stored procedure inside a select query

Sql Sql Server Sql Server-2008 Stored Procedures

Does Sql JOIN order affect performance?

Is there any function in oracle similar to group_concat in mysql?

Select columnValue if the column exists otherwise null

Sql Sql Server Select Exists

Optimistic locking in MySQL

Mysql Sql Locking Database Optimistic

Identity column value suddenly jumps to 1001 in sql server

Sql Sql Server Sql Server-2012

How can I with mysqli make a query with LIKE and get all results?

Php Sql Mysqli Sql Like

Scope of temporary tables in SQL Server

Sql Sql Server Tsql Sql Server-2012

Duplicate key on write or update?

SQL server stored procedure return a table

Sql Sql Server Matlab Stored Procedures

sql try/catch rollback/commit - preventing erroneous commit after rollback

Sql Sql Server Exception Transactions Try Catch

Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root

Mysql Sql my.cnf

Can you delete data from influxdb?

How to easily edit SQL XML column in SQL Management Studio

Sql Sql Server Xml

A script to change all tables and fields to the utf-8-bin collation in MYSQL

Php Sql Mysql Utf 8 Collation

How do I sort a VARCHAR column in SQL server that contains numbers?

Possible to use SQL to sort by date but put null dates at the back of the results set?

Concatenate multiple rows in an array with SQL on PostgreSQL

How do I combine 2 select statements into one?

Sql Select Conditional

T-SQL: Round to nearest 15 minute interval

Sql Sql Server Datetime

Using "GO" within a transaction

.Net Sql Sql Server Tsql Transactions

What is the best free SQL GUI for Linux for various DBMS systems

SQL Server IF NOT EXISTS Usage?

Sql Sql Server Stored Procedures

Parsing SQL with Python

Python Sql Parsing Pyparsing

Finding the next available id in MySQL

SQL Server equivalent to Oracle's NULLS FIRST?

Sql Sql Server Sql Server-2005 Tsql

Pass table as parameter into sql server UDF

Sql Sql Server Sql Server-2005 Parameters User Defined-Functions

Varchar(255) to Varchar(MAX)

Sql Types Varchar

SQL primary key: integer vs varchar

Sql Performance Indexing

How to delete rows in tables that contain foreign keys to other tables

Sql Sql Server Sql Server-2008

SQL Server - How to lock a table until a stored procedure finishes

Sql Sql Server Tsql Stored Procedures Locking

Difference between IN and ANY operators in SQL

Sql Operators Any

Is there any difference between IS NULL and =NULL

Sql Sql Server Sql Server-2005

Sort the rows according to the order specified in WHERE IN clause

Mysql Sql Sql Order-By

How can I check if an SQL result contains a newline character?

Sql Sql Server Ssms

Does the order of fields in a WHERE clause affect performance in MySQL?

Sql Mysql Performance

What is the data type for unix_timestamp (MySQL)?

Sql Mysql Types

MySQL: GROUP_CONCAT with LEFT JOIN

Sql Mysql Join Aggregate Functions Group Concat

How to retrieve records for last 30 minutes in MS SQL?

Sql Sql Server Tsql

Client Statistics table (Microsoft SQL Server Management Studio)

Sql Sql Server Sql Server-2008 Ssms

How to include BIT type column in SELECT part with out including it on the GROUP BY in T-SQL?

Sql Tsql Group By Aggregate

How do I view my stored procedures in phpMyAdmin?

Mysql Sql Stored Procedures Phpmyadmin

PostgreSQL sequence based on another column

Change primary key column in SQL Server

Sql Sql Server Database Shared Hosting

Using a Python dict for a SQL INSERT statement

Python Mysql Sql

row-level trigger vs statement-level trigger

How to list files inside a folder with SQL Server

Generate insert script for selected records?

Sql Database Sql Server-2008

sql query if parameter is null select all

Sql Parameters Where Clause

Why can't I use an alias for an aggregate in a having clause?

Sql Sql Server-2008

Multiple SQL statements in one roundtrip using Dapper.NET

C#Sql .Net Sql Server Dapper

Use string contains function in oracle SQL query

Get records of current month

Mysql Sql Date Select Timestamp

How to get DATE from DATETIME Column in SQL?

Sql Sql Server Date Datetime

What does SQL Select symbol || mean?

Mysql Sql Oracle Ansi Sql

MySQL: "= true" vs "is true" on BOOLEAN. When is it advisable to use which one? And Which one is vendor independent?

How to convert PostgreSQL 9.4's jsonb type to float

Sql Postgresql Casting Jsonb Postgresql 9.4

How to execute "left outer join" in SqlAlchemy

Python Sql Sqlalchemy

How do I view the Explain Plan in Oracle Sql developer?

Sql Oracle Oracle Sqldeveloper Sql Execution-Plan

How to insert date values into table

Sql Oracle Datetime Oracle10g Date Formatting

Bulk insert, update if on conflict (bulk upsert) on Postgres

Sql Postgresql Upsert

How to perform a left join in SQLALchemy?

Python Sql Sqlalchemy

What is the best way to implement soft deletion?

Sql Database Database Design Backup

MySQL Trigger - Storing a SELECT in a variable

Mysql Sql Triggers

Why is 30 the default length for VARCHAR when using CAST?

Sql Sql Server Casting

Is there a way to SELECT and UPDATE rows at the same time?

Sql Sql Server Tsql Sql Server-2008

Singular or plural database table names?

Sql Mysql Sql Server

How can I join on a stored procedure?

Sql Sql Server-2005-Express

MySQL INTO OUTFILE override existing file?

Php Mysql Sql Into Outfile

Get the last day of the month in SQL

Sql Sql Server Tsql

How to Ignore "Duplicate Key" error in T-SQL (SQL Server)

Combine two tables for one output

C# SQL Top as parameter

Sql Sql Server Tsql ado.net

Alter user defined type in SQL Server

Sql Sql Server Tsql

Determine a table's primary key using TSQL

Sql Sql Server Tsql Primary Key

Select without a FROM clause in Oracle

What does the colon sign ":" do in a SQL query?

Sql Oracle Plsql Bind Variables

SQL Management Studio won't recognize a table exists after scripted create

Sql Sql Server Ssms

Order by COUNT per value

Mysql Sql Count Sql Order-By

How can I merge the columns from two tables into one output?

Select from table by knowing only date without time (ORACLE)

Sql Oracle Date

Sql Query to list all views in an SQL Server 2005 database

Sql Sql Server Metadata

How can I solve "Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong."?

SQL - How do I get only the numbers after the decimal?

Sql Sql Server Tsql

Selecting rows where remainder (modulo) is 1 after division by 2?

Sql Database Select Where Clause Modulus

Why is there no PRODUCT aggregate function in SQL?

Return value from exec(@sql)

Sql Sql Server Sql Server-2005 Tsql

How to select rows for a specific date, ignoring time in SQL Server

Sql Sql Server-2005

Order by descending date - month, day and year

Oracle: SQL query to find all the triggers belonging to the tables?

SQL Statement with multiple SETs and WHEREs

Create Table from View

CROSS APPLY vs OUTER APPLY speed difference

Sql Sql Server Performance Tsql

What is the purpose of PAD_INDEX in this SQL Server constraint?

Sql Sql Server Indexing

Create SQL INSERT Script with values gathered from table

Sql Sql Server-2008

Select first record in a One-to-Many relation using left join

What is difference between foreign key and reference key?

Sql Database Foreign Keys

How to specify conditions on joined tables in rails

Sql Ruby on-Rails Activerecord

Set an empty DateTime variable

Using ORDER BY and GROUP BY together

Mysql Sql Group By Greatest N-per-Group

Setting value for one column of all records in table

How to Synchronize Android Database with an online SQL Server?

Android Sql Sqlite Synchronization

Check for file exists or not in sql server?

Sql Sql Server Sql Server-2008

How to replace (null) values with 0 output in PIVOT

Sql Sql Server Pivot

What are good ways to prevent SQL injection?

C#Sql Security Sql Injection

Adding named foreign key constraints in a SQL Create statement

Sql Sql Server Postgresql Constraints Create Table

Creating temporary tables in SQL

Sql Postgresql Temp Tables

There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key

Sql Sql Server Key Candidate

What is the difference between count(0), count(1).. and count(*) in mySQL/SQL?

MySQL order by "best match"

Mysql Sql Sql Order-By

Concatenate string with field value in MySQL

Php Mysql Sql Concatenation

Order By Date ASC with Spring Data

Java Sql Spring Postgresql Spring Data

How to execute an IN lookup in SQL using Golang?

Postgres Error: More than one row returned by a subquery used as an expression

Sql Database Postgresql Subquery Dblink

How do I enable the MySQL slow query log?

What is the difference between a primary key and a surrogate key?

Sql Sql Server Sql Server-2008 Sql Server-2005 Sql Server-2012

Extract day of week from date field in PostgreSQL assuming weeks start on Monday

Sql Postgresql Date

Create Local SQL Server database

pip install mysqlclient returns "fatal error C1083: Cannot open file: 'mysql.h': No such file or directory

Python Mysql Sql Pip

cx_Oracle: How do I iterate over a result set?

Python Sql Database Oracle Cx Oracle

Do indexes work with "IN" clause

How can you handle an IN sub-query with LINQ to SQL?

Sql Linq Linq to-Sql

Comparing two bitmasks in SQL to see if any of the bits match

Sql Sql Server Tsql Bitmask

How to output a boolean in T-SQL based on the content of a column?

Sql Sql Server-2000

How to choose returned column name in a SELECT FOR XML query?

Sql Sql Server Xml Sql Server-2005

Best way to understand complex SQL statements?

What exactly do quotation marks around the table name do?

SQL Server check case-sensitivity?

Sql Sql Server Tsql Case Sensitive

IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

Sql Sql Server Sql Server-2005 Tsql

What is the difference between ";" and "GO" in T-SQL?

Sql Sql Server Sql Server-2008 Tsql

sqlplus statement from command line

Sql Oracle Sqlplus

Difference between stored procedures and user defined functions

Sql Database Stored Procedures

How to do pagination in SQL Server 2008

Sql Sql Server-2008 Pagination

Oracle: '= ANY()' vs. 'IN ()'

Sql Oracle Syntax

Oracle date "Between" Query

Sql Oracle Oracle10g Where Clause Date Arithmetic

At what point is it worth using a database?

C++Sql Database Qt User Interface

SQL Server: Add seconds to a datetime field?

ALTER TABLE in Magento setup script without using SQL

Php Sql Magento Installation Entity Attribute-Value

mysql GROUP_CONCAT duplicates

Sql Mysql Group Concat

Convert SQL Server result set into string

Sql Sql Server Sql Server-2005 Tsql

Online databases for trying out Oracle SQL queries?

Sql Database Oracle

how to sort order of LEFT JOIN in SQL query?

Mysql Sql Greatest N-per-Group

Insert and set value with max()+1 problems

Mysql Sql Insert Mysql Error-1093

Why is a primary-foreign key relation required when we can join without it?

Remove duplicates in a Django query

Direct method from SQL command text to DataSet

How to pass variable as a parameter in Execute SQL Task SSIS?

Why does SQL Server keep creating a DF constraint?

Sql Sql Server Sql Server-2008

mysql count group by having

Mysql Sql Group By Aggregate Functions

SQL Delete Records within a specific Range

Sql Sql Delete Records

How to use an user variables in MySQL LIKE clause?

Mysql Sql Database

Can I change the default schema name in entity framework 4.3 code-first?

C#Sql Entity Framework Entity Framework-4 Ef Code-First

Check if a parameter is null or empty in a stored procedure

Sql Sql Server-2008 Stored Procedures Parameters Null

Update column value PostgreSQL

SQL to add column and comment in table in single command

Sql Oracle Oracle11g

Time part of a DateTime Field in SQL

Sql Sql Server Sql Server-2008 Tsql Datetime

USING Keyword vs ON clause - MYSQL

If statement in select (ORACLE)

Sql Oracle Select If Statement Oracle10g

How to Identify port number of SQL server

how to call scalar function in sql server 2008

How to insert columns at a specific position in existing table?

Just get column names from hive table

Sql Hadoop Hive

ORA-01791: not a SELECTed expression

PostgreSQL - Iterate over results of query

Sql Postgresql Plpgsql

How can I combine multiple rows into a comma-delimited list in SQL Server 2005?

Sql Sql Server List Function Concatenation

How to debug ORA-01775: looping chain of synonyms?

Sql Oracle Synonym

The Next-gen Databases

Sql Database Nosql Non Relational-Database

Postgresql: how to create table only if it does not already exist?

Sql Database Postgresql

What SQL coding standard do you follow?

Sql Coding Style

Copy data from one existing row to another existing row in SQL?

Sql Insert Copy Row

Postgres - Function to return the intersection of 2 ARRAYs?

Determine what user created objects in SQL Server

Sql Sql Server-2005 Tsql

Using union and count(*) together in SQL query

SQL: Combine Select count(*) from multiple tables

Sql Sql Server Tsql

SQL ORDER BY date problem

Sql Date Sql Order-By

Difference between DECIMAL and NUMERIC

Sql Types Decimal Numeric

Why are foreign keys more used in theory than in practice?

Sql Database Foreign Keys

MySQL auto-store datetime for each row

Sql Mysql Datetime Audit

Is there a difference between a SELECT statement inside a transaction and one that is outside of it?

Sql Sql Server Select Transactions

Does it make sense to use an index that will have a low cardinality?

Mysql Sql Indexing Cardinality

Using a database table as a queue

Sql Database Sql Server-2008 Queue

return SQL table as JSON in python

Python Sql Json

Why use Foreign Key constraints in MySQL?

Sql Mysql Foreign Keys

What's the most efficient way to check if a record exists in Oracle?

How to list custom types using Postgres information_schema

Is it possible to insert data into a MySQL view?

Sql Mysql Updatable Views

What's the SQL national character (NCHAR) datatype really for?

Sql Sql Server Oracle Tsql Nvarchar

How to enter special characters like "&" in oracle database?

Sql Database Oracle Oracle Sqldeveloper

How to reuse a result column in an expression for another result column

Sql Postgresql Subquery

Insert/ Update random date in MySQL

Mysql Sql Date Random

Multiple level ordering

Sql Sqlite Sorting

In MySQL, should I quote numbers or not?

Mysql Sql Ansi Sql

How can I import a SQL file into a Rails database?

Sql Ruby on-Rails

SQL Statement using Where clause with multiple values

Can I pass column name as input parameter in SQL stored Procedure

Sql Stored Procedures

How to close existing connections to a DB

Pass table valued parameter using ADO.NET

C#asp.net Sql ado.net

How can I force a query to not use a index on a given table?

Sql Sql Server-2005 Indexing

How to use a tablename variable for a java prepared statement insert

Java Sql Variables Dynamic Prepared Statement

SQL Server converting varbinary to string

Sql Sql Server String Varbinary

Don't update column if update value is null

Sql Postgresql Null Sql Update

T-SQL Conditional Order By

Sql Sql Server Tsql

My Select SUM query returns null. It should return 0

Invalid use side-effecting operator Insert within a function

Sql Sql Server Sql Server-2008

How to make CREATE OR REPLACE VIEW work in SQL Server?

Sql Sql Server View Porting

Entering keys manually with Entity Framework

C#Sql asp.net Entity Framework Entity Framework-Core

GROUP BY + CASE statement

Sql Postgresql Group By Case Aggregate Functions

Proper way of checking if row exists in table in PL/SQL block

Sql Oracle Select Plsql

How does group by works in sequelize?

Javascript Sql Orm sequelize.js Query Builder

How to simulate DEADLOCK on SQL Server?

Sql Sql Server Concurrency Deadlock

Why do multiple-table joins produce duplicate rows?

PostgreSQL calculate difference between rows

How to convert Laravel migrations to raw SQL scripts?

Sql Laravel Laravel Migrations

Postgres - aggregate two columns into one item

Sql Arrays Postgresql Aggregate Functions

NOT LIKE and LIKE not returning opposite result

Sql Sql Server Tsql Sql Like

Including null values in an Apache Spark Join

Sql Scala Apache Spark Join Apache Spark-Sql

how do I group by by hour in postgresql with a "time" field?

How to get input file name as column in AWS Athena external tables

Sql Amazon Web-Services Amazon S3 Presto Amazon Athena

SQL Server 2005 - Export table programmatically (run a .sql file to rebuild it)

Sql Sql Server Sql Server-2005 Database Table

Which is better: Ad hoc queries or stored procedures?

Sql Stored Procedures

When should you use full-text indexing?

Sql Sql Server Tsql Indexing Full Text-Search

How can I determine the status of a job?

Sql Sql Server-2005 Tsql Stored Procedures

Parameterized Queries with LIKE and IN conditions

.Net Sql Parameters Sql Injection Parameterized

SQL string formatter

Sql Linux Formatting Code Formatting

Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"

Sql Sql Server Sql Server-2005 Optimization Sql Execution-Plan

SQLAlchemy Obtain Primary Key With Autoincrement Before Commit

Python Sql Sqlalchemy

Copy Data from a table in one Database to another separate database

How do I subtract using SQL in MYSQL between two date time values and retrieve the result in minutes or second?

Is there any way to flush output from PL/SQL in Oracle?

Sql Oracle Plsql Dbms Output

Explaining why "Just add another column to the DB" is a bad idea, to non programmers

Sql Database Architecture Communication Normalization

Change Primary Key

Sql Oracle Primary Key

Using comparison operators in SELECT clause of T-SQL query

Sql Sql Server Sql Server-2008 Tsql Comparison Operators

How to count number of occurrences for all different values in database column?

Sql Database Postgresql

SQL explain plan: what is Materialize?

Sql Postgresql Sql Execution-Plan

How can I INSERT data into two tables simultaneously in SQL Server?

Sql Sql Server Tsql Insert Foreign Keys

How to query a CLOB column in Oracle

Sql Oracle Plsql Clob Ora 06502

SELECT INTO USING UNION QUERY

Sql Sql Server Tsql Union Derived Table

What is parameterized query?

Php Sql Parameterized Query

How to export a MySQL database to JSON?

Combining ORDER BY AND UNION in SQL Server

Sql Sql Server Sql Order-By Union All

SELECT one column if the other is null

SQL performance on LEFT OUTER JOIN vs NOT EXISTS

How can I allow django admin to set a field to NULL?

Python Mysql Sql Django Django Admin

How to delete a database in WebSQL programmatically?

Javascript Sql Google Chrome Google Chrome-Extension Web Sql

Rails: Get next / previous record

Sql Ruby on-Rails Ruby on-Rails-3

CASE IN statement with multiple values

Sql Sql Server Sql Server-2005

DROP FUNCTION without knowing the number/type of parameters?

Sql Postgresql Plpgsql Dynamic Sql Ddl

How do I add multiple "NOT LIKE '%?%' in the WHERE clause of sqlite3?

Know relationships between all the tables of database in SQL Server

Sql Sql Server Database Tsql

How to echo print statements while executing a sql script

Setting two scalar variables in one SELECT statement?

Sql Sql Server Tsql

How to convert integer to decimal in SQL Server query?

Sql Sql Server Type Conversion

selecting rows with id from another table

Mysql Sql Database

MySql Inner Join with WHERE clause

Mysql Sql Where Clause Mysql Error-1064

The tail of the log for the database "DBName" has not been backed up

C#Sql Sql Server-2005 Sharepoint

unable to drop and create database in sql server

Sql Sql Server-2008 Tsql

What is the difference between a candidate key and a primary key?

Sql Relational Database

How to use SQL LIKE condition with multiple values in PostgreSQL?

Sql Postgresql Postgresql 9.1

oracle SQL how to remove time from date

Import postgres database without roles

Sql Database Postgresql Import Psql

What is difference between != and <> in sql server

Sql Sql Server Operators

TypeError: 'int' object does not support indexing

Python Sql Postgresql

GROUP BY but get all values from other column

List names of all tables in a SQL Server 2012 schema

PostgreSQL Get a random datetime/timestamp between two datetime/timestamp

Sql Database Postgresql Datetime Timestamp

Get Entity Framework 6 use NOLOCK in its underneath SELECT statements

C#Sql .Net Sql Server Entity Framework

What is (are) difference between NOLOCK and UNCOMMITTED

Sql Sql Server Sql Server-2012 Locking Isolation Level

Log the actual SQL query using ActiveRecord with Yii2?

Php Sql Activerecord Logging Yii2

PostgreSQL "Column does not exist" but it actually does

Sql Postgresql Quoted Identifier

SQL query question: SELECT ... NOT IN

Which SQL statement is faster? (HAVING vs. WHERE...)

Sql Performance Grouping If Statement

How does SQL Server treat statements inside stored procedures with respect to transactions?

Sql Sql Server Stored Procedures Transactions

What SQLite column name can be/cannot be?

Sql Sqlite Keyword

Aggregating save()s in Django?

Python Sql Django Sqlite

Stop (long) running SQL query in PostgreSQL when session or requests no longer exist?

How to group mysql rows with same column value into one row?

Sql Mysql Aggregate Functions

How do I delete multiple rows with different IDs?

Is it good database design to have admin users in the same table as front-end users?

Sql Sql Server Database Database Design Data Modeling

update one table with data from another

UNION the results of multiple stored procedures

Sql Sql Server Stored Procedures Union

Finding columns that are NOT NULL in PostgreSQL

Sql Postgresql Information Schema

Filter by COUNT(*)?

MySQL combine two columns and add into a new column

ON DELETE CASCADE in sqlite3

How do I update an android sqlite database column value to null using ContentValues?

Android Sql Database Sqlite

How to store array or multiple values in one column

Sql Arrays Postgresql Types

JDBC ResultSet get columns with table alias

Java Sql Oracle Jdbc Resultset

PostgreSQL Where count condition

Sql Postgresql Group By Having

How to find out what is locking my tables?

Sql Sql Server Sql Server-2008-R2 Locking Query Optimization

Oracle timestamp data type

How to kill a running SELECT statement

Sql Oracle Select Oracle10g Sqlplus

MySQL comparison with null value

Mysql Sql Null Isnull

Calling a stored procedure in Oracle with IN and OUT parameters

create table with sequence.nextval in oracle

Sql Database Oracle Plsql

Matching all values in IN clause

MySQL 1062 - Duplicate entry '0' for key 'PRIMARY'

Mysql Sql Mysql5

MySQL where NOT IN name array?

SQL Insert Multiple Rows

What is the maximum number of columns in a PostgreSQL select query

Sql Postgresql Postgresql 9.2

Why do SQL databases use a write-ahead log over a command log?

Sql Database Logging Transactions Voltdb

Modify Default value in SQL Server

How can I delete one of two perfectly identical rows?

Sql Duplicate Removal

How to add time to DateTime in SQL

Sql Sql Server-2008 Datetime

ORDER BY "ENUM field" in MYSQL

Mysql Sql Enums Sql Order-By

Cannot Resolve Collation Conflict

Sql Sql Server Sql Server-2008 Sql Server-2012 Collation

Multiple INNER JOIN SQL ACCESS

Sql Ms Access Join Inner Join

T-SQL split string based on delimiter

Sql Sql Server Sql Server-2008 Tsql Sql Server-2008-R2

PHP: maximum execution time when importing .SQL data file

Php Mysql Sql Phpmyadmin Xampp

Converting java date to Sql timestamp

Java Sql Datetime Sqldatetime

How can I get a plain text postgres database dump on heroku?

Sql Postgresql Heroku

Cast syntax to convert a sum to float

Sql Postgresql Casting Type Conversion Postgresql 9.3

Cannot connect to (LocalDB)\MSSQLLocalDB -> Login failed for user 'User-PC\User'

Sql Sql Server Ssms Localdb

What is the difference between cube, rollup and groupBy operators?

Sql Apache Spark Apache Spark-Sql Cube Rollup

PYODBC--Data source name not found and no default driver specified

Python Sql Pyodbc

Why is query with phone = N'1234' slower than phone = '1234'?

Sql Sql Server Query Performance

How to return multiple values in one column (T-SQL)?

Sql Sql Server Sql Server-2005 Tsql

When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

Mysql Sql Datetime Sql Update

Passing List<> to SQL Stored Procedure

C#Sql Sql Server Tsql Stored Procedures

What's the best way to store the days of the week an event takes place on in a relational database?

Sql Database Design

SQL "IF", "BEGIN", "END", "END IF"?

Equivalent of SQL ISNULL in LINQ?

C#Sql Linq Isnull

How do I join the most recent row in one table to another table?

Sql Date Join Greatest N-per-Group

linq case statement

Store mysql query output into a shell variable

Mysql Sql Bash Scripting

How to store MySQL query results in another Table?

Mysql Sql Database

When should I use primary key or index?

Sql Primary Key Indexing

Get stored procedure parameters by either C# or SQL?

C#Sql Sql Server-2008 Stored Procedures Parameters

Variable column names using prepared statements

Java Sql Jdbc Prepared Statement

T-SQL: Selecting Column Based on MAX(Other Column)

Sql Sql Server Tsql Greatest N-per-Group

Fastest way to update 120 Million records

Sql Sql Server Sql Server-2005

SQL subquery with COUNT help

How much disk-space is needed to store a NULL value using postgresql DB?

Sql Postgresql Types Nullable

SQL Return only duplicate rows

Best SQL browser for HSQLDB?

Java Sql Browser Hsqldb Sqlbrowser

How to use a package constant in SQL SELECT statement?

Sql Oracle Packages

Database in use error with Entity Framework 4 Code First

Sql Entity Framework Code First Ef Code-First

JPQL SELECT between date statement

Java Sql Jpa Jpql

'LIKE ('%this%' OR '%that%') and something=else' not working

Mysql Sql Sql Like

Storing IPv6 Addresses in MySQL

SQL Server giving logins(users) db_owner access to database

Sql Sql Server Database

MySQL datatype to store month and year only

Mysql Sql Database Design

Can't change table design in SQL Server 2008

Sql Sql Server Sql Server-2008

Count records for every month in a year

Sql Sql Server Sql Server-2008

Difference between Parameters.Add(string, object) and Parameters.AddWithValue

C#Sql Stored Procedures Parameters

alter the size of column in table containing data

SQL Server Convert Varchar to Datetime

Sql Sql Server Datetime Formatting Varchar

SQL WHERE column = everything

How to get calendar Quarter from a date in TSQL

Sql Sql Server Tsql Sql Server-2005

Handling inheritance with overriding efficiently

Sql Sql Server Sql Server-2008 Tree

EntityFramework Same Table Many to Many Relationship

C#asp.net Sql Entity Framework

How do I batch sql statements with package database/sql

Select count(*) from result query

Sql Sql Server Select

Checking multiple columns for one value

Mysql Sql Select Query Optimization

Split string and take last element

Sql Sql Server Url Split

View or Temporary Table - which to use in MS SQL Server?

Sql Sql Server View Temp Tables

How to visualize database tables in postgresql using pgAdmin?

Sql Database Postgresql Pgadmin

Android phonegap application having issues with SQlite and local storage on Samsung Galaxy devices

Javascript Android Sql Sqlite Cordova

Postgres Case Sensitivity

Sql Sql Server Postgresql

Why do I get "A cursor with the name already exists"?

Sql Sql Server Tsql Database Cursor

Sort by minimum value of two columns

Sql Sql Server Tsql Sorting Min

Presto SQL - Converting a date string to date format

No unique or exclusion constraint matching the ON CONFLICT

Sql Postgresql Postgresql 9.5

How to alter column nvarchar length without drop

Sql Sql Server Ssms

Case-insensitive search using Hibernate

Sql Hibernate Select Case Sensitive

How to set a default row for a query that returns no rows?

Using GROUP_CONCAT on subquery in MySQL

Mysql Sql Group Concat Mysql Error-1242

Insert row in table for each id in another table

How to get list of values in GROUP_BY clause?

Sql Group By Sybase

What is the best way to escape non-format characters in Oracle's to_char?

Sql Oracle To Char

How can I do a BEFORE UPDATED trigger with sql server?

Sql Sql Server Database Triggers Sql Server-Express

Sample database for exercise

Sql Test Data Sample Data

Why are batch inserts/updates faster? How do batch updates work?

What are the differences between T-SQL, SQL Server and SQL

Sql Sql Server Tsql

How do I compare two columns for equality in SQL Server?

Sql Sql Server Tsql

How to insert a blob into a database using sql server management studio

Sql Sql Server Sql Server-2005 Blob

Generating sql insert into for Oracle

ANSI SQL Manual

Sql Reference Manual Ansi Sql

Postgresql - Using subqueries with alter sequence expressions

Sql Postgresql Subquery Sequence Alter

formula for computed column based on different table's column

Sql Sql Server-2008 Calculated Columns

Group mysql query by 15 min intervals

Mysql Sql Datetime Group By Timestamp

SQL - How to select a row having a column with max value

Does the order of conditions in a WHERE clause affect MySQL performance?

Using MySql, can I sort a column but have 0 come last?

Sql Mysql Sql Order-By

Slow simple update query on PostgreSQL database with 3 million rows

Sql Postgresql Sql Update

Duplicating a TABLE using Microsoft SQL Server Management

Sql Sql Server Tsql Ssms

SQL Server: should I use information_schema tables over sys tables?

Sql Sql Server Sql Server-2008 Stored Procedures Metadata

What are the benefits of using database cursor?

Sql Database Database Cursor

How to get the difference in years from two different dates?

How to get data by SqlDataReader.GetValue by column name

How do I count columns of a table

Drop default constraint on a column in TSQL

Sql Sql Server Database Tsql

Rails - Delete all Records that Meet a Condition

Sql Ruby on-Rails Activerecord

Add unique constraint in SQL Server 2008 GUI?

Sql Sql Server Ssms Sql Server-2008

Use results from one sql query in another where statement (subquery?)

Mysql Sql Subquery

psql: server closed the connection unexepectedly

Sql Postgresql Cmd

SQL - Difference between COALESCE and ISNULL?

Custom order by in SQL server like P, A, L, H

Sql Sql Server Sql Order-By

JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

Java Sql Oracle Resultset Getdate

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname

Java Mysql Sql Jdbc Connectivity

MySQL add a NOT NULL column

How to install localdb separately?

Sql Sql Server Localdb

SQL Server 2012 installation Reporting Services Catalog error

Sql Sql Server Visual Studio-2012 Sql Server-2012

SQL Server 2008 R2 Stuck in Single User Mode

Sql Sql Server Database Sql Server-2008 Database Deployment

Using Excel VBA to run SQL query

Sql Sql Server Vba Excel

DATEDIFF function in Oracle

Sql Oracle Select Datediff

How can I work with SQL NULL values and JSON in a good way?

Spark Window Functions - rangeBetween dates

Sql Apache Spark Pyspark Apache Spark-Sql Window Functions

How to set multiple values inside an if else statement?

Sql Sql Server Tsql

SQL Server User Mapping Error 15023