Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

TSQL left join and only last row from right

sql sql-server tsql left-join

INT vs Unique-Identifier for ID field in database

Column conflicts with the type of other columns in the unpivot list

sql sql-server-2008 tsql

XML query() works, value() requires singleton found xdt:untypedAtomic

T-SQL: How can you create a table with SELECT?

oracle tsql

ado.net Closing Connection when using "using" statement

c# tsql ado.net

How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table

Preserving ORDER BY in SELECT INTO

How to turn one column of a table into a csv string in SQL Server without using a cursor

sql-server tsql

Update and left outer join statements

Concatenate row values T-SQL

SQL time difference between two dates result in hh:mm:ss

sql-server tsql

Add a column if it doesn't exist to all tables?

Full join multiple tables on same columns

How to get the next identity value from SQL Server

c# sql-server tsql

Use database inside a stored procedure

What happens when you forget to close and deallocate cursor?

How to reuse calculated columns avoiding duplicating the sql statement?

sql-server tsql

Create a nullable column using SQL Server SELECT INTO?

sql-server tsql

Would transaction work across multiple DB in the same SQL server? If so, is this a Distributed transaction?