DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
The Life Changing Magic of Migrating Github repositories with Transposit

The Life Changing Magic of Migrating Github repositories with Transposit

4
Comments
4 min read
SQL order from API chaos

SQL order from API chaos

6
Comments
3 min read
Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

17
Comments 4
6 min read
When query db should I check if data exists first then select it ?

When query db should I check if data exists first then select it ?

5
Comments 2
1 min read
Oracle and SQLite compiler are now available in SqlKata

Oracle and SQLite compiler are now available in SqlKata

5
Comments
1 min read
What is SQL injection?

What is SQL injection?

12
Comments 5
2 min read
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

10
Comments 1
6 min read
Dynamic SQL cheatsheet

Dynamic SQL cheatsheet

13
Comments
2 min read
Check if temp table exists in SQL

Check if temp table exists in SQL

3
Comments
1 min read
SQL Server 2016’s STRING_SPLIT

SQL Server 2016’s STRING_SPLIT

7
Comments
1 min read
Implementing Soft-Delete in pure MySQL

Implementing Soft-Delete in pure MySQL

9
Comments
3 min read
More Secure and Productive Database and Code Development in Updated SQL Complete

More Secure and Productive Database and Code Development in Updated SQL Complete

8
Comments
1 min read
Nylas is Hiring a Senior Software Engineer

Nylas is Hiring a Senior Software Engineer

8
Comments
2 min read
SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

13
Comments
1 min read
Nylas is Hiring a Senior Software Engineer

Nylas is Hiring a Senior Software Engineer

8
Comments
2 min read
Check if type exists in MSSQL

Check if type exists in MSSQL

5
Comments
1 min read
Find column from all tables

Find column from all tables

4
Comments
1 min read
Connecting to SQL over TCP/IP with Entity Framework

Connecting to SQL over TCP/IP with Entity Framework

7
Comments 1
1 min read
PostgreSQL: Efficient Queries - Indexing

PostgreSQL: Efficient Queries - Indexing

4
Comments 1
1 min read
MySQL Global Vars wait_timeout & max_connections

MySQL Global Vars wait_timeout & max_connections

2
Comments
1 min read
MySql Version "Correlated Sub-Queries and Group By Unions"

MySql Version "Correlated Sub-Queries and Group By Unions"

3
Comments
1 min read
SQL Correlated Sub-Queries and Group By Unions

SQL Correlated Sub-Queries and Group By Unions

5
Comments
2 min read
SQL Get most recent records with group by

SQL Get most recent records with group by

3
Comments
2 min read
SQL INSERT with WHERE clause

SQL INSERT with WHERE clause

4
Comments
1 min read
Sql threesomes.. Two foreign keys, one primary key

Sql threesomes.. Two foreign keys, one primary key

5
Comments
2 min read
loading...