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 the 'add title and description' section in google forms

By -
Image
 Adding new line in the section 'add title and description'  in google forms can be done by running below code in the script editor : code to copy: function addLineBreaks() {   var form = FormApp.getActiveForm();       // find form items you need    var questions = form.getItems(FormApp.ItemType.SECTION_HEADER);      for(i = 0; i < questions.length; i++)   {     var title = questions[i].getTitle();     questions[i].setTitle(title.split(". ").join("\n"));     var desc= questions[i].getHelpText();     questions[i].setHelpText(desc.split(". ").join("\n"));   } } Below video will give complete steps to do this :
Read more