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
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
Add new column without table lock?
Oct 30, 2022
sql
postgresql
heroku
locking
thinking-sphinx
Find all geometry that intersects a point
Mar 01, 2022
sql
gis
postgis
How to import tables without losing indexes and keys in SQL Server 2008
Nov 13, 2019
sql
sql-server
ERROR: subquery in FROM cannot refer to other relations of same query level
Oct 28, 2020
sql
postgresql
subquery
nearest-neighbor
correlated-subquery
How can I return variable column lengths via LINQ to SQL
May 30, 2022
c#
.net
sql
linq
tsql
MySQL INSERT with multiple nested SELECTs
Oct 28, 2022
sql
select
insert
nested
« Newer Entries
Older Entries »