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
Delete Parent record if child is not present
Feb 27, 2022
sql
sql-server
Using Case Statement in SQL with parameter/variable to check for Null values
May 23, 2022
sql
null
case
where
Filling gaps in query return value
Jun 24, 2022
sql
oracle
Performance difference between VARCHAR2 to NUMBER
Sep 25, 2022
sql
database
performance
oracle
How to use PDO::quote without getting string surrounded by quotes?
Jun 15, 2022
php
sql
pdo
Return empty or null fields as <element /> from SQL Server 2008 R2 with FOR XML
May 21, 2022
sql
sql-server
xml
sql-server-2008-r2
Mysql join order by
Oct 23, 2021
mysql
sql
What exceptions to catch when dealing with SqlConnection, SqlDataReader, SqlCommand?
Apr 06, 2019
c#
.net
sql
exception
exception-handling
Why did creating this new index improve performance so much when existing index included all columns in new index?
Jun 27, 2022
sql
sql-server
database
tsql
indexing
How to reseed/replace identity columns on existing data
Mar 17, 2022
sql
sql-server
sql-server-2008
tsql
Would adding more specificity to a SELECT query make it faster?
Jun 02, 2018
mysql
sql
How To Create Generic SQL Server Stored Procedure To Perform Inserts Into Audit Table Based on Inserted and Deleted In Trigger
Dec 19, 2021
sql
sql-server
stored-procedures
triggers
audit
use space for thousands separator reporting services
Jul 21, 2020
sql
reporting-services
Nested Select in From Clause
Sep 22, 2022
sql
oracle
Is CRUD DDL or DML operation?
Dec 20, 2017
sql
crud
SQL No Dup (Distinct) on rows, but ignore one col
Jul 14, 2022
sql
distinct
Distinguish between NULL's when using "group by ... with rollup"
Mar 07, 2017
mysql
sql
group-by
rollup
Large PostgreSQL table: better to add a column or create a new table to store metadata?
Feb 03, 2022
sql
json
postgresql
database-design
Rails 3 update_all using data already contained in the table on a per-record basis
Apr 07, 2020
sql
ruby-on-rails-3
update-all
SSIS - Script Component, Split single row to multiple rows (Parent Child Variation)
Jul 02, 2019
sql
vb.net
ssis
etl
« Newer Entries
Older Entries »