Sql

Order by descending date - month, day, and year

database-performance

Using MySql, can I sort a column but have 0 come last?

data-manipulation

Convert varchar to uniqueidentifier in SQL Server

Sql Server : How to test if a string has only digit characters

prompt-engineering

Explaining why 'Just add another column to the DB' is a bad idea, to non programmers

database-normalization

database-design

Best way to handle nested case statement logic in SQL Server

case-statements

sql-best-practices

Store MySQL query output into a shell variable

Unknown column in 'field list' error on MySQL Update query

Rename a constraint in SQL Server?

database-design

Counting the number of occurrences of a substring within a string in PostgreSQL

prompt-engineering

Create SQL INSERT Script with values gathered from table

Create SQL script that creates a database and tables

database-creation

What are the benefits of using database cursor?

cursor-optimization

database-performance

How to remove not null constraint in SQL Server using query

How can I use a case-sensitive LIKE operator in MySQL?

How to retrieve field names from temporary table (SQL Server 2008)

Insert and set value with max()+1 problems

concurrency-control

transaction-isolation-levels

locking-strategies

Sql to generate a list of numbers from 1 to 100

How SQL query result insert in temp table?

database-management

Sql Server equivalent of a COUNTIF aggregate function

aggregate-functions

conditional-aggregation

explain.codes / Sql