t-sql-My Code Helper

Does the T-SQL Error Severity ...

sql-server t-sql

Why am I getting Monday as the...

sql-server t-sql sql-server-2008 date

Why does concatenating strings...

sql-server t-sql concatenation exec

Fastest Way to Count Distinct ...

asp.net sql sql-server database t-sql

Efficiently comparing DATE and...

sql sql-server t-sql sql-server-2016

How to drop all tables except ...

sql sql-server sql-server-2008 t-sql

Inconsistent results with vers...

sql sql-server t-sql

Why does our ownership chain b...

sql-server t-sql

Can I create a One-Time-Use Fu...

sql sql-server sql-server-2005 t-sql scripting

Nested SQL Server cursor has n...

sql-server t-sql cursor

DateTime2 vs DateTime in SQL S...

sql sql-server t-sql datetime datetime2

Generate Dates between date ra...

sql sql-server t-sql sql-server-2008 range

Why (and how) to split column ...

sql sql-server t-sql database-design

What are DATEFIRST's defau...

sql-server t-sql configuration

T-SQL Case expression strange ...

sql-server t-sql

Creating an index on a table v...

sql sql-server t-sql indexing table-variable

How do I grant read access for...

sql sql-server security t-sql ssms

Using unique index to enforce ...

sql sql-server t-sql

Select Only Those rows which o...

sql sql-server t-sql

How can I convert bigint (UNIX...

sql sql-server t-sql datetime unix-timestamp

UPDATE with a one-to-many JOIN...

sql-server t-sql sql-update inner-join

SQL Server select query where ...

sql sql-server t-sql query-optimization

How do I use Poor Man's T-...

sql-server t-sql formatting ssms formatter

Is it possible to exploit a qu...

sql-server sql-server-2008 t-sql sql-injection

Replace duplicate spaces with ...

sql-server t-sql

Pad a string with leading zero...

sql-server t-sql

Join a date table to a data ta...

sql sql-server t-sql

Reuse the same set of columns ...

sql-server t-sql azure-sql-database dacpac

Delete (or Select) data with s...

Using sp_executesql drop multi...

sql-server t-sql dynamic-sql database-cursor