Explain Codes LogoExplain Codes Logo

Sql

How can you tell if a value is not numeric in Oracle?

sql
data-validation
oracle-12c
numeric-validation

Which sql server data type best represents a double in C#?

sql
precision
rounding
data-type

Execute STORED PROCEDURE FROM A FUNCTION

sql
sqlclr
stored-procedures
dynamic-sql

How to log SQL statements in Grails

sql
logback
sql-logging
hibernate

Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

sql
join
best-practices
performance

Sql formatting standards

sql
best-practices
sql-formating
database-optimization

Best way to check for "empty or null value"

sql
prompt-engineering
best-practices
performance

Is there a LastIndexOf in SQL Server?

sql
udfs
performance
ctes

Drop view if exists

sql
best-practices
sql-server
view-management

Fastest Way of Inserting in Entity Framework

sql
bulk-insert
entity-framework
performance-optimization

Referring to a Column Alias in a WHERE Clause

sql
prompt-engineering
best-practices
performance

How to assign an exec result to a SQL variable?

sql
stored-procedures
sql-best-practices
sql-performance

Delete all rows in a table based on another table

sql
join
performance
best-practices

Count records for every month in a year

sql
prompt-engineering
best-practices
join

Naming of ID columns in database tables

sql
best-practices
database-design
data-relationships

Comparing date ranges

sql
date-functions
performance-optimization
best-practices

Altering a column to be nullable

sql
data-integrity
database-design
sql-queries

Mysql - Way to update portion of a string?

sql
string-manipulation
regex
conditional-logic

Create unique constraint with null columns

sql
unique-constraint
postgresql
null-values

Cleansing User Passwords

sql
password-security
hashing-algorithms
sql-injections