Explain Codes LogoExplain Codes Logo

Sql

Is There `StartsWith` or `Contains` in T-SQL with Variables?

sql
wildcards
performance
best-practices

How do I import a sql data file into SQL Server?

sql
import-data
sql-server
command-line-tool

How to Execute SQL Query without Displaying Results

sql
result-suppression
sql-commands
database-performance

Mysql Trigger after update only if row has changed

sql
database-performance
trigger-logic
sql-queries

How to find current transaction level?

sql
transaction-isolation
sql-server
database-management

Can I parameterize the table name in a prepared statement?

sql
sql-injection
dynamic-sql
security-best-practices

How to design a database for User Defined Fields?

sql
database-design
performance-optimization
data-structure

Equivalent of Oracle's RowID in SQL Server

sql
join
best-practices
performance

Difference between View and table in SQL

sql
data-management
database-design
performance-optimization

Are Views automatically updated

sql
indexed-views
database-performance
view-refresh

How can I check if a View exists in a Database?

sql
database-views
sql-server
best-practices

How to generate the whole database script in MySQL Workbench?

sql
database-backup
mysql-workbench
sql-scripts

How to export output in "real" CSV format in SQL Server Management Studio(SSMS)?

sql
prompt-engineering
best-practices
data-types

Standard use of 'Z' instead of NULL to represent missing data?

sql
best-practices
data-management
database-design

How to include "zero" / "0" results in COUNT aggregate?

sql
join
aggregate-functions
subqueries

Get month name from date in Oracle

sql
date-formatting
oracle-sql
best-practices

How to use multiple LEFT JOINs in SQL?

sql
join
performance
best-practices

Get last record of a table in Postgres

sql
prompt-engineering
best-practices
performance

Mysql Group By and Sum total value of other column

sql
sql-best-practices
sql-queries
sql-tips

Comparing results with today's date?

sql
database-specific-functions
indexing-performance
date-manipulation