Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

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

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