Saturday, March 4, 2017

Using Column Names "FROM" and "TO" in a table and trying to lnsert data into table

When in a database if you have a table with column names "FROM" and "TO" you should be careful while trying to reference these column names in your sql command.

You should enclose these column names in square  brackets so that SQL will identify them as column names and our command works as we expected without any errors.

You should enclose as shown here:

Select CompanyName,[From],[To],Skillset from WorkExperience 

No comments:

Post a Comment

Call a function in child component from parent component in React

Consider the following parent component class Parent extends React.Component { constructor(props) { super(props);         thi...