Guest Dark_Pegasus333 Posted February 9, 2006 Share Posted February 9, 2006 There is a problem I noticed while looking through the SQL tutorial in the "Aliases" section. In your example this was the code you specified:SELECT LastName AS Family, FirstName AS NameFROM PersonsThis wouldn't give the headings EXACTLY as you have them written. On the contrary, "Family" and "Name" would be written in all capital letters. Instead the code should read:SELECT LastName AS "Family", FirstName AS "Name"FROM Persons Link to comment Share on other sites More sharing options...
aspnetguy Posted February 9, 2006 Share Posted February 9, 2006 good point, I never noticed that before.I always enclose in (") in my staements as well. Link to comment Share on other sites More sharing options...
Skemcin Posted February 9, 2006 Share Posted February 9, 2006 I've always used square brackets:SELECT LastName [Family], FirstName [Name]FROM Persons Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now