How can we help you today? How can we help you today?

Certain keywords are not capitalizing in Visual Studio 2010

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
)
Oliwa
0

Comments

3 comments

Sort by
  • 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.
    Anu D
    0
  • 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.
    Oliwa
    0
  • 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.
    Anu D
    0

Add comment

Please sign in to leave a comment.