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 Mocking?
    The process of replacing a module with generic and mostly empty object, called a mock. Advantages: Isolates our code from its dependen...
  • What is a Object?
    An object is an entity that has Properties for identifying State, Methods for behavior, Events for depicting the change of State. Data ass...
  • What is a constructor and types of constructors?
    When we create a class or struct, its constructor is called. Constructor will have same name as a class or struct and is usually used to ini...