Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to find out whether a table has some unique columns

sql sql-server unique

Storing a multiple choice quiz in a database - deciding the schema

Selecting multiple rows by ID, is there a faster way than WHERE IN

sql sql-server-2008-r2

Deleting duplicates keeping the minimum ID

How to rename table using SSDT in Visual Studio

How does SQLDataReader handle really large queries?

c# sql

Fuzzy text searching in Oracle

sql oracle fuzzy-search

Valid GROUP BY query doesn't work when combined with INSERT INTO on Oracle

sql oracle oracle12c

With sql find next available integer within range that is not present in existing integer subset(s)

Is it possible to use analytic functions in Hibernate?

sql hibernate

varchar(255) v tinyblob v tinytext

sql mysql database-design

SQL group by day, show orders for each day

Can T-SQL store ulong's?

c# .net sql bigint ulong

How To Avoid Locking Database In Entity Framework 4 When Doing Many Updates

c# sql entity-framework

Return value in SQL Server stored procedure

HQL: Is it possible to perform an INNER JOIN on a subquery?

sql hibernate hql

Query featuring outer joins behaves differently in Oracle 12c

sql oracle oracle12c

Exec stored procedure into dynamic temp table

SET extra_float_digits = 3 in postgresql

sql database postgresql

Why did SQL Server suddenly decide to use such a terrible execution plan?

sql sql-server performance