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 
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

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...

  • what is the difference between web service and a web application?
    Web Application:Any application which we can run in our web browser is a web application. Web Service:A web service is an Application Prog...
  • Explain Amazon Cloudfront
    Amazon cloudfront offers a simple cost effective way to improve the performance, reliability and global reach of your entire website for s...
  • p5.js
    p5.js is a JavaScript library which can be used by artists,designers,educators and beginners who want to code. Using p5.js we have a full se...