Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in sql
How to create a unique index containing multiple fields where one is a foreign key
Aug 24, 2022
sql
node.js
typeorm
What are the consequences of not closing database connection after an error?
Oct 16, 2022
.net
sql
sql-server
sql-server-2005
web-services
Dates with no time or timezone component in Java/MySQL
Nov 15, 2022
java
sql
date
timezone
java-time
in SQL, or Django ORM, what's the conventional way to have an ordered one-to-many?
Apr 30, 2019
sql
django
Why does the SqlServer optimizer get so confused with parameters?
Oct 27, 2022
sql
sql-server
optimization
Preferred database design method for assigning user roles? (Hats vs. Groups)
May 31, 2021
sql
roles
security-roles
SQL Server 2005, turn columns into rows
Apr 25, 2022
sql
pivot
Should CONTROL permission be given on a Stored Procedure in SQL Server 2005?
Jun 27, 2018
sql
sql-server
sql-server-2005
permissions
controls
is it better to put more logic in your ON clause or should it only have the minimum necessary?
Jan 12, 2019
sql
sql-server
What are the best practices on formatting inline sql using ADO.NET in C#
Oct 16, 2022
c#
sql
ado.net
Using IsolationLevel.Snapshot but DB is still locking
Sep 24, 2022
sql
sql-server
ado.net
isolation-level
complex sql order by
Sep 25, 2022
sql
mysql
SQL Query, Selecting 5 most recent in each group
Feb 09, 2022
sql
mysql
select
sql-order-by
greatest-n-per-group
Need help with the Merge statement
Sep 16, 2022
sql
sql-server
tsql
sql-server-2008
Oracle bug? SELECT returns no dupes, INSERT from SELECT has duplicate rows
Nov 03, 2022
sql
oracle
plsql
oracle11g
SQL Count(*) on multiple tables
Aug 16, 2022
sql
count
Stored procedure executing another stored procedure
Aug 25, 2018
sql
sql-server
stored-procedures
correct way to create a pivot table in postgresql using CASE WHEN
Sep 06, 2022
sql
postgresql
pivot
pivot-table
case-when
How to Deal with SET ANSI_NULLS ON or OFF?
Nov 20, 2022
sql
sql-server
database
tsql
Verify two columns of two different tables match exactly
Feb 02, 2022
sql
database
sqlite
select
« Newer Entries
Older Entries »