Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

How to get a negative rownumber in sql server

Spread a table in a date time interval

Expand "From" & "To" date columns to 1 row per day within that range

Generate **bare** CREATE TABLE and CREATE PROC statemnts in SQL Server

T-SQL Transform unicode to emoji

t-sql unicode emoji

If a primary key is NOT NULL, then should a foreign key that references it be specified also as NOT NULL?

SQL Server INSTEAD OF INSERT trigger failure

Getting value from stored procedure in another stored procedure

t-sql stored-procedures

Self-join on a non-key column

TSQL to insert a set of rows and dependent rows

Getting the most recent entry per group in a select statement

sql sql-server t-sql

TSQL CTE Error: Incorrect syntax near ')'

TSQL: Split one column into two based on value

sql sql-server t-sql

how do you pivot sql data without aggregating a column

Is there any way to do select on top of WITH clause in a SQL Server CTE?

retrieve the most recent record for each customer

What does SQL Server return to C#

Using SQL STUFF to concatenate rows that I cannot group by

sql sql-server t-sql

How to right join a date table in T-SQL?

sql sql-server t-sql join

Invalid column name SQL Server 2012