Explain Codes LogoExplain Codes Logo

Sql

What represents a double in sql server?

sql
data-types
decimal
precision

Mysql variable format for a "NOT IN" list of values

sql
dynamic-sql
sql-performance
mysql-optimization

Get the SQL query result without the table format

sql
mysql-flags
output-customization
batch-mode

Can I pass column name as input parameter in a SQL stored procedure

sql
sql-injection
dynamic-sql
parameterization

Invalid use of side-effecting operator insert within a function

sql
best-practices
performance
error-handling

Mysql: Can't create table (errno: 150)

sql
foreign-keys
database-design
mysql-error

Sql Server silently truncates varchar's in stored procedures

sql
data-integrity
error-handling
sql-server

C# guid and SQL uniqueidentifier

sql
guid
sql-server
entity-framework

Sql query for finding records where count > 1

sql
performance
best-practices
indexing

Update if different/changed

sql
update-optimization
sql-optimization-techniques
database-performance

What is the difference between a stored procedure and a view?

sql
views
stored-procedures
database-performance

Multiple SQL statements in one roundtrip using Dapper.NET

sql
database-operations
dapper-net
query-multiple

Sql Server - How to lock a table until a stored procedure finishes

sql
lock-escalation
deadlocks
transaction-management

How do I get just the date when using MSSQL GetDate()?

sql
date-extraction
datetime
sql-server

Using column alias in WHERE clause of MySQL query produces an error

sql
subquery
alias
sql-optimization

Convert timestamp to date in Oracle SQL

sql
timestamp-conversion
date-formatting
oracle-sql

Group BY + CASE statement

sql
best-practices
join
sql-queries

How to count the number of occurrences for all different values in a database column?

sql
best-practices
performance
dataframe

What is the purpose of using WHERE 1=1 in SQL statements?

sql
dynamic-queries
orm-patterns
performance-optimization

Sql Query - Concatenating Results into One String

sql
string-aggregation
performance-optimization
sql-best-practices
explain.codes / Sql