Dinesh's Blog :::: Being Compiled ::::

Showing posts with label Data Conversion. Show all posts
Showing posts with label Data Conversion. Show all posts
Wednesday, September 13, 2017

SQL Server TRY_CONVERT returns an error instead of NULL

›
Can this be happened? The functions TRY_CONVERT and TRY_CAST have been designed for handling errors and they should return NULL when the...
Tuesday, July 26, 2016

Result shows asterisk when converting int to varchar

›
I was sent a code by one engineer saying they he gets an odd error with one of calculations written. He gets the following error; Conv...
Saturday, February 8, 2014

TRY Counterparts for CAST, CONVERT and PARSE

›
For implementing explicit conversion from one type to another, we have been using either CAST or CONVERT functions given by Microsoft SQL Se...
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.