Certain keywords are not capitalizing in Visual Studio 2010

Oliwa

Hello,

When I try to create a table in Visual Studio the data types and nullability keyword do not capitalize. I have the SQL Prompt setting to capitalize all reserved keywords and it works great in SSMS.

This is what I type in VS2010 and it stays exactly as typed...

CREATE TABLE [dbo].[SaleStatus]
(
SaleStatusID smallint not null
, SaleStatusName varchar(50) not null
)

This is what I type in SSMS and it changes as I have it configured...

CREATE TABLE [dbo].[SaleStatus]
(
SaleStatusID SMALLINT NOT NULL
, SaleStatusName VARCHAR(50) NOT NULL
)

Anu D

Many thanks for your post.

But this works for me in VS2010.

Can check if you case set for UPPERCASE in the following setting in VS2010:

SQL Prompt 5 --> Options --> Format --> Case and check the values here?

Are they all set in Uppercase here?

If yes can you reply my email with SQL Prompt Style ?

You can find how to export the Styles here.

Oliwa

Yes, my styles are set to UPPERCASE for all 3 options (keywords, functions, and types). This works fine in SSMS but not in VS.

I do not have those style options because I am using Standard Edition.

Anu D

Thanks for your post.

If you check the feature list here you would see that 'Format SQL' is not supported in Visual Studio.