Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

Athena date_parse for date with optional millisecond field

sql amazon-athena presto

psycopg2 - Using SQL object with execute_values

How can I prevent integers being silently turned to asterisks in SQL Server?

sql sql-server

Does field size affect query time?

mysql sql database

What does "%%DatabaseEx" do in TSQL?

What is the difference between group by, distinct, Union for selecting distinct values for multiple columns?

sql group-by union distinct

Search column in SQL database ignoring special characters

Split a VARCHAR in DB2 to retrieve a value inside

sql string db2 split

entity framework entity sql vs linq to entities

sql entity-framework

Mysql: Optimizing finding super node in nested set tree

sql mysql nested-sets

Oracle - Return shortest string value in a set of rows

sql oracle plsql

How to tune a 7-table-join MySQL count query where tables contain 30,000+ rows?

sql mysql count performance

Conditional Where statement on a table valued parameter?

How to do bitwise exclusive OR in sql server between two binary types?

sql sql-server tsql

Error restoring database backup to new database with smo and powershell

exec sp_executesql @sql and exec (@sql) SQL Server

Cutting a database down to size

sql database

How to delete every record after the nth row in mysql?

mysql sql

Should I TRUNCATE TABLE before I DROP TABLE to avoid logging overhead?

Using SQL JOIN and UNION together