Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Delete Parent record if child is not present

sql sql-server

Using Case Statement in SQL with parameter/variable to check for Null values

sql null case where

Filling gaps in query return value

sql oracle

Performance difference between VARCHAR2 to NUMBER

How to use PDO::quote without getting string surrounded by quotes?

php sql pdo

Return empty or null fields as <element /> from SQL Server 2008 R2 with FOR XML

Mysql join order by

mysql sql

What exceptions to catch when dealing with SqlConnection, SqlDataReader, SqlCommand?

Why did creating this new index improve performance so much when existing index included all columns in new index?

How to reseed/replace identity columns on existing data

Would adding more specificity to a SELECT query make it faster?

mysql sql

How To Create Generic SQL Server Stored Procedure To Perform Inserts Into Audit Table Based on Inserted and Deleted In Trigger

use space for thousands separator reporting services

sql reporting-services

Nested Select in From Clause

sql oracle

Is CRUD DDL or DML operation?

sql crud

SQL No Dup (Distinct) on rows, but ignore one col

sql distinct

Distinguish between NULL's when using "group by ... with rollup"

mysql sql group-by rollup

Large PostgreSQL table: better to add a column or create a new table to store metadata?

Rails 3 update_all using data already contained in the table on a per-record basis

SSIS - Script Component, Split single row to multiple rows (Parent Child Variation)

sql vb.net ssis etl