Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Create JSON with children in SQL Server (structure for web tree)

T-SQL select script with union

sql sql-server-2008 t-sql

Is it possible to write an "insert into" statement for a single column table?

t-sql

1 and 0 not recognized as boolean constants in T-SQL

t-sql

How to encode XML in T SQL without the additional XML overhead

sql sql-server xml t-sql

Copy from one table to another and replace with SCOPE_IDENTITY

sql-server t-sql

Tricky where clause

How to compare two columns in SQL server

Trying to create a large dynamic query, keeps getting truncated

doing a simple pivot on year

Merge when not matched by source without deleting other rows

sql sql-server t-sql

SQL Query based on a while loop

sql t-sql select while-loop

Howto build a SQL statement with using IDs that might not be available in the table?

using group by and maximum

sql t-sql

What is better to return a single value in TSQL stored procedure: a RETURN or an OUTPUT?

Entity Framework and large queries. What's practical?

c# linq t-sql entity-framework

SQL 2008 - resultset order issue

Calling a Stored Proc from within a Stored Proc and returning a recordset

sql-server t-sql

Select values that SQL JOIN fails on

sql sql-server t-sql