Sql
Should every table in a database have an identity field to use as a PK?
sql
best-practices
data-integrity
database-design
Get everything after and before certain character in SQL Server
sql
substring-manipulation
sql-functions
data-sanitization
Avoid duplicates in INSERT INTO SELECT query in SQL Server
sql
sql-server
database-performance
query-optimization
Split comma separated column data into additional columns
sql
best-practices
performance
functions
How to update rows with a random date
sql
performance
best-practices
database
How do I do top 1 in Oracle?
sql
analytical-functions
database-optimization
oracle-12c
How to filter SQL results in a has-many-through relation
sql
join
subqueries
ctes
How can I list ALL grants a user received?
sql
database-management
oracle-database
sql-queries
How to find column names for all tables in all databases in SQL Server
sql
database-management
sql-server
information-schema
Exec failed because the name not a valid identifier?
sql
sql-injection
dynamic-sql
performance-optimization
Mysql SELECT DISTINCT multiple columns
sql
distinct-values
sql-queries
database-performance
How to Select Top 100 rows in Oracle?
sql
rownum
fetch-first
oracle-12c
Oracle DateTime in Where Clause?
sql
date-format
oracle-sql
performance-optimization
Storing DateTime (UTC) vs. storing DateTimeOffset
sql
datetimeoffset
datetime
best-practices
If-then-else statements in postgresql
sql
prompt-engineering
best-practices
case-statements
Are soft deletes a good idea?
sql
data-integrity
database-performance
best-practices
Sql primary key: integer vs varchar
sql
data-integrity
database-design
primary-keys
Getting result of dynamic SQL into a variable for sql-server
sql
sql-injection
dynamic-sql
error-handling
Sql for ordering by number - 1,2,3,4 etc instead of 1,10,11,12
sql
sql-sorting
varchar-gotcha
conditional-cast
Transfer data from one database to another database
sql
data-transfer
sql-server-management-studio
database-migration
Prev
1
...
37
38
39
...
95
Next
explain.codes
/
Sql
