How to fix cast as numeric gives error converting data type varchar to numeric.

By -

 While writing SQL queries, we may get Errors while doing cast(value as data_type) like below:

"converting data type varchar to numeric." 

Sometimes the value will be valid and still you see the error while casting. To fix this error, we can use TRY_CAST instead of CAST function.

Since when the cast fails, the TRY_CAST() function returns NULL while the  cast() function gives an error.

Syntax : 

TRY_CAST(value  AS data_type)

Comments

Post a Comment

Popular posts from this blog

how to add new line in google form questions | Fix for next line issue in google form questions

By -
  Google forms are very useful to create online assessments and quiz. These are very to create through google forms. But there are some noted issues like when some questions are added line by line, it does not allow the new line by entering 'enter' key. So to make it work, there is a solution for that:  Follow this video for steps :  https://youtu.be/oTepX4VgSCI Code to be added: function addLineBreaks() {   var form = FormApp.getActiveForm();       // find form items you need    var questions = form.getItems(FormApp.ItemType.MULTIPLE_CHOICE);      for(i = 0; i < questions.length; i++)   {     var title = questions[i].getTitle();     questions[i].setTitle(title.split(". ").join("\n"));   } }
Read more

How to add new line in dropdown type question in google forms

By -
    To add new line in google forms dropdown type question, add the following code in the script editor : code to be added : function   addLineBreaks () {    var   form  =  FormApp . getActiveForm ();        // find form items you need         var   questions  =  form . getItems ( FormApp . ItemType . LIST );       for ( i  =  0 ;  i  <  questions . length ;  i ++)   {      var   title  =  questions [ i ]. getTitle ();      questions [ i ]. setTitle ( title . split ( ". " ). join ( "\n" ));   } }
Read more