Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

SQL Server 2008 r2 - T-SQL LIKE or PATINDEX to match characters OTHER than A-Z, 0-9, hyphen, period, underscore and tilde

To get table details

Self join issue

where table.* <> table.* - Is there a way to do something like this?

How to write query that will do unusual distinct select from sql table?

sql tsql

Remove nulls from sub totals / grand totals in tsql rollup

tsql null rollup

WHERE on View Alias Causes Error

sql-server tsql

How can I get the text of a stored procedure into a single record in SQL Server 2000?

T-SQL and XML - concatenate parent and multiple child elements into result set

What does it mean to have several ON clauses from INNER JOINS together

Why does my defactored SQL run orders of magnitudes quicker?

sql sql-server tsql

Find if phonenumbers exist between 2 columns

sql tsql loops between

Check - Compare > Update SQL table

T-SQL equivalent to oracle sql where clause with multiple columns

Whats the best way to find the "next but one newest" date in SQL?

sql sql-server-2008 tsql

TSQL foreign keys on views?

Total sales per month

sql-server tsql

How to catch the output of a DBCC-Statement in a temptable

RAND not different for every row in T-SQL UPDATE

sql sql-server tsql

Can I optimize a SELECT DISTINCT x FROM hugeTable query by creating an index on column x?