Explain Codes LogoExplain Codes Logo

Sql

Why is SQL server throwing this error: Cannot insert the value NULL into column 'id'?

sql
identity-specification
auto-increment
primary-key-constraint

Why do you create a View in a database?

sql
data-manipulation
database-design
performance-optimization

What should be the best way to store a percent value in SQL-Server?

sql
data-integrity
precision-control
decimal-data-type

What is the SYSNAME data type in SQL Server?

sql
sql-injection
dynamic-sql
metadata-operations

What is it exactly a BLOB in a DBMS context

sql
blob-storage
database-management
data-security

What are the pros and cons of performing calculations in sql vs. in your application

sql
database-performance
sql-vs-java
data-transfer

What are good ways to prevent SQL injection?

sql
sql-injection-prevention
parameterized-queries
orm-security

Ways to save enums in a database

sql
enum-storage
database-design
data-integrity

Update a Table with Data from Another Table

sql
join
subquery
update

Update and REPLACE part of a string

sql
update
replace
sql-queries

Unresolved Reference to Object [INFORMATION_SCHEMA].[TABLES]

sql
sql-server
database-projects
intellisense

Truncate/clear table variable in SQL Server 2008

sql
transaction-log
performance-optimization
temp-tables

To prevent a memory leak, the JDBC Driver has been forcibly unregistered

sql
connection-pooling
jdbc-driver
memory-leak

The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'

sql
permissions
sql-server
grant-select

Strip last two characters of a column in MySQL

sql
join
best-practices
performance

Sql: Subtracting 1 day from a timestamp date

sql
timestamp-manipulation
date-trunc
interval-functions

Sql statement to get column type

sql
sql-queries
database-schema
data-types

Sql Server - stop or break execution of a SQL script

sql
error-handling
control-flow
sql-server

Sql Server replace, remove all after certain character

sql
sql-queries
string-manipulation
database-optimization

Sql Server - Create a copy of a database table and place it in the same database?

sql
data-duplication
sql-server
database-management
explain.codes / Sql