Why words in T-SQL turn blue?

by Cecille Ramirez on January 31st, 2011

This is a pretty common question for students beginning with SQL Server writing queries regardless of the version. Why some words turn blue when you type it in the query window using any T-SQL statement?

These are reserved keywords. Microsoft SQL Server uses these for defining, manipulating and accessing databases and all objects in it. It is part of the grammar of the T-SQL that allows SQL Server to parse and understand T-SQL statements. It maybe sometimes allowed using these reserved keywords for object names in a script but not recommended.

It is best to always use unique names for every object in your database. Make it a habit so you don’t encounter errors in the future. It will be difficult to analyze eventually what’s causing the error when you have overlooked the use of reserved keywords.

For the list of SQL Server 2008 reserved keywords, you can find it in this link:  http://msdn.microsoft.com/en-us/library/ms189822(v=SQL.100).aspx

Raves & Praise

Ron Cwik

PMP Certification Training, 2008

Great training facility. Great instructors. Great experience.

Jennie

Student Employment Success - Project/Process Manager

My Career Services Manager was very friendly and helpful and had excellent follow-up. She seemed to really care how things were going and kept me moving in the right direction. The resources available in job search were great and the visibility that there were jobs out there looking for my skillset was promising. Additionally, the training, as well as having an updated resume stating the Microtrain course work I had taken made me feel more confident and marketable as I looked for employment. It showed that I was dedicated and took project management and process management seriously.

D. Easter

PMP Certification Training, November 2008

Thanks Microtrain for conducting a great PMP course that set me on a successful path to obtain my PMP certification. I have passed the test!

Scott Wilson - Team Bradley

Employer Partner Feedback

Dawn has been a pleasure to work with. She is diligent in her efforts to give MicroTrain’s students the best opportunities to connect and network with various companies and players in the job market. The curriculums and certification programs are in line with today’s current IT needs. It’s good to see that they evolve with what employers are most seeking out there. I would recommend to any employer that hires skilled IT workers that they look into MicroTrain’s career services department as a potential source of candidates. The business of hiring can be quite costly, and Dawn and her staff provide a free service to outside companies. This value-add for MicroTrain’s students aligns with their mission in both training and job assistance to set up a win/win scenario for all involved.

Christopher Fowler

MCSA

Very thorough, good mix of lecture and lab work. Al is great! Keeps classes interesting and supplements required test material with need-to-know items from real world experience.

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top