Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in tsql

How to suppress the output of `DBCC SHRINKFILE`?

tsql

RODBC command 'sqlQuery' has problems with table variables in t-SQL

r tsql rodbc table-variable

Why the LAG function in T-SQL is non-deterministic?

LAG functions and NULLS

Return rows where field contains non alpha-numeric characters

sql tsql sql-server-2005

Strange CAST behaviour with INT and a single hyphen ( - )

sql-server tsql casting int

Updating a table from a table variable

if statement in SQL computed Column Specification

Foreign key constraint - how to delete referenced record?

sql sql-server tsql

.NET TransactionScope class and T-SQL TRAN COMMIT and ROLLBACK

Is there a clean T-SQL query I can use to verify an index has the right columns?

sql-server tsql indexing

How to concatenate two strings in sql and pad one string with 0's?

sql-server tsql

How do I return multiple datatables from a SQL Server stored procedured?

Equivalent to VB AndAlso in SQL?

SQL Server ORDER BY/WHERE with nested select

How do I join on "most recent" records?

sql tsql sql-server-2000

Is there any reason why you cannot select a statement as a bit in SQL Server?

sql sql-server tsql

How to delete or truncate table in SQL Server?

sql sql-server tsql

Can UNION ALL be faster than JOINs or do my JOINs just suck?

tsql sql-server-2008

What's the cheapest query I can run to see if there are any rows in the table?

tsql