Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '`'.
SQL
select `FirstName`, `LastName`
from `Person.Person`
where `FirstName` = 'Ken'
How do i make it work ?
SQL is -
select FirstName, LastName
from Person.Person
where FirstName = 'Ken'
Correct way is -
LOAD FirstName, LastName;
SQL SELECT FirstName, LastName
FROM AdventureWorks2008R2.Person.Person
WHERE FirstName = 'Ken';
Write and try like
select `FirstName`, `LastName` where `FirstName` = 'Ken';
from `Person.Person`
Correct way is -
LOAD FirstName, LastName;
SQL SELECT FirstName, LastName
FROM AdventureWorks2008R2.Person.Person
WHERE FirstName = 'Ken';