One of the specific commands in question looks like this:
Expand|Select|Wrap|Line Numbers
- SELECT COUNT(DISTINCT Sno) as NumberShipping
- FROM SHIPMENT;
This commands works perfectly in visual studio 2008, but I get an error in sql server express.
The error is:
There was an error parsing the query. [ Token line number = 1,Token line offset = 14,Token in error = DISTINCT ]
I was also unable to use varchar(), float, real, and have been unable to get an "except" statement working. Does sql server express not support these commands, or did I more than likely end up with a bad installation?
Thanks!