Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

C# MSSQL alter table then modify values

c# sql-server t-sql ado.net

Select min returns empty row

sql sql-server t-sql

Tricky SQL SELECT statement - combine two rows into two columns

Escaping command parameters passed to xp_cmdshell to dtexec

Is this code safe from SQL injections? (and why)

c# t-sql sql-injection

Conversion failed when converting the nvarchar to int

sql-server t-sql

Using GROUP BY clause to replace dissimilar rows with single value

sql sql-server t-sql

How to sum dynamic columns in SQL Server?

Find records created in a period of 24hours (not especially the last 24hrs)

sql sql-server 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