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
Build complex rails SQL
Sep 11, 2018
sql
ruby-on-rails
ruby-on-rails-3
postgresql
activerecord
IF NOT EXISTS in Merge statement?
Apr 02, 2022
sql
sql-server
merge
self referencing table with child table
Jun 20, 2021
sql
sql-server-2008
tsql
hierarchical-data
When would sys.database_permissions contain a row with state = 'R'?
Jun 27, 2022
sql
sql-server
permissions
database-permissions
NOLOCK with Multithreading
Apr 13, 2021
.net
sql
sql-server
multithreading
tsql
Can't add index to persisted computed column because it is "of a type that is invalid for use as a key"
Dec 25, 2019
sql
sql-server
clr
SQL Server - Round TIME values to the next minute
Feb 05, 2021
sql
sql-server-2008
tsql
rounding
sqldatetime
node.js + postgres database transaction management
Nov 02, 2022
sql
database
postgresql
node.js
transactions
How can I prevent date overlaps in SQL?
Nov 13, 2022
sql
tsql
sql-server-2008-r2
T-SQL try ... catch and multiple batches (2 begin...end, if...else)
Jun 28, 2022
sql
sql-server
tsql
if-statement
try-catch
Is single sql statement always atomic in innodb?
Sep 23, 2022
mysql
sql
innodb
Yii limit on related model while querying
Sep 07, 2021
php
sql
yii
limit
Checking for maximum length of consecutive days which satisfy specific condition
Jul 09, 2019
mysql
sql
How to make a foreign key with a constraint on the referenced table in PostgreSQL
Nov 20, 2022
sql
postgresql
constraints
SQL query to retrieve the single line of data with desired values for the columns
Sep 24, 2022
sql
sql-server
sql-server-2008
group-by
duplicate-removal
Is a SQL Server index B-tree a flat structure or a depth structure
Aug 20, 2022
sql
sql-server-2008
data-structures
indexing
SSAS One to Many Dimensional Relationship
Sep 07, 2022
sql
ssas
relationship
dimensions
primary-key-design
JPA GROUP BY entity - is this possible?
Aug 17, 2022
java
sql
hibernate
jpa
MySQL INSERT with multiple nested SELECTs
Oct 28, 2022
sql
select
insert
nested
Can't UNION ALL on a temporary table?
May 13, 2022
mysql
sql
« Newer Entries
Older Entries »