Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Trouble with Query

Viewing 1 post (of 1 total)
  • Author
    Posts

  • guitarman
    Member
    #167681

    I am going through the book “Beginning SQL Server 2008” and the first instruction they have me doing doesn’t work. I am trying to execute the following after creating the database BankOfFees.

    “I have tried and tried to post the example script here but this forum won’t let me”

    I’ve copied this exactly as illustrated from the book. When I execute I get a syntax error; Incorrect syntax near the keyword ‘VALUES’
    There is a red line under neath “VALUES” on the line with “Charles Dickenson”. When I hover the mouse over it I get “Incorrect Syntax near ‘VALUES’. Expecting ‘(‘.
    Can anyone tell me what this means or where its going wrong. I don’t understand why this simple script would be wrong in the book and doesn’t work for me. The only small issue is that the book is “Beginning SQL Server 2008” and I am using SQL Server 2008 R2 as that is the closest version to the book I have access to.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: