Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

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

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