Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Alternative to STRING_AGG in with SQL

TSQL: How do I do a self-join in XML to get a nested document?

How to copy entire SQL Server 2008 database, applying WHERE clause to restrict copied data

Count each element within XML node instead of continuous counting

sql sql-server xml t-sql xquery

DATEDIFF SQL Server 2016 JSON

Performance of a SQL Server Scalar Function

Way to find the maximum dates with no futuristic dates

sql sql-server database t-sql

Returning the original value if it doesn't match any of the when_expressions

sql sql-server t-sql case-when

How to parse XML encoded as UTF-8 from a NVARCHAR(MAX) attribute?

Using LIKE within CASE in TSQL

sql t-sql case sql-like

Select Test As [text()]

t-sql

Type cast error when unpivoting columns, why?

How do I use a Select Statement as the Source in a T-SQL Merge Update

sql-server t-sql merge

Truncating date + time using DateTime2

sql-server t-sql datetime

Error when using single quote with sp_executesql

sql sql-server t-sql

Decrypting data in SQL Server and pushing to a view

WHERE greater than a given datetime to reduce queried rows

sql t-sql sql-server-2014

Variables in SQL query

sql sql-server t-sql variables

Want 'Exists' in a Where clause to be used only when passed parameter has a value

sql sql-server t-sql