Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Get seq number used by insert statement called from C# (oracle)

Performance issues calling stored proc from within a stored proc

Transform multiple queries into single row

sql reporting

compression, defragmentation, reclaiming space, shrinkdatabase vs. shrinkfile

How to know if an uncommitted transaction tries to insert a specific unique key into SQL

How to join multiple columns in one table to another lookup table?

sql sql-server

What are right parameter types of ODCIIndexInsert in case of creating indextype 'WITH ARRAY DML' option (documentation mismatch)

sql oracle-database plsql

ISNULL or any alternative in sql server when not data present for subquery

Merging two select queries and add zeros to columns if does not have values

mysql sql postgresql

SQL limit with joins

sql sql-server select join limit

Declare date and selected date not match

How to kill active sessions automatically?

sql oracle-database plsql

Sum of cash and cheque from a table

sql sql-server

What is key_ordinal = 0 for index columns

sql sql-server indexing

Pentaho Execute SQL Statements variable conversion to null

Updating the first occurrence of the column with a value and the remaining with other value

Drop tables that are not in a list?

mysql sql database sql-drop

Google BigQuery: UNNEST where each different key becomes a column

how to split a string which is having comma and colon

sql regex oracle-database