What are the challenges you face when working across database platforms? Take the survey
Options

Certain keywords are not capitalizing in Visual Studio 2010

OliwaOliwa Posts: 42 Bronze 2
edited April 11, 2011 11:02AM in SQL Prompt Previous Versions
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
)

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    OliwaOliwa Posts: 42 Bronze 2
    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.
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    If you check the feature list here you would see that 'Format SQL' is not supported in Visual Studio.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.