Explain Codes LogoExplain Codes Logo

Sql

Selecting data from two different servers in SQL Server

sql
linked-servers
cross-server-communication
sql-server

Mysql: difference between two timestamps in seconds?

sql
timestampdiff
unix_timestamp
datetime

How do I restore a dump file from mysqldump?

sql
mysql
database
backup

Size of VARBINARY field in SQL Server 2005

sql
data-length
varbinary
sql-server

Sql Select Only Rows with Max Value on a Column

sql
window-functions
sql-performance
database-optimization

Mysql add days to a date

sql
date-manipulation
mysql-functions
sql-queries

Get the records of last month in SQL server

sql
performance
best-practices
date-functions

Simulating group_concat MySQL function in Microsoft SQL Server 2005?

sql
join
performance
best-practices

Sql Query - Using Order By in UNION

sql
join
best-practices
dataframe

Sql Query to list all views in an SQL Server 2005 database

sql
join
performance
best-practices

Get SQL query count during a Django shell session

sql
database-performance
django-extensions
query-tracking

How many rows in a database are TOO MANY?

sql
performance-optimization
database-optimization
indexing

Can I create a named default constraint in an add column statement in SQL Server?

sql
default-constraints
sql-server
database-design

The object 'DF__*' is dependent on column '*' - Changing int to double

sql
database-operations
error-handling
data-types

Why is there no PRODUCT aggregate function in SQL?

sql
sql-server
custom-aggregates
workarounds

Is this the proper way to do boolean test in SQL?

sql
boolean-logic
database-quirks
sql-standards

Delete SQL rows where IDs do not have a match from another table

sql
delete-operations
sql-patterns
database-management

Mysql SELECT IF statement with OR

sql
prompt-engineering
best-practices
performance

How to convert DateTime to VarChar

sql
datetime-conversion
sql-functions
date-formatting

On DELETE CASCADE in sqlite3

sql
foreign-keys
database-design
sqlite
explain.codes / Sql