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 tsql
SQL Server: How do you remove punctuation from a field?
Jan 16, 2019
sql
sql-server
tsql
replace
punctuation
Getting week number off a date in MS SQL Server 2005?
Nov 15, 2022
sql-server
tsql
SQL LOOP INSERT Based on List of ID's
Mar 01, 2022
sql
sql-server-2005
tsql
loops
insert
TSQL: How to get a list of groups that a user belongs to in Active Directory
Mar 28, 2019
sql
sql-server
tsql
active-directory
How to rename the Physical Database Files
Sep 25, 2018
sql-server
tsql
mdf
ldf
Using T-SQL, return nth delimited element from a string
Sep 21, 2022
sql-server
sql-server-2008
tsql
split
Simple way to prevent a Divide By Zero error in SQL
Sep 21, 2022
sql
sql-server-2008
tsql
sql-server-2005
What is your biggest SQL Server mistake or embarrassing incident?
Sep 21, 2022
sql-server
sql-server-2005
tsql
Why would wrapping a TSQL query in an if statement increase its runtime significantly?
Sep 21, 2022
sql
performance
tsql
if-statement
Select query skips records during concurrent updates
Apr 01, 2021
sql-server
sql-server-2008
tsql
concurrency
locking
Merging duplicated records together with "Merge" syntax
Sep 21, 2022
sql
sql-server
tsql
sql-server-2014
SQL Server 2005, how to copy a Database Diagram to another server
Aug 17, 2022
sql
sql-server-2005
tsql
ssms
"If not exists" fails on SQL CE
Jul 24, 2020
sql-server
tsql
sql-server-ce
Special character (Hawaiian 'Okina) leads to weird string behavior
Oct 31, 2022
sql-server
tsql
unicode
collation
Ignore SQL INNER JOIN if there are no records to join?
Sep 21, 2022
sql-server
tsql
inner-join
Does SQL Server short-circuit IF statements?
Sep 21, 2022
sql-server
tsql
query-optimization
short-circuiting
Backup/Restore the database using T-SQL (MSSQL2005, 2008)
Dec 04, 2019
tsql
How to fix "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS" error?
Sep 23, 2022
sql
sql-server
tsql
exists
SQL TOP 5000 faster than normal query with less than 5000 result rows?
Sep 21, 2022
sql
sql-server
tsql
SQL Server: Replace invalid XML characters from a VARCHAR(MAX) field
Mar 15, 2022
sql
sql-server
xml
tsql
sql-server-2012
« Newer Entries
Older Entries »