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
check for point in a polygon
Nov 03, 2022
mysql
sql
polygon
point
Truncate nvarchar(max) to nvarchar(n) with ellipses
Nov 13, 2022
sql
sql-server
tsql
Update row with check by linq2db in one atomic operation
Jul 14, 2022
c#
sql
database
linq2db
Extracting a string using SQL PATINDEX, substring of varying sizes
Nov 01, 2022
sql
regex
sql-server-2012
substring
Get Current Unix Epoch Time-stamp in seconds in SQL Server
Apr 08, 2021
sql
sql-server
Get first and last date time from each date in query SQL Server
Oct 14, 2022
sql
sql-server
Wrong PostgreSQL query results with explicit locks and concurrent transaction
Aug 15, 2017
sql
postgresql
transactions
locking
T-SQL Unique Identity Column as Part of Composite Primary Key
Aug 13, 2018
sql
sql-server
tsql
primary-key
composite-primary-key
Difference between cross product (cross join, Cartesian product) and natural join
Nov 07, 2022
sql
cartesian-product
cross-join
natural-join
How to change the date format when the file is spooled in oracle
Feb 10, 2022
sql
oracle
Limit a LEFT JOIN Subquery to 1 result
Aug 31, 2022
mysql
sql
How to execute sql query files via RPostgreSQL
Apr 13, 2022
sql
r
postgresql
rpostgresql
Use SQL keyword as alias name of a column
Sep 25, 2022
mysql
sql
select
alias
keyword
How to create a indexed view with tables from 2 different databases using Schemabinding
Apr 13, 2022
sql
sql-server
sql-server-2008-r2
Combining results before grouping in SQL
Jan 25, 2021
sql
sql-server
tsql
select
group-by
h2 VIEW has problems with correct SELECT statement
Sep 21, 2021
sql
h2
I need to optimize my first T-SQL update trigger
Aug 05, 2022
sql
sql-server
tsql
triggers
Horizontal to vertical display using Dynamic Pivot Function
Jun 20, 2022
sql
sql-server
pivot
B-Tree vs Bitmap database indexes
Sep 11, 2022
sql
database
oracle
Composite primary key
May 31, 2022
sql
database
primary-key
composite
« Newer Entries
Older Entries »