Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

SQL Server: How do you remove punctuation from a field?

Getting week number off a date in MS SQL Server 2005?

sql-server tsql

SQL LOOP INSERT Based on List of ID's

TSQL: How to get a list of groups that a user belongs to in Active Directory

How to rename the Physical Database Files

sql-server tsql mdf ldf

Using T-SQL, return nth delimited element from a string

Simple way to prevent a Divide By Zero error in SQL

What is your biggest SQL Server mistake or embarrassing incident?

Why would wrapping a TSQL query in an if statement increase its runtime significantly?

Select query skips records during concurrent updates

Merging duplicated records together with "Merge" syntax

SQL Server 2005, how to copy a Database Diagram to another server

sql sql-server-2005 tsql ssms

"If not exists" fails on SQL CE

Special character (Hawaiian 'Okina) leads to weird string behavior

Ignore SQL INNER JOIN if there are no records to join?

sql-server tsql inner-join

Does SQL Server short-circuit IF statements?

Backup/Restore the database using T-SQL (MSSQL2005, 2008)

tsql

How to fix "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS" error?

sql sql-server tsql exists

SQL TOP 5000 faster than normal query with less than 5000 result rows?

sql sql-server tsql

SQL Server: Replace invalid XML characters from a VARCHAR(MAX) field