Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

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

Trim string based on characters

Group dates by 7 days excluding specific dates

SQL Server Check if day does not fall on weekend and if so, iterate to a weekday

sql-server t-sql

using aggregate function once instead of multiple times inside a stored procedure

sql t-sql

Create list of dates, a month apart, starting from current date

sql sql-server t-sql

Maximum Count Range Intersection (in T-SQL)

T-SQL querying XML column with XPath very slow - how to improve, or alternatives?

sql-server xml t-sql xpath

generating json from bad mysql-formatted dates in asp

Generate XML from SQL Server by select multiple tables to a certain file location

sql-server xml t-sql