I read question and answers many times because of high score.

I was searching for the swindle!

But it's only a straightforward basic question.

😀

type_desc is Latin1_General_CI_AS_KS_WS

So, also, in a "case sensitive" database type_desc LIKE '%cons%' returns data.

I'd like also a SPLIT/JOIN function as in VB. So, given a tab/cr limited string the function returns a table and viceversa.

PURGECHAR removes a list of chars from a string.

Thank you for question!

Theoretically, any query would return different value!

In practice, Only ORDER BY NEWID() works for us.

grzegorz.mozejko (6/16/2014)

---

grzegorz.mozejko (6/16/2014)

---

very usefull, thx

a small correction, when name of first index column is begining part of second index column (add comma):

...

Replace:

STUFF((SELECT ', ' + COLUMN_DATA_KEY_COLS.name

with:

STUFF((SELECT ', ' + COLUMN_DATA_KEY_COLS.name + ' ' +SUBSTRING('+-',INDEX_COLUMN_DATA_KEY_COLS.is_descending_key+1,1)

Thanks for the Article.

I voted it with 5 stars.

But there's only a hole:

Your query doesn't consider the order on columns.

Example:

create index idx_MyTab on MyTab(col1,col2)

and

create index idx_MyTab_1 on MyTab(col1 DESC,col2)

So, in...

Thanks!

declare @t varchar(10) = 'FALSE'

,@b bit

SET @b = CAST(@t as bit)

select @b

WHERE @b = 'FALSE'

http://msdn.microsoft.com/en-us/library/ms174378%28v=sql.110%29.aspx

Raghavendra Mudugal (5/30/2014)

---

Good one, thank you for the post.

Agreed F6 and SHIFT+F6 - both works. But they are not the same.

F6 in SSMS is "move to the next pane"...

Also SHIFT+F6. These hot keys are windows standard.

Unbelievable!!!

Someone get it wrong!

😀

TomThomson (5/8/2014)

---

naas2005 (5/8/2014)

---

Just a note on the tinyint - to store negatives in one byte the rightmost bit of the byte (111111 0) would need to be used to sign...

stephen.long 56048 (5/5/2014)

---

The list shown here includes bit in the list of "exact numeric types".

http://msdn.microsoft.com/en-us/library/ms187752.aspx (Data Types (Transact-SQL))

The definition of bit, shown here, calls it "An integer data type that...

In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you...