Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Aggregate functions are not allowed in a recursive query. Is there an alternative way to write this query?

Matching a value to multiple columns (in one statement) from a table using MySQL

sql mysql

I need to remove a unique constraints that I don't know the names of

SQL Server: Permissions on table

sql sql-server

Scalability of Using MySQL as a Key/Value Database

How do you measure the number of open database connections

How to obtain NHibernate generated SQL in code at runtime?

.net sql nhibernate

Appropriate Uses of the `IDENTITY` in TSQL [duplicate]

sql tsql syntax identity

Connecting to SQL Server from java with TCP disabled

Querying sequences of rows in SQL

sql regex

How to copy tables avoiding cursors in SQL?

What is cardinality and how does it affect performance (SQL Server)?

TSQL Update DATETIME Minutes and Seconds

sql sql-server tsql

Does rowversion/timestamp affects performance significantly?

Difference between a hibernate transaction and a database transaction done using sql queries?

sql hibernate transactions

sql left join +one to many relationship

sql left-join

Dealing with quotes added by PDO::prepare()

php mysql sql pdo

Strange behaviour of full outer join in Oracle - how it could be explained?

sql oracle oracle11g

Oracle CONNECT BY clause after GROUP BY clause

Why an union is faster than a group by

sql