Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in t-sql

Stored procedure (SQL Server), can't find the issue

Row-level security based on IS_MEMBER function

Get XML from different Tables

sql sql-server xml t-sql

SQL Server: Check Upper Case or Lower Case after certain Character

Querying all records are true in sql-server - is casting expensive performance wise

sql-server t-sql

Get all overlapping date ranges when all overlap at the same time

sql sql-server t-sql datetime

Using aggregate function in a CTE query

sql-server-2008 t-sql

Counting Distinct users over time

Bypassing character limit on OPENQUERY failing use EXECUTE

How to set a negative result to zero without typing the formula twice

How to set yearly jobs in Sql Server Agent

Select for each record multi records

sql sql-server t-sql

Select rows and Update same rows for locking?

Not sure how to go about joining these two tables

sql sql-server t-sql join

Very slow T-SQL stored procedure sped up by dropping and recreating

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