Aries Manlig

  • Interests: Nature and Mystic Science

SQLServerCentral Article

Think Twice Before You Convert

Have you ever lost data when using CAST or CONVERT in T-SQL? There is an interesting behavior that probably has caused problems for quite a few people, and one you should be aware of. New author Aries J. Manlig brings us a look at this documented, but mostly unheard of behavior.

3.33 (3)

2005-12-22

10,921 reads

Blogs

About blogging

By

A friend wants to get started and write a blog, and so asked me...

Daily Coping 26 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 25 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

efficient large table cleanup

By Bruin

looking for examples on doing a large table cleanup where my attribute value selected...

ODBC - Pipeline component has returned HRESULT error code 0xC0208457

By yrstruly

I am trying to connect to MYSQL as a target/destination via ODBC. I am...

Trouble connecting MYSQL in SSIS

By yrstruly

I connect to MYSQL in SSIS with MYSQL data provider. I am getting the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers