May 1, 2016 at 8:49 am
Hi,
How to show CAPS lock status in Management Studio status bar to know if CAPS Lock is on or off.
Thanks.
May 3, 2016 at 10:37 am
SQL server determines case sensitivity by COLLATION.
COLLATION can be set at various levels.
Server-level
Database-level
Column-level
Expression-level
Here is the MSDN reference--https://msdn.microsoft.com/en-us/library/ms143726.aspx
Check Server Collation--
SELECT SERVERPROPERTY('COLLATION')
Check Database Collation--
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;
Check Column Collation
select table_name, column_name, collation_name
from information_schema.columns
where table_name = @table_name
May 3, 2016 at 1:03 pm
amar_sharma (5/1/2016)
Hi,How to show CAPS lock status in Management Studio status bar to know if CAPS Lock is on or off.
Thanks.
How many times are you going to ask the same question that you've already been given an answer to? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2016 at 5:09 am
@jeff Moden, :blink: It was on the same day, as, didn't get any reply and views were increasing, so, being a newbee, I doubted myself, whether I have asked in the right Group or not and hence came this one, but, swear, there is no 3rd instance anywhere on the web.... :exclamation: ... But I am very appreciative of, that, you were able to hit it here too.... !!! Thanks again..!:satisfied:
@abhiseck, thanks for explaining COLLATION ....
May 4, 2016 at 7:41 am
You could ask directly to Ken Van Hyning, who is the SQL Client Tools Engineering Manager at Microsoft.
P.S. We're everywhere and we see it all. 😀
May 4, 2016 at 8:38 am
amar_sharma (5/4/2016)
@Jeff Moden, :blink: It was on the same day, as, didn't get any reply and views were increasing, so, being a newbee, I doubted myself, whether I have asked in the right Group or not and hence came this one, but, swear, there is no 3rd instance anywhere on the web.... :exclamation: ... But I am very appreciative of, that, you were able to hit it here too.... !!! Thanks again..!:satisfied:@abhiseck, thanks for explaining COLLATION ....
Ah... got it. Thanks, Amar.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2016 at 2:16 pm
my keyboard has a light to signify caps lock on or off, isn't that significantly easier than asking for one specific application to show it's status? just glance at the keyboard?
Lowell
May 4, 2016 at 3:01 pm
SQL Prompt will automatically adjust the case, so I don't care whether caps lock is on. Also, it becomes quickly obvious as you're typing that the wrong case is being used. (As a touch typist that uses a soft keyboard mapping that doesn't match the physical labels (Dvorak), I almost NEVER look at the keyboard.)
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
May 6, 2016 at 5:27 am
You are welcome, Jeff. It was a pleasure to see your replies on the post..!!
Thanks.
May 6, 2016 at 6:07 am
amar_sharma (5/6/2016)
@Luis Cazares, I'll try that. Could you please help me with his genuine email?Thanks.
Why do you think I have it?
And if I did, I wouldn't share it to anyone, unless it's already publicly available.
Another option is to file a Connect item and get enough votes on it.
May 6, 2016 at 6:20 am
amar_sharma (5/6/2016)
You are welcome, Jeff. It was a pleasure to see your replies on the post..!!Thanks.
Thanks for the feedback, Amar. Just to be sure, most of the heavy hitters at least look at "Posts Added Today" under "Recent Posts" in the menu above. That covers ALL the forums available on this site. With the number of members on this site, you'll frequently get a lot of "views" with no answer before someone actually answers and is sometimes because people are trying to find the answer to a similar problem and have no solution of their own to offer. Unlike some of the "stab'n'grab' forums out there, it's usually well worth the wait, especially on code or complex problems. People are actually encouraged to offer different opinions and levels of detail even if an answer has already been posted, which I think is really cool because the discussions are where the real learning is at.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply