Explain Codes LogoExplain Codes Logo

Sql

How can I do a BEFORE UPDATED trigger with sql server?

sql
best-practices
data-integrity
trigger-optimization

How to escape simple SQL queries in C# for SqlServer

sql
sql-injection
parameterized-queries
sql-security

Mysql where NOT IN name array?

sql
sql-injection
prepared-statements
database-security

How to add a variable number of hours to a date in PostgreSQL?

sql
interval-data-type
timestamp
date

How to subtract 30 days from the current date using SQL Server

sql
date-manipulation
datetime
sql-functions

Entity Framework throws exception - Invalid object name 'dbo.BaseCs'

sql
entity-framework
database-configuration
error-handling

How to aggregate values into an array in PostgreSQL?

sql
array-aggregation
postgresql
data-mining

Convert date to YYYYMM format

sql
date-formatting
sql-server
performance-optimization

Use a LIKE statement on SQL Server XML Datatype

sql
xml
performance
full-text search

Get affected rows on ExecuteNonQuery

sql
transactions
resource-management
sql-operations

Mysql update query with sub query

sql
subqueries
join
performance

What datatype to use when storing latitude and longitude data in SQL databases?

sql
data-integrity
geospatial-data
database-optimization

How do you update a DateTime field in T-SQL?

sql
best-practices
datetime
sql-server

How can you get the active users connected to a PostgreSQL database via SQL?

sql
database-activity
postgresql
sql-queries

Mysql INSERT INTO table VALUES.. vs INSERT INTO table SET

sql
insert-optimizations
sql-injections
bulk-insert

Sql: How do I use a parameter for TOP like in SELECT TOP @amount?

sql
sql-server-standards
query-optimization
performance-tuning

Sql Server ':setvar' Error

sql
sqlcmd-mode
sql-server-error
variable-setting

Returning Month Name in SQL Server Query

sql
date-format
sql-server
date-manipulation

Boolean Expressions in SQL Select list

sql
best-practices
functions
join

Using GROUP_CONCAT on subquery in MySQL

sql
subquery
group_concat
sql-queries