A little variation:

-- this runs

DECLARE @i int = 1, @j-2 int = 2;

SET @i += 2;

SELECT @j-2 * @i

GO

-- this raises error

DECLARE @i int = 1, @j-2 int = @i...

Hugo, you always are the NUMBER ONE!

😀

WOW, another qotd with a special offer with "SUMMER POINTS"!

😀

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...