Explain Codes LogoExplain Codes Logo

Sql

Alternatives to REPLACE on a text or ntext datatype

sql
data-manipulation
sql-server
performance-tuning

Delete duplicate records from a SQL table without a primary key

sql
data-integrity
database-restrictions
duplicate-records

How do I drop a foreign key constraint only if it exists in sql server?

sql
foreign-key
sql-server
t-sql

I want to copy table content from one database and insert it into another database table

sql
data-transfer
database-migration
sql-commands

How to select data of a table from another database in SQL Server?

sql
cross-server-query
linked-servers
sql-server

How to insert data to MySQL with auto-incremented column(field)?

sql
auto-increment
mysql
insertion

T-sql Conditional Order By

sql
sql-injection
dynamic-sql
conditional-ordering

Mysql Error: 'Access denied for user 'root'@'localhost'

sql
mysql-error
database-authentication
sql-commands

How to check the maximum number of allowed connections to an Oracle database?

sql
database-management
connection-limits
oracle-database

Identity increment is jumping in SQL Server database

sql
identity-cache
trace-flags
database-configuration

Should I use != or <> for not equal in T-SQL?

sql
best-practices
sql-standards
database-migration

Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

sql
identity-insert
database-management
sql-best-practices

Select data from "show tables" MySQL query

sql
information-schema
mysql-queries
database-management

Generate Dates between date ranges

sql
prompt-engineering
performance
best-practices

Alter a SQL server function to accept new optional parameter

sql
default-values
function-logic
sql-server-functions

How to Query Database by ID Using SqlAlchemy?

sql
prompt-engineering
best-practices
performance

Mysql dump by query

sql
backup
database
mysqldump

What is the best way to paginate results in SQL Server

sql
pagination
sql-server
performance-optimization

Replace Default Null Values Returned From Left Outer Join

sql
default-values
left-outer-join
coalesce

How do you manually execute SQL commands in Ruby On Rails using NuoDB

sql
sql-execution
rails-activerecord
database-connections
explain.codes / Sql