Explain Codes LogoExplain Codes Logo

Sql

Sql Server 2008 R2 Stuck in Single User Mode

sql
sql-server
single-user-mode
maintenance-mode

Sql Query to add a new column after an existing column in SQL Server 2005

sql
best-practices
data-loss
referential-integrity

Sql left join vs multiple tables on FROM line?

sql
join
sql-optimization
best-practices

Sql LEFT JOIN Subquery Alias

sql
subquery
left-join
sql-best-practices

Sql: Combine Select count(*) from multiple tables

sql
join
subquery
performance

Sql - Call Stored Procedure for each record

sql
cursor-management
performance-optimization
best-practices

Sqlalchemy: print the actual query

sql
query-analysis
sqlalchemy
debugging

Splitting string into multiple rows in Oracle

sql
string-splitting
oracle-sql
data-refinement

Sorting by date & time in descending order?

sql
sorting
datetime
timestamp

Singular or plural database table names?

sql
best-practices
database-design
naming-conventions

Simple way to transpose columns and rows in SQL?

sql
pivot-tables
dynamic-sql
string-aggregation

Server returns invalid timezone. Go to Advanced tab and set servertimezone property manually

sql
database-connections
timezone-configuration
intellij-settings

Save PL/pgSQL output from PostgreSQL to a CSV file

sql
prompt-engineering
best-practices
security

Retrieving the last record in each group - MySQL

sql
window-functions
database-performance
indexing-strategies

Rename a column in MySQL

sql
mysql-renaming
sql-syntax
database-management

Printing integer variable and string on same line in SQL

sql
data-type-compatibility
sql-server
variable-declaration

Preparedstatement with list of parameters in a IN clause

sql
sql-injection
prepared-statements
database-performance

Postgresql wildcard LIKE for any of a list of words

sql
full-text-search
pattern-matching
sql-performance

Postgresql query to count/group by day and display days with no data

sql
performance
best-practices
join

Possible to restore a backup of SQL Server 2014 on SQL Server 2012?

sql
database-migration
sql-server-2012
sql-server-2014