New post in Tsql

quering remote database using sql server?

September 28th, 2020

linked-server sql-server tsql

How to check if first five characters of one field match another?

July 31st, 2022

database sql-server sql tsql sql-server-2008

Getting the 'date' out of a DateTime field in SQL Server

April 14th, 2020

sql-server datetime sql-server-2008 tsql

SQL how to cut off string

June 7th, 2020

sql-server sql string tsql

how i can retrieve rows by specific date in sql server?

July 23rd, 2022

date tsql sql-server sql

How to remove duplicates from table using SQL query

August 7th, 2022

tsql sql

Dynamically create temp table, insert into temp table, and then select

July 12th, 2022

tsql insert temp-tables sql-server

declare variable in teradata

January 4th, 2020

teradata tsql

Temporary table delete row

July 12th, 2022

tsql sql

Remove all apostrophes in field with T-SQL

August 17th, 2020

sql-server tsql

Left outer join on multiple tables

June 6th, 2020

sql-server tsql sql

Using LEFT on a TEXT-field in SQL Server

September 12th, 2020

sql-server sql-server-2008 tsql sql

SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?

August 1st, 2022

sql sql-server tsql ssis

Conversion failed when converting date and/or time from character string Error

December 31st, 2020

tsql sql-server-2008-r2

Convert from varchar into date in SQL Server

January 15th, 2020

sql tsql sql-server sql-server-2012

ORDER BY ROW_NUMBER

August 1st, 2020

tsql sql

How do I remove "duplicate" rows from a view?

July 15th, 2020

sql-server-2005 sql tsql

SQL IF ELSE BEGIN END

October 29th, 2020

sql if-statement tsql

How to select only year from a Date Time TSQL

May 9th, 2020

sql tsql sql-server

SQL Query to Filter a Table using another Table

December 5th, 2020

sql-server-2008 filter select tsql sql

SQL Date Compare by only using Date not Time

July 9th, 2022

sql tsql sql-server date-comparison

Get date from int (YYYYMMDD)

September 24th, 2020

date database sql-server datetime tsql

TSQL Round up decimal number

April 5th, 2020

tsql rounding sql-server

Comparison Query to Compare Two SQL Server Tables

October 22nd, 2020

sql-server sql comparison tsql

LEFT OUTER JOIN (SELECT * FROM TABLE) is this possible?

May 18th, 2020

sql-server tsql

How to insert a float number with quotes into a numeric field?

June 7th, 2020

sql-server-2008 varchar floating-point tsql sql-server

SQL Server : creating Temp Table with dynamic column

July 9th, 2022

tsql sql-server dynamic temp-tables

Concatenate column values for rows with the same values (of different columns)

June 21st, 2020

group-concat tsql sql-server

Update table using Openquery linked server

May 10th, 2020

sql-server sql sql-server-2008 tsql openquery

Conversion failed when converting the nvarchar value to data type int

April 4th, 2020

tsql sql sql-server