Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

SQL Update if null add 1 otherwise add 1 to current value

sql sql-server t-sql

Converting SQL to QueryOver for getting a row count with group bys

c# sql sql-server nhibernate

Syntax confusion in SQL

sql average

NotesSQL to Notes 9 ODBC Connection resulting in IM005(0)[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

SQL Server trusted connection has wrong user in IIS, but SSMS is OK

WHERE with CASE and null checking

sql t-sql date null where-clause

Find the the value of one field that matches the maximum value of data in another field

How can you have a column equal ALL items in a list?

sql sql-server

SQL Server update statement with join

How to get duration from SQL when times overlap? Also, how do you get idle time from sql

sql sql-server

Laravel and Eloquent - applying different filters

php sql laravel eloquent

SQL statement with an impossible constant comparison

sql sql-server

"tempdb.mdf" increasing to astronomical sizes (i.e. 800GB) due to SQL query

refactoring postgres join vs except

how to find duplicate values using row_number and partition by

join a column that contains the previous max

sql t-sql join max

How to do natural join when the common column have different names?

sql natural-join

Truncate SQL varchar column

sql sql-server