Explain Codes LogoExplain Codes Logo

Sql

Show MySQL host via SQL Command

sql
mysql
sql-commands
database-troubleshooting

How to update and order by using ms sql

sql
subqueries
update-rows
sql-tricks

Get the last day of the month in SQL

sql
performance
best-practices
functions

How much disk-space is needed to store a NULL value using postgresql DB?

sql
database-administration
performance-optimization
data-management

Define variable to use with IN operator (T-SQL)

sql
table-variables
in-operator
sql-server

T-sql split string based on delimiter

sql
string-splitting
sql-server
delimiter

Postgresql Foreign Key syntax

sql
foreign-key
database-design
data-integrity

How to delete from multiple tables in MySQL?

sql
join
foreign-key
subqueries

I want to use CASE statement to update some records in SQL Server 2005

sql
join
case-statement
update-queries

What is the difference between single quotes and double quotes in PostgreSQL?

sql
best-practices
sql-queries
database-management

Sql query to get most recent row for each instance of a given key

sql
prompt-engineering
best-practices
performance

Sql - many-to-many table primary key

sql
data-integrity
indexing-strategies
orm-tools

Jdbc ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

sql
datetime
jdbc
timestamp

Counting number of joined rows in left join

sql
join
best-practices
performance

When should I use stored procedures?

sql
database-security
performance-optimization
best-practices

I want to show all tables that have specified column name

sql
database-agnostic
sql-queries
metadata

How do you drop a default value or similar constraint in T-SQL?

sql
prompt-engineering
best-practices
sql-server

Sql Server Script to create a new user

sql
sql-server
database-creation
user-management

"data too long for column" - why?

sql
data-types
encoding
database-design

Mysql combine two columns into one column

sql
concatenation
string-manipulation
sql-best-practices
explain.codes / Sql