Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

T-SQL Insert into table without having to specify every column

sql sql-server-2008 tsql ssms

inner join on null value

sql mysql tsql sqlite

Get week number from dates in T-SQL

date tsql

SQL Stored Procedure: If variable is not null, update statement

Is it possible to Trim all the values in a column in a single statement?

sql tsql trim

SQL problem with error "Invalid data type"

Why can't I perform an aggregate function on an expression containing an aggregate but I can do so by creating a new select statement around it?

Indexed View vs Indexes on Table

Apply like over all columns without specifying all column names?

Stored procedure hangs seemingly without explanation

Validating the existence of 350 million files over a network

c# .net sql-server tsql

What is the performance penalty of XML data type in SQL Server when compared to NVARCHAR(MAX)?

sql-server xml tsql nvarchar

SQL Server Reference a Calculated Column

Is it faster to check if length = 0 than to compare it to an empty string?

How do you turn off a specific bit in a bit mask?

tsql

Use multiple words in FullText Search input string

Why is my left join not returning nulls?

LPAD in SQL Server 2008

sql-server tsql

Get list of all database users with specified role

tsql

Join statement order of operation