Right syntax is:
SELECT * FROM Patients
>This is the last line of my script:
>
>
>Select Patients
>
>
>I get this error:
>
>
>Msg 102, Level 15, State 1, Line 258
>Incorrect syntax near 'Patients'.
>
>
>If I put something else at the end of the script, like this:
>
>
>Set NOCOUNT OFF
>
>
>Then the error is:
>
>
>Msg 102, Level 15, State 1, Line 258
>Incorrect syntax near 'OFF'.
>
>
>What's going on?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
