Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Conditionally set a column to its default value in Postgres

sql postgresql

Is there any performance difference between a SQL "IN" statement versus using "OR"?

sql sql-server-2008 syntax

How to do a batch update?

c# sql sql-server linq-to-sql

How do I accurately handle a batch separator for SQL from C#

c# sql tsql parsing

Does Hibernate log the values that it assigns to placeholders in prepared SQL statements?

java sql hibernate logging log4j

Why does a query with a sub-select cost less than query with a constant in Oracle

sql oracle oracle11g toad

SQL Script - Check if a IP has been black listed

sql database tsql

Find rows that have a field which is a substring of the search string

sql postgresql

sqlite3 preparing, binding and resetting statements

Violation of UNIQUE KEY Contstraints - Cannot insert duplicate key

How do I build a Resource Governor classifier function based off of a database role?

sql sql-server

Why does the parameterized version of this query run slower than a non-parameterized version?

Efficient way to fetch the total number of records in SQL server during Paging

sql sql-server

Select column based on sum of another column

sql tsql

What types of situations are suited to use both a relational and NoSQL database?

sql nosql rdbms

"Pivoting" non-aggregate data in SQL Server

sql-server-2005 pivot sql

Postgresql pivot? Crosstab?

sql postgresql

ETL Processing Design and Performance

c# sql database etl

Is there a lightweight sql parser class written in PHP to do this? [closed]

php sql postgresql

How do I grant a database role execute permissions on a schema? What am I doing wrong?