SSMS Autocomplete

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Check if the "Casing for built-in function names" option (under Tools --> Text Editor --> Transact-SQL --> IntelliSense) is what you need

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Scott Arendt SSCrazy Eights Points: 8218 More actions · Answer 2

Pradeep-

Thanks for the reply, but that did not contain an option for case sensitivity.

Regards,

Scott

Adiga One Orange Chip Points: 27284 More actions · Answer 3

I was referring to "Casing for built-in function names" under that option.

But it seems to control the casing for BUILT-IN Function only

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 4

ALTER DATABASE Adventureworks SET SINGLE_USER WITH rollback immediate;

go

ALTER DATABASE Adventureworks COLLATE SQL_Latin1_General_CP1_CI_AS;

GO

ALTER DATABASE Adventureworks SET MULTI_USER;

GO

I guess this is what you want .

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]